Repeating group group by but sorted with another element

Questions
1

Hello everyone,
I have been looking around but I couldn’t find a answer to that

I’m trying to create a trip builder with Bubble
I have a database for an itinerary which is composed by event date
Each event dates item represent a date, a location and some additionnal information

In a repeating group, I’m able to present each day as
image

I’m also able using RG group by location
image

But in that case I’m struggling to sorted by date
In my case, the location are sorted alphabetic order
And I tried to sorted it dynamicly as following but it doesn’t work

image
image694×303 29.9 KB

Should I group or aggregate it differentlty ?

Thank for your help

2

Hello everyone,

I don’t know if some of you find a solution
Just to let you know that I tried different solution to solve the issue
It appears that Bubble can not sorted by a RG which as been group by

  1. I tried to create a nested RG, first RG by date and second by destination
  2. I tried to sorted by before to group by, which didn’t work as well
  3. I tried to create a custom state to save the date of the first destination date but I didn’t succeed here also

I will continue to try to find a solution

Regards,