Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 05, 2024 10:20 AM
I'm trying to create an airtable that will intake many records over the course of day (numbers) in individual rows and then get the sum total of all rows by day. i want the sum to be its own output (i.e. not just the "grouped by" sum function) so i can use it for other uses and visualizations.
i have my main table created and the intake form. however, when i try to create a second table and link records, i can't quite figure out how to (1) automatically import records as they come in and (2) create a sum by date in that table.
Apr 05, 2024 08:49 PM
Try creating a formula field that outputs the created time in a unique day format using DATETIME_FORMAT, something like "DD MMM YYYY"
Then create an automation that'll trigger every time a record gets created and its action will be to paste the value from that formula field into the linked field to the second table
This'll link everything up properly and you can use a rollup field with SUM to get the value you want
Apr 06, 2024 10:09 AM
Thank you! This was exactly what I needed. I was thinking that there would be a rollup answer without first doing the summary formula. Appreciate your help!