Repeating group sorting by user plan paid vs free

Questions
1

Hi there, I seem to be having some difficulty with what I want to do.

I have free users and paid users.

I want my repeating group to display all users randomly, but I want to make sure my paid users show first.

In the repeating group I do “search for users” set the type of user, then I click “sort by” and select the database field that is storing a text value of the option set.

But the only way it seems to sort it, is alphabetically? Can I not set which database field values should show in which order?

TIA

2

Or if I actually create a drop down filter on the page and set the sort to whatever the default setting is for the filter? Im a bit lost

3

What’s the field type you’re using to sort by? It should be easiet with a boolean type (yes or no). If it’s text, it adds a bit of complexity. I recommend adding a field such as “paid” and if it’s yes, you want to have the ones with “paid” appear first.

Have a good day :blush:

4

Its a “current plan” text value - Free, Pro, Elite are the options that are stored there via a workflow.

Creating a “Paid” yes or no field to aggregate the Pro and Elite users might do the trick. Will give it a go.

1 Like