Sorting Users based on Membership Level

angusbeef · 2024-08-15T02:14:09.009Z

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 · 2024-08-15T04:42:12.845Z

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 · 2024-08-15T05:02:31.473Z

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.

image781×457 35.5 KB

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

image930×415 29.4 KB

How’s that?

angusbeef · 2024-08-17T02:36:09.823Z

Ill try this out and report back. Thanks Jefe!

system · 2024-10-24T02:14:58.307Z

This topic was automatically closed after 70 days. New replies are no longer allowed.