I am screwed. Reached 50 automations. Now what.
I like to automate things with convenience. So I have a table setup called Variable Table and it has a single record. Let’s call it master record.
Other tables in the base e.g. A, B, C, D etc… have all their records to that single master record in the Variable table.
The master record in Variable table contains:
- some master variables (which is determining condition how the automations are supposed to behave)
2… and other normal variables (which are just values that will need to be populated to other tables, they are single select fields mostly, or checkboxes).
If certain conditions are met (e.g. the master variable in Variable table meets certain condition), then if a normal variable changes in Variable table, the corresponding lookup field for this variable field in the target Tabla A will trigger my automation as long as the condition in the master variable is met. The automation would take value from a normal variable in the Variable table and copy it across all the records in the target Table A that meet the criteria set by the master record in Variable table.
Each scenario with variable in Variable table I want to populate has a separate automation setup. I do not want one automation to handle copying of all variable fields at the same time. Only the changed variable in Variable table needs to be populated to other Table A.
It’s a bit complicated but once setup it is super convenient. I know I can kind of achieve similar things through an extension, but that extension is not that convenient to use.
It’s like a control table that runs changes across other tables and records based on dynamically selected criteria.
Perhaps one day this would be handled by AI. so I would simple write a prompt and AI would do that easy peasy. But for now I couldn’t find another way doing this.
So I don’t know if anybody was able to follow me, because it is a bit confusing, but I am wondering if there is another more effective way to set up my automations in Airtable. The issue is, every possible scenario, requires a separate automation to setup.
I can’t use repeating automations because because I can’t really set them up to only run on certain records. And even if I figured out how to do that, unfortunately it seems only 1 repeating module is possible per automation. So I can’t chain repeating automations. And I can’t use conditional module either because of same issue, I can’t really make a condition to run the way I described.
Zapier and Make could be used but I thought first to see if I can keep the automations inside Airtable. I need to change the setup frequently and tweak it, so it is more preferable to do that in Airtable than dig through Make or Zapier which is more like set it and leave it situation.
The 50 automations limit is the issue.
I remember not a long ago it was 25 automations and I was like … wow, that will be enough forever when they increase to 50. But that doesn’t seem to me like a lot today.
I think using Find record steps could possibly solve this because I can add condition into the Find record step, but Find records step seems makes the automation quite slow.
Here I described how I have it setup in more detail: