Solved: Appsheet Database as a Data Source - How to auto u... - Page 2

CANA-IT · 01-16-2025 12:52 PM

I have an Appsheet Database which supports my App.
I have numerous columns which are calculated and totaled in another column.
This works fine when the data is initially entered via a form.
I setup a Virtual Column to auto-update the "Total" column if any corresponding columns in the equation are changed, this also works fine in the "App".
The data in the "App" is up to date, when looking at the Database after information gets updated in the "App" the columns which were updated are correct, the "Total" column in the Database remains totaled with the initial data.
I have added a script initiated by a bot to update the database (as I had done in Tables.120 and it worked fine) but it does not update.

Is there any solution to automatically updating a Database "Total" column after relevant columns have been updated and show that they are updated.

Thank you.

Trevwiller

If you are using this in appsheets in the initial value then yes that is wrong function layout. You can just get the SUM of all of your columns as below

SUM(LIST([PlannedLodgingCosts], [PlannedLodgingTax], [AirFareCost], [BaggageFees], [AirportParking], [AirportParking], [HometoAirportRoundtripPOVCost70], [DrivingtoDestinationCost70], [RentalCar], [FuelRentalCarOnly], [Conf_RegFees], [OtherCostsTotalOnly]))

Set the inital value of all of these columns to 0. Skips your need for the IF() statements

That will get your total value column. make the column a reset on edit. that way any time that the columns listed above change in value they the total will always update from the change.

View solution in original post

Appsheet Database as a Data Source - How to auto update the Data