Filter repeating group by dates

recker249 · 2024-10-02T21:22:52.460Z

Flow club <------------------ Click the Link

How would filter a repeating group by dates and it looping back into the beginning of the month after the end of the month?

Above is the link and once shows on the page is almost exactly how I want my repeating group to look and function with dates on the top of it.

Screenshot 2024-10-02 at 5.22.26 PM2228×1408 265 KB

recker249 · 2024-10-02T21:33:57.158Z

Screenshot 2024-10-02 at 5.31.20 PM1240×192 19.6 KB

I would like the same functionality as this repeating group of dates, but it seems rather complicated. I have searched for tutorials but no tutorial seems to replicate this function. I want a similar style to image and similar functionality.

recker249 · 2024-10-03T15:02:17.673Z

Anyone?

recker249 · 2024-10-04T15:05:45.945Z

recker249:

repeating group by dates and it looping back into the beginning of the month after the end of the month?

I’m sorry, I hope I’m not explaining my question poorly. My apologies. Let me explain further.

The above link, is not my website, but It’s exactly how I want my website to function. I want to create this funtionality. The correct date is highlighted based on todays date and one can click on a date which will in turn show you a repeating group.

Anyone can help?

darren.james7518 · 2024-10-04T15:32:21.176Z

To display the current week’s dates with the current day highlighted in blue, start by creating a repeating group that will show each day of the week (Monday to Sunday). Set the repeating group’s type of content to “Date” and use the data source to calculate the current week’s Monday, which you can do with the expression Current Date/Time: rounded down to week + (days): 1. In the repeating group cells, increment the date by using the current cell’s index to display each day from Monday through Sunday.

Then, add a group element behind the date to act as the background for each day. To highlight the current day, go to the conditional tab for this background group, and set a condition where the group’s date matches the current date (Parent group's date" equals Current date/time"). When this condition is met, change the background colour to blue, which will highlight the current day.

Hope that helps

recker249 · 2024-10-04T16:11:09.779Z

darren.james7518:

the data source to calculate the current week’s Monday, which you can do with the expression Current Date/Time: rounded down to week + (days): 1. In the repeating group cells, increment the date by using the current cell’s index to display each day from Monday through Sunday.

Hi, I selected the content type “Date” in the RG, but in the data source there is no option for “Current Date/Time”

nico.dicagno · 2024-10-04T16:43:14.528Z

It will not accept Current Date/Time because the datasource of an RG requires a list. Bubble removes some options from the dynamic expression options if it believes it cannot ultimately evaluate to a list.

Do you only want to display a week’s worth of dates or a month’s worth of dates?

If you want to display a week, then @darren.james7518 solution works, however you still need to feed a list to the RG. You will need a list of 7 entries, but these don’t necessarily need to be dates.

Option A: Set the datasource to:
Arbitrary Text(‘1234567’:extract with regex (regex pattern = ‘.’ (a single dot))
This looks hacky, but it’s my go to method to create an RG of any arbitrary static lenght without relying on data. Once you have an RG with 7 cells, use the above method outlined by @darren.james7518

Option B:
Use a plugin to create a list of dates directly - 1T - List of Dates Plugin | Bubble

You’ll then need to use the action ‘scroll to element in a repeating group’ when one of the RG cells/dates is clicked. You can scroll to the first entry in the Main RG whose date is greater than the clicked on date.

recker249 · 2024-10-07T15:04:34.929Z

I really appreciate the response. I tried Option A but I am getting red for some reason. Am I missing a step?

Screenshot 2024-10-07 at 11.02.57 AM1361×860 70.9 KB

Screenshot 2024-10-07 at 11.03.08 AM1497×896 77.5 KB

Screenshot 2024-10-07 at 11.03.16 AM558×876 45.6 KB

nico.dicagno · 2024-10-07T15:06:35.319Z

If you are going for option A you should set the datasource type to text.
You are essentially extracting each character of the 1234567 into its own text, creating a list of 7 texts.
Once you have an RG with 7 cells, use @darren.james7518 's method to create the 7 dates using current cell index

recker249 · 2024-10-09T00:12:16.493Z

This is my attempt wrapping dynamic with a group. I apologize for my inexperience.

Screenshot 2024-10-08 at 8.09.22 PM1226×886 104 KB

Screenshot 2024-10-08 at 8.10.29 PM1191×914 92.3 KB

Screenshot 2024-10-08 at 8.10.45 PM345×836 33.4 KB

Screenshot 2024-10-08 at 8.10.55 PM1521×918 127 KB

recker249 · 2024-10-10T00:18:15.008Z

Sorry about that. Thank you! I got it to work with that dates plugin.

Im just curious to figure out why the list of numbers wasn’t converting to dates.

recker249 · 2024-12-02T17:18:50.032Z

Hey, I know it’s been a while since this question was posted and thankfully I got it to work using Option B: 1t - List of Dates plugin

But I still want to figure out how to do it using Option A. I did everything that you mentioned along with what Darren mentioned, but I kept getting errors as shown in the screen shots.

recker249 · 2024-12-03T19:57:51.275Z

Option A: Set the datasource to:
Arbitrary Text(‘1234567’:extract with regex (regex pattern = ‘.’ (a single dot))
This looks hacky, but it’s my go to method to create an RG of any arbitrary static lenght without relying on data. Once you have an RG with 7 cells, use the above method outlined by @darren.james7518

Anyone care to explain me, how to acheive this function using Option A. I would like to not rely on plugins. I keep getting errors, see me previous messages above.

nico.dicagno · 2024-12-03T20:14:37.348Z

recker249:

Screenshot 2024-10-08 at 8.10.29 PM1191×914 92.3 KB

Change this Group’s Type to Date
It’s datasource should be “Starting Date*: + days : ( current cell’s index: minus: 1)”

*The starting date should be a Custom State or a Group Variable that defines the date that the RG should start on. It will probably have buttons/icons to change the starting date.

recker249 · 2024-12-03T20:25:43.758Z

Thank you, it worked perfectly. I really appreciate your help. I would like to not rely on plugins or plugins that are not my own as much as possible.

nico.dicagno · 2024-12-04T09:49:30.896Z

Glad you got it working in the end!
It’s always great to avoid plugins where possible - it reduces dependencies and genearally gives you much more control. For what it’s worth, the 1T plugins are a very solid plugin collection and I do sometimes use them . They have a very solid track record.

system · 2024-12-11T21:23:35.293Z

This topic was automatically closed after 70 days. New replies are no longer allowed.