Displaying cumulative sums

[bartdubs]

How would I display the sum of this column and make it such that every time a new record was added the sum is updated with the new information so that it is usable information on softr?

[TheTimeSavingCo · Accepted solution]

I think you'll need to create another table called "Rollup" or something and make sure to link all the records you want to sum up to a single record in that "Rollup" table

Then, you'd create a rollup field with "SUM(values)" to sum everything together

Finally, create an automation that'll automatically link any newly created record to that one record in the "Rollup" table and it should update as expected