Help

Sorting Record Grid Returned by 'Find Records' Automation

723 2
cancel
Showing results for 
Search instead for 
Did you mean: 
user_533
5 - Automation Enthusiast
5 - Automation Enthusiast

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 !!

2 Replies 2
Sho
11 - Venus
11 - Venus

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
18 - Pluto
18 - Pluto

@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.