Find Records Automation Error

[Jess_Databases]

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!

[ScottWorld]

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

2. 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]

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

[ScottWorld]

Yes. See the newest thread on this topic below.

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

Newest thread:

Create new record for each record returned by “find records" Ask the community

This seems to be the #1 most frequently asked question in this forum! I feel like we’ve gotten this question at least 15 times in the last month, and it’s all due to Airtable’s terrible implementation of the “Find Records” action. Clearly, this is a huge pain point for Airtable customers. First and foremost, I would highly recommend that everybody send an email to support@airtable.com to ask them to improve how the “Find Records” action works. They have an absolutely horrendous track record o…

[lguerzon27]

I need this feature. It's VERY important!

[Scadush]

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.