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