Solved: Expression to recalculate all rows in a table (chi... - Page 2

CHRISTOPHE_CHAN · 01-31-2020 08:01 AM

Hi,

I try to set an action and a workflow to update correctly all rows of a table containing sums of related table rows. I need to update the sum colum of the parent table as soon as there is an add/edit/delete in the child table.

I think I understood the concept of worflows to watch changes in child table but I don’t understand what kind of expression is needed in the action to be linked with the workflow. Any suggestion ?

Thanks

MultiTech

This is what I was trying to show in the second video, it shows how I’ve setup a “Data: Execute an actin on a set of rows” action type to update the parent.

Instead of putting the summing column into the list([Column]) space, you need to put the ref link of the parent there. The system is looking for a reference, technically a list of references (or records).

These data change actions can be a little tricky:

Expression to recalculate all rows in a table (child/parent)