Hi there
I have a list details block mapped to Quotes table (in Airtable).
Within this is a table mapping to child table ( Quote line items).
I have another table elow which maps to the parent table (Quotes) - I want this Quotes table to display the rollup total value of all Quote Line items underneath the Quote line items table.
Any advise on this? Or better way to do this?
Thank you!
Hi there.
This can be done, but you’ll need to be creative with it. I would do the following:
In airtable (or our DB), create the calculation and save it in the DB.
In Softr, get another block that is able to dynamically show that total amount, and display it on the page.
Maybe one idea could be to display this total number at the top of the page in either a feature block, or a detail block that is stripped down to only show that number?
Hi George, in the Quotes table, I’d recommend having a rollup field that sums the values of all the linked Quote Line Items records. The rollup field should look like this:
Select rollup source: Quote Line Items
Quote Line Items field you want to roll up: Line Item Value
Aggregation formula…: SUM(values)
Just to confirm, the way to configure the table is to have a list details page for Quotes, with a list block with a conditional filter (which you already have), followed by a list details block with a conditional filter (which I assume you have but am not entirely sure).
You will display the rollup field in the list details block on the bottom, which may look weird formatting-wise, but you can adjust the padding of both blocks to make the value appear inline with the table above it in preview mode.
Thanks guys. Have worked out why I couldnt display the rollup field correctly… I had to set a filter on the field within parent table based off shopping cart status pulled from child table
