Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 12, 2021 12:25 AM
Hi! I have an issue with an automation that I’ve created today. The purpose of my automation is to get all the people without a specific status into a new sheet. But right now all the values are stored in one row instead of seperates.
So, what I try to do is to get clients every week into an accountability sheet so I can follow up.
Is there some workaround for this?
May 12, 2021 05:09 AM
Unfortunately, Airtable doesn’t support this basic functionality. You would either need to write your own custom JavaScript to handle this, or use a no-code automation platform like Integromat.
May 12, 2021 09:45 AM
This is entirely possible if you set up your Automation differently. The Create record
action’s name is singular for a reason, it is intended to create only a single record.
Instead of having your automation trying to do things in bulk, you need it to run individually per record. Your trigger would likely be either When record matches conditions
where the condition is {Current Status} has none of Drop out, Graduated
or When record enters a view
and set the filters for that view accordingly. Then Airtable would run the Automation for each record that meets the necessary conditions and you’d no longer need the Find records
step.
I’m going to guess you’re using some sort of time-based trigger for your automation. If you still require the time-based component you could add a Formula
-type field to substitute the “logic”, and adding that formula to the Automation or filtered view’s conditions.