Currently, there is no mechanism to allow us to choose multiple child items in one dropdown so I am trying to build one.
My use case is adding Assigned Technicians to a WorkOrder. I want to select multiple technicians using an EnumList and then add those picked techs into the Assigned Technicians child table on saving of the form. Later each technician will update their time on the job site, recorded in this same child table.
I can create the EnumList to select multiple technicians with no problem. I am now trying to create a set of Actions to insert these picked techs into the child table.
I need to be able to add the Order ID as well as the Tech ID. And I need to do it once per picked technician.
The only Action type that makes sense is “execute an action on a set of rows”. This will allow to cycle over the picked list and perform the add for each picked technician.
But once I navigated through the Actions to the point to perform the add, while I do have the Tech ID from the picked list, I no longer have access to the Parent row to get the Order ID.
Using “add a new row to another table using values from this row” will only allow adding of a single row. I need to do it once per selected technician.
Any suggestions on how to overcome this challenge?