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.

Try Example: Prevent overlapping date ranges Database
Free 14 day Trial

Description

How the example works:

  1. The Bookings table refers to itself via 4 separate Many-to-Many relations.
  2. Each relation has different match conditions that define a case of overlapping.
  3. Moreover, every relation includes a summary column. Such summary columns calculate number of records with corresponding overlapping.
  4. 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

Prevent Overlapping Date Ranges
Prevent Overlapping Date Ranges
Notification about Booking date range overlapping
Notification about Booking date range overlapping

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.

Contact Us

Do you need help?

Questions? Call us at +1-847-465-3930.
Contact Us and we'll give you a Quick Start for free.
Hire one of TeamDesk Experts for specific help.