Problem with sorting records alphabetically


#1

Many of my records are trapped at the bottom of my base! Attempting to sort alphabetically by one of the key fields isn’t working! Why?


#2

What type of field is the one you are trying to sort by? What kind of value does it hold?


#3

thanks for fast response! The field is text - various publications, like NY Times, etc. I have reporters from different pubs, and the list is alphabetical by pubs.


#4

Strangely, when I attempt to integrated those records into the alphabetical-by-publication list, it won’t happen


#5

So the field contains text, but what TYPE of field is it? Is it a linked record field? Is it a Formula field? Is it just a Single-Line Text Field?


#6

Oh! I … don’t know. to the left of the field name is an icon representing a bulleted list, but I don’t know what kind of field it is.


#7

Like this?
image


#8

yes. that’s right, it looks like that


#9

when I type in the name of a publication it automatically creates a colored button as field entry


#10

So then your sort menu says “First-Last”, not “A-Z” right?
image


#11

Yes, it says first to last, not a-z


#12

Those are sorted by the order of the options in the Field menu:
image

You can alphabetize them by hitting that “Alphabetize” button in the Field menu options.

image

EDIT – It’s important to note that if you add a new Publication to that list, it will automatically go to the bottom of the list, regardless of its proper alphabetical position in the list; to have newly added options properly sorted, you need to repeat this process of hitting the “Alphabetize” button in the Field Menu options.


#13

Ah!!! Okay, I’ll try…


#14

Well, strangely it didn’t work. they’re still down there. I wonder if they are somehow accidentally entered in some protected format, or were sorted as a group by some other field


#15

Re-apply the sort by clicking “Apply” in the Sort Menu:
image

EDIT – this can be done quickly in the future by hitting /ctrl+Shift+S (to open the sort menu) and then hitting enter (to reapply the sort).


#16

Got it. okay will do


#17

YES!! Success! it worked.