So I am building a hotel room booking tool for my friend who owns a motel.
I am trying to sort the repeating group by showing rooms that DOESN’T contains a reservation with the input date range.
Current Data Types are:
Rooms
Reservations
Users
I have Reservations with a date range selection. It is properly saving the date range start and end date as the “Date” input for the Reservations data type. The reservation is also properly saving as a list item in the Rooms Data Type.
But, for the repeating group, I want to see rooms that are available that do NOT contain a reservation that has the reserved dates in the input for starting a reservation.
I am currently using “Data Type: Rooms” for the repeating group, with “Data Source: Sear For Rooms: each item’s Reservation’s Date Doesn’t Contain Date&Time Range A’s Date Start ← range → Date&Time Range A’s Date End”.
With that expression, it shows red, and I can’t sort off of that expression.
Current Date Range Selector is the Date&Time Range plugin selector.
This is driving me insane and I figured it’d be a simpler process to sort a RG by excluding rooms that are booked for that date range.
However, one last question I have, is will that only exclude rooms that contain that EXACT date range, or will it exclude rooms that have a reservation for any day within that date range?
TL;DR:
I need to hide rooms that currently have a reservation for any day within a date range from the repeating group of Available Rooms for the given selected date range. I’m clearly not doing something right.
I’ve included images of the Data Types and current RG Setup.
