I’m trying to include a UD field from the JobHead table (JobHead.Number01) into the TimePhase grid in Application Studio, but I haven’t had any success yet.
- JobHead.Number01 is already available in the JobHead dataview.
- I added a Number01 column to the TimePhas dataview (unbound field).
- I tried using a Row Update action to populate TimePhas.Number01 with the value from JobHead.Number01, but it only updated the first row with [Object Object], and didn’t apply to the rest of the grid.
- I also attempted to use a REST-ERP call/event, but couldn’t figure out how to isolate the update to just the Number01 field in the TimePhas dataview.
What’s the best practice for populating a custom field in one dataview with data from another, especially for all rows in a grid?