Jul 21, 2022 05:42 AM
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
Jul 21, 2022 05:51 AM
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.
Jul 21, 2022 06:31 AM
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: