Updating a column based on a different table

Hi,

I have two tables Customers & Products and I have a grand total field in Customers which I want to be getting auto updated based on products added rows against a customer. I can’t use a virtual column to do this as I require the Grand Total column in Spreadsheet.

Is there a way we can achieve this?

You could use reference actions. The sample app below updates the real column in the child table based on change the parent. You could use the reverse flow if required.

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

2 Likes