Dear Community!
I'd like to ask your advise/help regarding the new feature in Thingworx 9.7 for GRID's Dropdown list.
We have been waiting so long to have OOO the functionality to have a dropdown list in Grids, however we are struggling to get the most out of it.
The configuration both with Service/Config is working. (Configuring Grid Columns to Display Dropdown Lists (ptc.com))
We have a UseCase, where the users need to select a given value from the grid dropdown list, however the List as normally, displays the value selected, and it is passing further to any data we bind to.
The problem we are facing, that we would need many columns as dropdown, but with different Display Value, and different actual Value .
(Just like a normal ptc-dropdown. Once you bind an infotable to the data property, you can choose the Display Field and Value Field)
- for example: Service returns infotable of RoomInformation : (RoomId, RoomName, RoomDescription)
- the RoomId as a primary key (usually) is not so meaningful e.g. 8723987 , while the RoomName is e.g.: Packaging Room Number 7.
- Due to this, we want to work further with the KEY (RoomId), as that holds the whole Room information, no just the name.
This is something that the GRID Dropdown column as per our current experiences are not capable of.
(Of course if you have only some basic dropdown values like, "yes-no, 1-10 numbers" etc. that is not representing real things and not depending on any other field, the dropdown is great!)
Hence I'd like to ask for any advise, solution, configuration experience out there that could be helpful using the DropDown column in GRID that way!
Thanks for any help!
