03-05-2025, 02:26 AM
Thank you, Skip. Entering a few examples led me to discover that sorting numerically does not sort on either of the custom fields.
Your helpful suggestion led me to notice the Sort Title field.
Good news: sorting numerically is affected by this field.
Bad news: the Sort Title field overrides the Title field, so an A-Z sort also uses the Sort Title so I get both numerical and A-Z sort in numerical order because the Sort Title seems to override sorting by the normal Title.
I realise I want it both ways and so far I cannot find a way to have an alphabetical list of hymn titles and also a numerical sort by hymn number. I need to look further.
Your helpful suggestion led me to notice the Sort Title field.
Good news: sorting numerically is affected by this field.
Bad news: the Sort Title field overrides the Title field, so an A-Z sort also uses the Sort Title so I get both numerical and A-Z sort in numerical order because the Sort Title seems to override sorting by the normal Title.
I realise I want it both ways and so far I cannot find a way to have an alphabetical list of hymn titles and also a numerical sort by hymn number. I need to look further.