How to filter a repeating group based on a specific date and specific time.
Let’s say I wanted to filter a list of events on a repeating group on a specific date at 3pm. How would I go about doing that?
I was able to filter events based on certain days, but I don’t know know how to filter events during certain time. Below is how I got specific dates on a rp group. Now how do I get a specific times?
After round down to day you can construct the time adding what you need like hours, minutes or seconds. Or just changing this time pieces to some specific value.
Give me an example. Lets say I wanted all the events between 3pm - 3:45pm on a specific date listed on RP. How would you write it?
See if this is what you are looking for:
Editor
Preview
The inputs have default initial values for quick testing purposes only.
If it helps you can use workflows to filter the list in an RG. It’s not obvious that you can do this but how you do it this ( for example)
the RG shows the events on a particular day
You have input fields for the start (3 pm) and end times (3.45pm)
You click a button to run a WF that does this:
“Display data in RG”
Data to display: RG’s list:filtered
Filter narrows to start time and end time
Another approach is to have hidden RGs that do the successive filtering and one visible RG that shows the list from the chosen hidden RG. This approach is often faster than a single RG with a complex search, sort and filter. And it’s easier to de-bug.
No, i tested it and it doesn’t seem to be what I am looking for. What I essentially want is similar to what this website is doing. I don’t believe this website uses Bubble, but it appears that they are using a bunch of RG’s on the page and for each hour it displays how many events are in that hour. For example, an event at 3:15pm on tuesday belongs to the the Tuesday 3pm RG, or an event at 4:45 on Friday belongs to the 4pm Friday RG. My guess is that for this same functionality that this website displays, it would take a many RG’s. But those RG’s will be hidden by default, they will only be displayed once an event is created for that RG’s assigned day and hour.
I prefer this functionality over just listing all of the events for that entire day, as this way keeps it more organized for the viewer. But won’t this increase WU because of the amount of RG’s searching for events. Is there a better of way of achieving this same functionality but not having 168 RG’s (one RG for every hour of every day for 7 days)?
I see, now I understand what you want to do. Well, you could have provided this info from the beginning.
Anyways, in the most common cases, to get the expected result, you would need use nested RGs (2 to 3 levels) depending on the case. This almost follows the same stacking principles as a Gantt chart, with some specific variables of course. I have some cases using something similar, such as customizable schedules, etc. And yeah, this consumes more WUs.
But there is an alternative approach that could be filtered only by specific day (or more if you want) and would use only one RG. In this case, the time separator (9:00, 10:00, 11:00, etc…) would be inserted as a new element in the cell itself. So for a column layout this element would be the first one.
Let’s think of a text element as an example. Below it would come the card with the additional info. This text element must be invisible by default (but always visible for the row with index 1). So it would have a conditional that compare the time of the next row (current index + 1). So if the time was greater it would become visible. This way you would only have one RG with this time separator and it would always return the time of the current cell (rounded down to hour). By using this, even if there were any gaps in the hours, this would not affect the expected result.
So for the first option. Would I need to make the parent RG just for Dates., and I would have to setup the nested RG for Events?
I would say to just use one RG. For what you want, that will be enough, there is no need to complicate things and also consume more WUs.
Check out these examples again, I updated them a little bit to cover the visual separators you are trying to achieve.
I agree, you’re right. I will use only one RG. Thanks for your input.
