How do I work with lists of records in automations?

In 2023, Airtable added the ability to iterate through a list of records that were found in an automation action.

However, this feature has several major limitations:
1. Airtable will only find up to a maximum of 1,000 records.
2. You can’t use conditional actions if you iterate through records.
3. You have very limited sorting options.

So for now, your best bet for handling all of this would be to use Make’s advanced automations for Airtable.

Make has no limitations, so you can combine unlimited conditionals and iterations in the same automation. And it even automatically iterates through found records for you, unless you want it to aggregate your records as a group. It also gives you advanced sorting options for your records. All of Make’s features go way beyond what Airtable’s automations can handle.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is how you would instantly trigger a Make automation from Airtable.

I also give live demonstrations of how to use Make in many of  my Airtable podcast appearances here.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld