I have a mashup with an advanced grid that displays data coming from sql server database. I want to be able to add and remove rows in order to add or delete row data. I was able to add two two advanced grids. Grid one showed all my data and grid two was empty. I was only able to select multiple rows by holding ctrl button. That's the only way I could pass data to the other advanced grid. Is there another way of doing this? I want a user within the mashup to be able to add/delete rows.
Multi-selecting rows using CTRL is the standard way of multi-selecting, why would you want another way?
It is unclear, what the real question is.
Also, please note that your version of Thingworx is out of support for almost a year. You might want to use a current version.
you can use the "List Shuttle Widget" to select items from an existing list, the source, and place them on a new list, the target.
However, you can move an element to the destination list only once. Otherwise you have to create a workaround with 2 grids.
There doesn't seem to be a List Shuttle Widget in the version of ThingWorx I am using(8.4.5).
But this widget would seem to resolve the issue of selecting from a source and placing on a new list (the target).
Is there something like the "List Shuttle Widget" in this version I am using?
unfortunately I can't tell you from which version the widget is available.
But the TWX 8.x documentation says: "These widgets [include List Shuttle] are displayed in the Themeable category in the Widgets panel."
Yes, I read that in the documentation. Tried to look through all the widgets in the panel but the list shuttle was not one of them. I did see other posts where it mentions the list shuttle being in version 9.
if the shuttle list widget really doesn't exist I recommend you a workaround.
You need a grid which shows the "available data" (I call it Source-List). Then you need another grid, for the target data (I call it Target-List). Behind the Target-List there can be a DataTable (e.g. with User-Name as PrimaryKey), where the selected rows are stored. Then you add some buttons that either add the selected row from the source list to the target list or delete the selected row from the target list (DataTable).
In this workaround you can add parts of the source list several times to the target list. If you want a row to be available only once, you have to extend the functionality a little bit.