When you change a field value or save the record, treat two date fields in a table as a start date and end date range, and check whether the ranges overlap between rows. If they overlap, show an error.
This plugin supports smartphones.
Select the start and end date fields inside the table. Decide whether periods that meet on the same date count as overlapping, and set the error message.
Depending on the settings, this customization runs at the following times. Any configured conditions are also evaluated.
The page-display and field-change triggers exclude inline editing from the pencil icon on the list page.
Enter or select a value for each setting unless it is marked optional.
Choose the start date field for the periods to check for overlaps.
The following field types can be selected.
Select a field inside a table.
Choose the end date field for the periods to check for overlaps.
The following field types can be selected.
Select a field inside a table.
Choose whether a period ending on the same date another begins counts as an overlap.
Available options:
Initial value: Not consider overlapping
Enter the message to show when the input fails the check. Explain how the user can correct it.
Initial value: Date ranges are overlapping.
The following actions and conditions are useful when building similar behavior in customization mode.