Example: Prevent overlapping date ranges
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.
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 the 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.
To help you make the system work for your needs, we have developed the following service program:
- Discuss your needs with our staff.
- We’ll determine and confirm the workflow logic of your database.
- We’ll create a ready-to-use database to fit your exact business model.
- You’ll get a solution designed especially for your needs.
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.