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