Example: Prevent overlapping date ranges Database
This example displays how to prevent date range overlap on a booking of property. The Bookings table comprises validation rules that do not allow saving a new record if a property name matches and a date range is within or crosses an existing one.
Free 14 day Trial
Description
How the example works:
- The Bookings table refers to itself via 4 separate Many-to-Many relations.
- Each relation has different match conditions that define a case of overlapping.
- Moreover, every relation includes a summary column. Such summary columns calculate number of records with corresponding overlapping.
- Also, the Bookings table comprises the validation rule which does not allow saving a new record, if any summary column has a value that is greater than 0.
Structure
Screenshots
To help you make the system work for your needs, we have developed the following service program:
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.
We offer free system configuration assistance (up to 4 hours of consulting work). If you decide that our database is not exactly what you need - you owe nothing.