Forum Academy Marketplace Showcase Pricing Features

Return empty fields when i try to group by month

I am trying to group by month (mmmm yyyy) a list of checklist items inside a repeating group, but when I try to use “group by” all the fields on the repeating group are empty … What am I doing wrong? Here’s a video with the explanation.

Thanks so much in advance!


Sorry I don’t have time to give to much explanation, I have a training session with a client coming up.

I do this in my apps. You need in your database, number fields that represent the month and the year.

Screen Shot 2021-09-17 at 1.41.12 PM

Inside the RG with grouping add a group like below

Screen Shot 2021-09-17 at 1.42.41 PM

Inside of that put an RG

You don’t actually need to search as there are better ways to store the values without needing to search again, but that is basically the approach to sort and filter by month and years.

Learn More

Boston85719 is an expert Bubbler with a decade experience as an educator. Real name Matthew, he has been actively building SaaS apps, marketplace apps, scheduling apps and more for clients, himself and for sale as templates.

As an official Bubble Bootcamp Instructor, he leads Bubble Bootcamps on a regular basis.

Always willing to offer advice via the Bubble Forum, Matthew also offers Private Personal and Group Training Sessions.

Through his site, NoCodeTrainer, Matthew provides a range of tutorials with editor access to help you jumpstart your Bubble development.

Always accessible you can send Matthew a private message via the forum or send an email directly with your requests.

Be sure to checkout the Stripe Integration Course when you are ready to integrate Stripe payments to start monetizing your application via product sales or subscriptions.

Stripe Integration Course

1 Like

This was perfect! Thanks so much for the tip!

Now the filter by month looks like “11 2021” for example … any thoughts on how to transform this number into a date? I’ve seen there’s a plugin that could help but what are your thoughts?

Thanks again, I really appreciate your time.