Sort - Alphabetic case sensitive

[Mike_T]

I’m using a deck view and grouping by useremail. I’m also sorting by useremail. I just noticed that the sort is considering the case of the first letter of the email. Am I the only one that would like to see it alphabetized independent of lower or uppercase?

[Mike_T]

Reposting a comment here to see if anyone has a solution to address?

If a user’s email address is the same but for some reason one submission comes in capitalized and the other doens’t, appsheet treats like two different users. Will not group the same emails together.

[Steve · Accepted solution]

Create a separate (optionally virtual) column specifically to use as the sorting column. Make its App formula the expression, LOWER([Email]). Sort your deck view by that column instead of the original Email column.

[Marc_Dillon]

I think it is fairly standard to sort upper vs lower case separately.

What kind of solution are you expecting? If you need “email@email.com” to be sorted/grouped the same as “Email@email.com”, then it sounds like you’ll need to go through and change all the existing data to match. Also consider adding validation rules, or automation data change actions as necessary to prevent the data from coming through in ways that you don’t want.

The following expressions might help, if you didn’t already know they existed.

help.appsheet.com

UPPER()

Convert text to uppercase.

help.appsheet.com

LOWER()

Convert text to lowercase.

[Mike_T]

Steve and Marc,

Thank you both for taking the time to respond. I should have thought of using upper/lower in appsheet not just in google sheets!

In the spirit of Christmas… your sharing of knowledge is the gift that keeps on giving! Happy Holidays!