Add a entry and update another

[quamie911]

I have two tables . 1 has a record of trips with mileage, fuel , and the amount of money that was spent on a single trip. The 2nd table is a Dashboard with totals . How do I get the trip totals to carry over to the dashboard? And when I add a new trip , how can I get the dashboard to auto update?

[1minManager]

The easiest way is to create some virtual columns in the dashboard view that does the adding up for you.  Something like:

SUM(Select(Trip[Mileage],TRUE))

https://help.appsheet.com/en/articles/919891-virtual-columns

https://help.appsheet.com/en/articles/2357314-select

https://help.appsheet.com/en/articles/2357307-sum

Simon@1minManager.com

[quamie911]

thanks