Sorting Record Grid Returned by 'Find Records' Automation

[user_533]

Hi all,

I'm using the 'Find Records' automation to get a grid of records to email to other people. Though my table is sorted by date, the records are being returned in a completely random order (see attached, specifically the Overtime Worked Date column). Any thoughts on how to make the grid return information that's ordered chronologically instead?

Thanks so much !!

[Sho]

Hi @user_533 ,

If "Find records based on" is set to "condition" then results are returned in random order.
Dynamic searches are not possible, but if "Find records based on" is set to "View" then results are returned in the sort order of the view.

[ScottWorld]

@user_533 Also, note that the “Find Records” action can only find a maximum of 100 records, so if you have more than 100 records, you would either need to write your own custom JavaScript or rebuild your entire automation from scratch with Make’s low-code/no-code Airtable automations.