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

Send the selected list item to a table

  • February 5, 2020
  • 1 reply
  • 1321 views

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?

Best answer by raluca_edu

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

1 reply

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

1-Visitor
February 5, 2020

Hello,

 

should i create the service inside the datatable? 

17-Peridot
February 5, 2020
Not necessarily, you can create it in any thing, you can find the service in Code Snippets.