Skip to main content
gourinaik981-Visitor
1-Visitor
February 5, 2020
Solved

Send the selected list item to a table

I have created a DataShape having 3 field definitions and binded the GetFieldDefinitions service to the list widget. Now i want to send the selected item in the list to a datable or a database. how do i do that?

raluca_edu
raluca_eduAnswer
17-Peridot
February 5, 2020

Hi,

 

Create a service with input infotable (this is coming from SelectedRows of the list). In this service you can add info in a datatable already created, with service AddorUpdateDataTableEntry. Unfortunately, there is no service that creates datatable that I am aware of.

Same can be achieved if you want to insert data in a Database (you need a Database Thing that is connecting to the database), providing SelectedRows as input to a service, iterate through infotable and insert field/value in database.

Make sure ValueField property of List widget has the correct value (it should be the name of the field in your case).

 

Hope it helps,

Raluca Edu

View in thread

3 replies

raluca_edu
raluca_edu17-PeridotAnswer
17-Peridot
February 5, 2020

Hi,

 

Create a service with input infotable (this is coming from SelectedRows of the list). In this service you can add info in a datatable already created, with service AddorUpdateDataTableEntry. Unfortunately, there is no service that creates datatable that I am aware of.

Same can be achieved if you want to insert data in a Database (you need a Database Thing that is connecting to the database), providing SelectedRows as input to a service, iterate through infotable and insert field/value in database.

Make sure ValueField property of List widget has the correct value (it should be the name of the field in your case).

 

Hope it helps,

Raluca Edu

Translate
    gourinaik981-VisitorAuthor
    1-Visitor
    February 5, 2020

    Hello,

     

    should i create the service inside the datatable? 

    Translate
    raluca_edu
    raluca_edu17-Peridot
    17-Peridot
    February 5, 2020
    Not necessarily, you can create it in any thing, you can find the service in Code Snippets.
    Translate
      Terms & ConditionsAccessibility statement