Jan 22, 2020 11:34 AM
Hello,
I need to have daily batches run that update a field in multiple records. I have it setup in Zapier, but can only get it to run one time against a single record. I want it update every record inside a specific view. Similar to how the “Batch Update” block in airtable works, but automated. Any of the following would fix my issue but seems none of them exist?
Seems like all of these actions should exist… But can’t seem to figure out how to do any of them!
Any help is appreciated, thanks in advance!
Jan 22, 2020 11:45 AM
Jan 22, 2020 11:55 AM
Thanks, I’ll take a look at it. Ideally I would like to find a solution that doesn’t require an additional third party service to be used.
Feb 05, 2020 01:09 PM
Airtable API and a scripting environment. G-Suite is ideal for this and near-free regardless of how many processes you run.
Apr 01, 2020 08:51 AM
Try Coupler.io Google sheets add-on that will synchronize your data between Airtable and Google Sheets.
What you need to do:
Connect Airtable to Google Sheets via Coupler.io
Switch on the data refresh frequency to 1 hour, and your data will be always up-to-date in your destination sheet (in Google Sheets).
Name that sheet raw data, then create formulas or dashboards in new sheets and reference the data from the raw one.