Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 15, 2024 02:29 PM
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.
Aug 20, 2024 11:44 AM
First one is likely case insensitive, second is likely using unicode, where W (57) < b (62)
Aug 21, 2024 06:22 AM
@lyssa, do you know if there is a way to force "Sort List" module to use unicode?
Aug 21, 2024 07:02 AM
Unfortunately no, I believe you're forced into Airtable's defaults if you're using their modules.