Hi all,
I’ve been building my room booking site for weeks and it’s almost done! I just need to figure out how to filter a Repeating Group by Availability that’s a date span.
I’ve scoured the forum trying to find a solve for this, but no luck. I have a feeling it’ll be an easy A-ha fix. So hoping you can help flick on the lightbulb over my head!
Here’s the user flow I’m trying to achieve:
On PAGE 1, a user can select a geographic LOCATION; and FROM and TO dates via calendar dropdowns
The dates are saved in separate FROM and TO fields, as well as a DATE SPAN field in a database table
In a separate RATE database table, I have a DATE list field for when rooms are NOT available (daily bookings).
There’s also a separate ROOM database table for room features’ metadata.
On PAGE 2, a user can see a RG list of ROOMS that match to the selected LOCATION and are available (i.e., do not have a day in their FROM - TO date span that’s NOT available)
If filtering out NOT available isn’t possible, then alternatively, I could instead have a RATE database table that has a YES / NO Availability field for every room’s date.
In that case, then, on PAGE 2, a user can only see ROOMS that are YES available for all the dates within the FROM - TO span.
I just need help figuring out how to only show ROOMS that are available, and their RATES, on PAGE 2 of the user flow.
Hopefully this makes sense. Thx in advance for your help and wisdom.
S
