Skip to main content

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.

 

 

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

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?

 

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

Reply


Terms & Conditions