Nested Repeating Groups: Group Jobs by Month, Then by Date

[mack]

I’m trying to structure a repeating group to display upcoming jobs, grouped first by month, then by day, and finally listing the jobs for each date. The goal is to have the current month’s jobs at the top, with today’s jobs listed first, followed by future dates in order. Each month should act as a section header, with its respective dates and jobs nested inside. What’s the best way to set this up using Bubble’s repeating groups?

I’ve been using “Group By” to successfully organize jobs by month, but I’m having trouble correctly grouping them by specific days within each month

Example

February 2025
├── Feb 12 (Today)
│ ├── Job A
│ ├── Job B
│
├── Feb 13 (Tomorrow)
│ ├── Job C
│
├── Feb 20
├── Job D

March 2025
├── Mar 2
│ ├── Job E
│
├── Mar 15
├── Job F

August 2025
├── Aug 13
├── Job G

[romanmg]

I created a demo with an approach you can take. There’s a hidden repeating group acting as the primary source, then it’s nested RGs with filters.

Take a look at the editor: coaching-sandbox | Bubble Editor

Here’s the preview: https://coaching-sandbox.bubbleapps.io/version-test/jobs-folders?debug_mode=true

Hopefully this gets you going!

Cheers,
Gaby
Coaching No Code Apps

[mack]

Thanks Gaby!

[mack]

Hey Gaby,

I made a small adjustment to the database by setting the date availability as a list, which allows selecting multiple job dates for jobs that span more than one day. However, I lost the ability to filter the job dates to be greater than or equal to the current date (rounded down to today). Do you have any suggestions for how I should set up the reference repeating group now?

[romanmg]

It might be better if you use a date range field rather than a list of dates. That way, you can do this in the reference search (I updated my demo):

But let me know if list of dates is actually more appropriate if jobs can have non-consecutive dates.

[mack]

@romanmg

But let me know if list of dates is actually more appropriate if jobs can have non-consecutive dates.

Hi Gaby, I think a list of dates would be the best fit for my use case. A job might occur on the 21st, 22nd, and then recur on different dates after that. I assume this wouldn’t be the ideal scenario for using ranges? Sorry for the inconvenience thanks again so much for taking the time to help me

[romanmg]

Got it! OK, this was fun. I updated the demo page again. I show the reference RG to help visually confirm the right jobs are showing for the right dates.

The Job data type has a List of Dates field and a “Max Date” field which helps the initial reference search only return jobs today and forward.

From there, every RG level has a filter, but you’ll see now we’re using advanced filters in some cases since this structure is a bit more involved that a single date.

Check it out!

[mack]

I think this will work perfect for me!