Sum field based on different table not updating

AppSheet AppSheet Q&A
, ,
1

Hi,

I have 2 tables, 1 for Groups and 1 for Customers, every customer is under a group, there is a Total field in the Groups table, which calculates the total for all customers under this group, with the formula:

Sum(Select(Customers[Total], [Group]=[Group Name])).

The problem is that it will only update when I edit this group row, and save again.
How can I make it update automatically?

2

You need to create a virtual column for that formula.

2 Likes
3

The virtual column works but then the correct sum is only shown in the app. The table is not updated until you edit and save again.

Is there a way to update the table total???

4

You can run a scheduled bot to update the total in the table.