Need help creating an "Accepts Reservations" filter

[sydneyng]

Hi, I have an RG of stores that accepts/does not accept reservations. I made a filter (button) but can’t seem to get it to work properly. All stores in my DB currently accept reservations, but when I click on my filter all the stores disappear.

In the backend, the “Store” data type has a “reservation” field which is linked to the Reservation data type. In Reservation, I just have the data field “type” and these are the different types of reservations:

This is the workflow of the filter when it’s clicked:
1st step (RG_filter is the custom state of the page “search-results”):

2nd step (the res filter is suppose to be what’s in the red text box):

I think my issue is in the 2nd step where I’m adjusting the RG based off this new filter. I’ve been stuck on this for a while so really appreciate any help on this!

[boston85719]

Here are a couple of forum posts that might help

Help with do a search for:filtering many to many using a custom state list based on an option set list

I’ve never used the intersect method and not sure if it would return different results than the method I use. I also don’t use custom states in most cases and opt to use URL parameters, so that the user can navigate using browser navigation and not lose their search…this also allows them to save the URL to the DB as a single text field if they want to save a search. Here are some screen shots from an application I use during a lesson on Data Modeling in Bootcamps I run. [Screen Shot 2021-03…

How to set up a search results page

After much frustration and time spent on getting my search results page to function correctly and the great amount of help from the community, I felt it necessary to provide some insight into how I accomplished this feat. My project is a hotel listing site. This could be redone for any type of listing site. Firstly, the database needs to be set up correctly. My search results are displaying hotel listings. So, I set up in the database a Data Type of Hotel Listing. The hotel listings will have …

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.

[boston85719]

Your issue seems to be the setting of the state…if you are using a checkbox to add the ‘type’ individually your addition to the list value stored in the state should be

search-result’s RG_filter:plus item current type

When I use ‘current type’ I am expecting your filters to be in a repeating group with a specific type set to it that is the same that the custom state holding the list is.

[sydneyng]

Hi @boston85719, thanks for the quick reply! I’m having store owners choose the ‘type’ via a dropdown:

If I’m using a dropdown, is there a different way to set the state?

[boston85719]

If it is a single value as a state, and you use a dropdown, then in your workflows you setup the action based on elements inputs value changed.

For the element select the DropDown holding those types…then use the action to set the state.

The state value will be the dropdowns value.

[sydneyng]

@boston85719 I should’ve mentioned the dropdown is on a separate page, so I can’t choose the dropdown as the element changing the state. Is there a way to use the filter if the dropdown isn’t on the same page?

I charged the “set stage” workflow but am still not seeing results.

[boston85719]

@sydneyng

I should’ve mentioned the dropdown is on a separate page

How are you passing the value selected from the dropdown to the other page?

@sydneyng

filter if the dropdown isn’t on the same page?

Yes, as long as you have a place on that page you are storing the value

[sydneyng]

@boston85719
This is what’s seen on the front-end, when users are able to view their search results.

I inserted the store’s reservation type they accept by using this logic in the back-end:

[boston85719]

And does that do what you are looking for? I thought the issue was about passing the value selected by a user on one page to another page.

[sydneyng]

@boston85719 The issue is that the “Accepts Reservations” button doesn’t correctly filter the repeating group to show all the stores that take reservations.

In this picture, I have all my stores accepting reservations and this appears by default. When I click on the “Accepts Reservations”, this repeating group should still be showing these three stores but it is not. It clears out all the stores, so it is not working properly.

[boston85719]

Sounds like there is a lot to this setup. If you’d like I’m sure we’d be able to sort it out in a session.

Feel free to follow the link to book a private session.

[sydneyng]

@boston85719 thanks for offering. Since a lot of this is already setup I’m sure the assistance can be provided through the forum.