Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Sort list function not sorting the Manual Sort field correctly.

294 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Craig_Toohey
6 - Interface Innovator
6 - Interface Innovator

Hi,

 

I'm using an automation to Find Records on a quote and then to Sort this list before duplicating these records onto a Purchase Order.  I'm using the Sort list function and the the Looping function to go through each record, referencing the sorted list instead of the original set of records from the Find Records step.  Unfortunatley I'm using Manual Sort, and Airtable doesn't recognize its own Manual Sort means of using lowercase and upper case letters to sort this list properly.  Has anyone else run into this?

For example, in this list:

 

c1KWV
c1KY
c1KZ
c1Kb
c1Kd
c1Ke
c1Kg
c1Ki

 

The sort results put C1Kb as the first result, while Manual Sort puts C1KWV as the first record...

 

Thanks in advance for any tips or suggestions.

 

 

3 Replies 3
Alyssa_Buchthal
8 - Airtable Astronomer
8 - Airtable Astronomer

First one is likely case insensitive, second is likely using unicode, where W (57) < b (62)

@lyssa, do you know if there is a way to force "Sort List" module to use unicode?

 

Unfortunately no, I believe you're forced into Airtable's defaults if you're using their modules.