Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automatic summary table

172 0
Showing results for 
Search instead for 
Did you mean: 

Hey guys,

I have a weather station that logs data to an Airtable every 5 minutes.

I can easily access daily summaries if I group the records by date/day, but I cannot use them for anything.

So, as suggested in this forum, I created another table to act as “pivot”, linked records by date/day, and then used rollups to get minimum, maximum, and averages.

What I would like to do is have this system update automatically. I’ve tried to update the linked field, both using the logger (a POST curl) or airtable automations, but it remains unchanged.

Is another way to do this? Thank you

0 Replies 0