Hi all, I have faced this kind of issue before with related records. I have a number of groups, each with related products/material quantities within them.
Part of the process is bringing these related product items into an Order Details Table and when that happens the status of each item changes from being "To be Requested" to “Requested”.
I have status’ related to each Group i.e. parent table, that allows for approval to be made and draw off status to change. Its a manual process as of right now but I think users would feel better having this chnage automated.
When the items are being requested/added to another table they have to select a number of lines individually using multi select and this takes time and a lot of syncing (especially when the action is adding to another table and then in a grouped action chnaging the requets status to “Requested”).
After which they again have to manually select that the listy of products has been “Drawn Off”.
The click the “Drawn Off” button to do so. From previous attempts I know that if I try and automatically update this column based on a list of child record I will receive an error. So is there any workaround or proper syntax that works in this case.
I also considered workflow change data but the data that is changing is a different table than the one needing updated.