Feb 27, 2019 02:58 PM
When I sort the first column (primary field - Single Line Text), it moves my newest rows to the top A-Z, and then lists my previous rows A-Z below.
Any idea what would cause this?
Also, it isn’t letting me upload images or links, so remove the space below for a screenshot:
https ://d.pr/i/2X1GLC
Feb 27, 2019 06:21 PM
Very strange. If I type the same items you have (at least those I can see), they sort properly. Not sure what kind of dark magic is at work, but what you’re seeing is definitely not right. :man_shrugging:
Feb 28, 2019 01:25 AM
Maybe those have some ghost character at the beginning? How do you entered them, did you copy-pasted from elsewhere?
Feb 28, 2019 06:14 AM
I copy-pasted from a text editor which displays invisible items. But following your suggestion, I copied and pasted that whole column into Textmate again. This time I saw that for each of the rows in that column that were not behaving, they were wrapped in quotes?
"
1Password 7
"
"
Airtable
"
"
Alfred 3
"
So I cleaned that up and now it sorts appropriately. I just don’t know how Airtable wrapped them in newline quotes?? So weird.
Thanks for the help!