Up to date ? Sorted a RG by a field's field?

[angelinebbg]

Hello eveyrone,

This have been talked A LOT on Bubble forum.

We could not sort a repeating group with an option set or a field’s field grom another table.
Only sort with a field number, text, date…

Is it still relevant?

Below one of the message on the Bubble forum :

Sorting an option set (highest number to lowest) in a repeating group

Hi all, I’ve got a bit of an odd one which I’m hoping someone can shed some light on or point me in the right direction. I have a data set in my DB that lets a user select the year group of a student in their class. The list is (Year) 1, 2, 3, 4…all the way to 13. He’s a image of the DB structure below - [Screenshot 2023-05-19 at 10.00.04 PM] Now I know that the sort on a repeating group only works if the field you’re trying to sort is either a text or number type but has anyone seen a way w…

Thank you

[jahanzeb.khn07]

Add a number field to your option set. When sorting just use option set’s number descending “yes/no” instead of option set’s display

This will work

[adamhholmes]

Nothing has changed in Bubble since that post, so the advice there still holds true.

It’s still not possible to sort data on related field values, so there are only 2 ways to do this.

1. Load ALL the data to the page then sort it using some custom Javascript or a plugin (fine for small amounts of data, but no good if your database is large).
2. Add a number field to the DB just for sorting (as annoying as it is… this is the correct way to do this in Bubble in most cases).

[angelinebbg]

Hello,

Thank you.
I am sorry, I did not precise, it was an option set in text

But I did it and I created a field Text
and then a data trigger to change the option set’s display.

Thank you