cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to perform the following editable grid?

SOLVED
Highlighted
Contributor

How to perform the following editable grid?

Hi there,

How can I perform the following editable grid.? Can some one guide me through the step by step execution? Thanks in advance. 

 

https://www.youtube.com/watch?v=FISQHoNV6qo

www.ThingWorx.com An example of the Editable Grid
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How to perform the following editable grid?

Hello!

 

As you can see in 1min30" in the video, he is using 3 Services to handle the values in the DataTable:

GetDataTableEntries - to load the values into the grid (as you can see in the Connections tab displayed in 1min32')

AddOrUpdateDataTableEntry - to add a new entry or to modify an existing entry (as you can see in the Connections tab displayed in 1min40" --> please note that he uses a second Grid to modify the values in the DataTable and he loads the entry he wants to modify by using the "Selected Row(s)" output from GetDataTableEntries)

DeleteTableEntryByKey - to delete an existing entry

 

You need to create your own Services in the DataTable to fit your usecase. You can use the snippets from the Services mentioned above as an example.

 

You can use Buttons to trigger the Services, as displayed in 2min06":

When Button "Add Update" is Clicked, the Service AddOrUpdateDataTableEntry is executed, and when this Service runs, the new DataTable values after modification are loaded in the grid.

Please note that you need to use the "EditedTable" Infotable from the edited grid as Input Parameter of the Service "AddOrUpdateDataTableEntry" (obviously, the Service needs to now which values he has to modify).

 

In general, the video is quite explanatory (play the video, stop the image with every action the guy mentions and look at the details in the image in order to try to replicate his design on your system).

I hope the notes above help you to achieve your usecase.

 

Good luck!

Vanessa

View solution in original post

1 REPLY 1
Highlighted

Re: How to perform the following editable grid?

Hello!

 

As you can see in 1min30" in the video, he is using 3 Services to handle the values in the DataTable:

GetDataTableEntries - to load the values into the grid (as you can see in the Connections tab displayed in 1min32')

AddOrUpdateDataTableEntry - to add a new entry or to modify an existing entry (as you can see in the Connections tab displayed in 1min40" --> please note that he uses a second Grid to modify the values in the DataTable and he loads the entry he wants to modify by using the "Selected Row(s)" output from GetDataTableEntries)

DeleteTableEntryByKey - to delete an existing entry

 

You need to create your own Services in the DataTable to fit your usecase. You can use the snippets from the Services mentioned above as an example.

 

You can use Buttons to trigger the Services, as displayed in 2min06":

When Button "Add Update" is Clicked, the Service AddOrUpdateDataTableEntry is executed, and when this Service runs, the new DataTable values after modification are loaded in the grid.

Please note that you need to use the "EditedTable" Infotable from the edited grid as Input Parameter of the Service "AddOrUpdateDataTableEntry" (obviously, the Service needs to now which values he has to modify).

 

In general, the video is quite explanatory (play the video, stop the image with every action the guy mentions and look at the details in the image in order to try to replicate his design on your system).

I hope the notes above help you to achieve your usecase.

 

Good luck!

Vanessa

View solution in original post

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!