- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2023 01:13 PM
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?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2023 07:02 AM - edited ‎Aug 11, 2023 08:05 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2023 07:02 AM - edited ‎Aug 11, 2023 08:05 PM
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
