Hi Community ,
My Q is around updating tables in my App without having to manually opening and Save them through the interface?
I would like my app to automatically about the child tables that reference it without manual intervention.
Imagine a diet App:
I have a diet ingredients data table:
The different ingredients are the main source of data entry and this has data referenced form another table that provides the level of Calcium, Protein, Fat sodium etc
There is another table - a Totals Table that totals these ingredients and the totals of Calcium, Protein, Fat sodium etc - there is no user input required as these are all calculated (totalled) fields.
How am I able to update the Totals sheet without manually having to open and save each time there is a change in the ingredients table.?
I then have additional sheet that uses these totals in other calculations but I imagine that the answer to above will allow me to resolve the same issue with it.
I have tried both Static and Virtual columns but neither seem to do what is required ?
Any Assistance would be greatly appreciated !