Update child from parent table dynamically

[abood89]

Hello What would be the best approach to update child table from parent one dynamically? i tried virtual column it worked but i need the value to be stored into the sheet

[WillowMobileSys · Accepted solution]

The answer depends what you mean by "dynamic".

If you are referring to making changes to a Parent row and then automatically applying updates to a child row, then there is a way to do that using the "Form SAved" behavior.

Each Form view has a Behavior section and within that is a "Form Saved" property.  This is  place where you can attach a custom action you create to perform additional activities automatically.  In your case you can use this feature to provide a set of actions that will apply changes the child rows.

Once you have the custom action attached, whenever you save that Form view, the rows associated with the view are saved first and then any attached actions are executed.

[abood89]

Thanks for the info