Forum Academy Marketplace Showcase Pricing Features

Sorting a boolean field in a repeating group database search

Hi y’all!

So I have a problem:

I want my repeating group to sort its list by a boolean field so that the “yes” or “true” rows show up at the top of the list while the “no” or “false” rows are listed below.

I would also like for this entire list to be further sorted alphabetically after the boolean’s sort.

Example:

Company X (boolean: false)
Company Y (boolean: true)
Company A (boolean: false)

Results:

Company Y (listed first because its boolean is true)
Company A (boolean is false but in alphabetic order)
Company X.

Ideas? Advice?

Edit: By the way, the boolean field is in its own column while the company names are in its own column.

Thanks

1 Like

I’d like to do the same thing, any ideas ?