Sub total of nested form values

I have a nested form called costing which has the prices and who the price is assigned to (vendor, Ikon, Miscellaneous) i also have 3 seperate fields called vendor total, ikon total and miscellaneous total, in which i want the sum of line total against each cost head.

Welcome to the AppSheet community.

Are these SUM or TOTAL columns real columns ?

if so you could use reference actions. The sample app below shows updates from parent to child. You could use a reverse flow.

https://www.appsheet.com/samples/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e73-3d26-475c-a8f8-9911f5015920

1 Like