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?
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
1 Like
thanks
1 Like