Sorting Users based on Membership Level

[angusbeef]

Hello everyone,

I am building an app where users send job submissions. I want the job owner to automatically see “premium” user’s submissions first.

My database is set to where Users have a field called Membership Level(text) which can be either Basic or Premium. My repeating group for which I want to sort this for is of type “Submission” while I want to sort based on a “User” field.

I have looked at previous topics on the forum but can’t seem to quite find the answer.

Thank you for all your help!

Angus

[jefeoliveira22]

You cannot sort a text, so you can use a number insted. Set your membership level as a option set, and add display text as name, and add a number field as a “rank”.
EG:
display= Basic / rank= 1
display= Premium / rank= 2
Then in a repeating group you will be able to sort as Get option / Membership level / sort by: rank

[1theritzy]

Angus, see if this helps. Very easy in the RG to sort by a field. I sort by Last name, you will use Membership Level and select “yes” for descending so it sorts for premium first.

You must go to the Privacy setting, scroll down to Everyone else and select the field you want to sort by.

How’s that?

[angusbeef]

Ill try this out and report back. Thanks Jefe!