Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Automation when a view reaches a defined number of records

Topic Labels: Automations
173 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello :slightly_smiling_face:

Well, the title says it all I guess … I’d like to set an automation when a defined view reaches a number of records I define. Is it possible, please ? it seems I can’t find a way for now.

Thanks in advance for your help.

Regards.

Nicolas Caplat

2 Replies 2

That is not possible unless you always link all of your records in that view to one record in another table. We call these other tables “utility tables”, because they only exist for the purpose of “hacking” Airtable. In that other table, you would create a field of “count” type that would add up the number of linked records, and then trigger your automation based on that field.

The other alternative (instead of using a utility table) would be to write a Javascript that handles this for you, although I believe there’s a limit on how many records Airtable’s API will return at a time to scripts, so I’m not sure if you’ll be able to get the full count or not. I don’t know Javascript, so I don’t have the definitive answer on this one — someone else would need to answer that problem.

Thank you @ScottWorld !
I’ll try to use a “utility table”, since I’d like to avoid using Javascript. I was hoping -as often- there was a straight-forward solution for something that looks pretty simple to me.

Regards :slightly_smiling_face: