Skip to main content

Sort records after Find Records automation

  • April 2, 2021
  • 5 replies
  • 52 views
Jess_Databases
Forum|alt.badge.img+9

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!

K
G
H

5 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • April 2, 2021

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.)
G
Justin_Barrett
J
Forum|alt.badge.img+11
  • J_W1
  • Known Participant
  • May 28, 2022

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

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • May 30, 2022

Yes. See the newest thread on this topic below.

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

Newest thread:

J
A
lguerzon27
Forum|alt.badge.img+3
  • lguerzon27
  • New Participant
  • January 9, 2024

I need this feature. It's VERY important!

E
S
Forum|alt.badge.img+2
  • Scadush
  • New Participant
  • February 1, 2024

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.
Terms & ConditionsAccessibility statement