Hello!!
Is my second-week using bubble and I’m loving it so far!
Right now I’m building an availability feature for events/services, so one of the service fields (along with service name, price, etc.) is “Available slots” which is a date_range with all the ranges of hours that the user is available to give that specific service (In one day, a specific service can have multiple available slots)
Right now I have a repeating group (date_range type) displaying all of these ranges (no problem at this point), but I would like to sort and filter it.
I would like to filter the Available slots to show only dates that are ahead of today, so no past available slots. To do that I tried this:
And I would like to sort it by the start day and hour of the available_slots range.
Any suggestions on how to do it? How to filter and sort a date_range list in a repeating group by its own date_range values?
Thanks!!
Rodrigo
availability in your database is stored how? ( show screenshots )
the R.G. you are trying to filter is showing data type of data range, why?
It seems like what you are trying to do is to filter if a service provider is available for a specific date or date range selected by a user. So you should be filtering a repeating group of data type service provider and filtering that list of service providers by their availability.
Search for service providers filtered: available on current date/time
Hi boston, thanks for your reply.
My date base is as follows:
Data type service has multiple fields, one of them is available slots (date_range), when one of those spots is reserved, is changed to reserved slots.
Good news is that yesterday I was able to filter the available slots!! it was easier than what I thought:
Bad news is that I still can’t sort it.
Do you guys have any suggestions on how can I sort available_slots by it’s own value?
Or maybe I’m using a wrong data structure, happy to receive any feedback.
Thanks!!
You could add a sort function after the filter in your data source…alternatively you could use the first R.G. you filter on as a “hidden” R.G. ( maybe store in a popup) and then on another R.G. use the “hidden R.G” as your datasource and then sort that
Thanks boston for your quick reply!
I tried doing what you said but Bubble just won’t give me the :sort option, I tried both ways:
Any other ideas?
Thanks!
you might need to try sorting first, or use the sort option in the search constraint area
