Help

Sort records after Find Records automation

Topic Labels: Automations
1704 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Jess_Databases
6 - Interface Innovator
6 - Interface Innovator

Hi!

Enjoying the automation features of Airtable.

It would be great to be able to sort the records found via the “Find Records” automation before sending them to the next step.

As of now, they are sorted by the time the records were created, which is logical but seldom what we’re looking for.

Thanks!

5 Replies 5

Wow, I didn’t even realize this issue existed until you posted about it. This is a large omission from Automations, and I can see how this would be a big frustration.

I would highly recommend emailing support@airtable.com to ask them to please add this into Automations, since they don’t pay much attention to these forums.

Right now, your only workarounds for this issue would be to:

  1. Write your own custom JavaScript to sort the records. Hopefully, someone can chime in here with a script that can help you with this.

or

  1. Use a no-code/low-code automation platform like Integromat. (I am an Integromat Partner & Airtable Consultant, and this link contains my referral code.)
J_W1
6 - Interface Innovator
6 - Interface Innovator

Is it just me, or is this still an issue??

Yes. See the newest thread on this topic below.

And be sure to email support@airtable.com about this.

Newest thread:

lguerzon27
5 - Automation Enthusiast
5 - Automation Enthusiast

I need this feature. It's VERY important!

Scadush
4 - Data Explorer
4 - Data Explorer

Does anyone have the javascript code to enable this 'sorting' of a 'found grid of items'?

So far I have tried this but is not working:

 

 

FoundRecords.sort((a, b) => { 
    const itemNameA = a.fields['Item Name'].toLowerCase();
    const itemNameB = b.fields['Item Name'].toLowerCase();
    if (itemNameA < itemNameB) return -1;
    if (itemNameA > itemNameB) return 1;
    return 0; });
 
'FoundRecords' is the input variable with the value of the 'grid of records' found in the automation.
'Item Name' is the row label im trying to sort alphabetically.
 
Is coming up with 
"ReferenceError: FoundRecords is not defined"
 
Any help appreciated for a work-around until Airtable updates this sorting issue.