Filtering repeater based on date and other criteria

Ask the community
,
1

Hi

I have a repeater showing a broad range of locations. In one collection, the name of the location, how expensive it is, the size (how many people) etc. is saved. In another collection, I have the name of the location and all dates for 2020. In case the location is free, the location has a “1” for this date, in case the location is already booked, it has a “0”.

Now what I would like to do is allow the user to filter all locations based on a number of criteria. First criteria is the date, which they select from a date picker. Only locations which are available should show up. Then the user can define a budget (e.g. up to 50 per person, 50-75, etc.), then the user can select how large the location needs to be (how many people). Filtering regarding number of people and budget is not an issue, but filtering for locations which are available is tricky. I tried to find some resources only, however didn’t find anything like this

Thanks a lot for your help!

Regards,
Sven

2

https://www.wix.com/corvid/example/mega-search

3

Hello,

Many thanks!

Unfortunately, from what I can see this only works if you have one collection, however I need to have two. I probably was not clear, to make it more explicit, I have one collection with the following

Name of location Budget Number of people Etc.
Location1 up to 75
Location2 75-100
Location3 up to 75
Location4 …

And another collection with

Date Location1 Location2 Location3 Location4
01/01/2020 0 1 0 1
01/02/2020 0 1 0 1
01/03/2020 1 0 1 0
…
12/31/2020 1 1 1 1

Where 1 means the location is available, 0 means not evailable

So the first filter should be based on if the location is avalable, then second filter is based on budget and third filter based on number of people