Welcome to the community, @jkaelble!
Unfortunately, Airtable’s “find records by condition” step will always grab records in a completely random order that none of us have been able to figure out what that order is!
We thought that it might be creation date, but then it turned out that it wasn’t creation date either.
There is only one known workaround to this issue, which is to find record “by view” instead of “by condition”. If you find a record by a view, it will find the records in the sort order that you have specified on that view.
However, note that there are 2 important warnings here:
-
If your view is “grouped”, then you will suddenly be thrust back into random order again, so you will need to make sure that your view has no grouping.
-
Both of Airtable’s find actions — both “find by condition” and “find by view” — will only find a maximum of 100 records. You will never be able to find more than 100 records when using Airtable’s automation actions (unless you write your own custom Javascript).
The no-code/low-code solution to both of these issues would be to use Make’s advanced automations for Airtable, which has no limit on the number of records that it will find, and it also allows you to specify the sort order whenever you perform a find.
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.
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