Verify for any overlapping time ranges in the table.
The table includes fields that represent start and end times. An error will occur if the time ranges from start to end overlap between rows.
For example, consider a table that handles room reservations for a single day. If there is a reservation from 10:00 AM to 12:00 PM and another reservation from 11:00 AM to 1:00 PM, these times overlap, which will be considered an error in the reservation.
If an error occurs, it will appear in both the start and end time fields.
If the end time of one row matches the start time of another row, they are considered “not overlapping.”
To check for overlaps by date instead of time, please use “Check for Overlapping Date Ranges in Table.”
If an error occurs, the result of the action will be a list containing a single element: the field code of the table where the error happened. If there are no errors, the result will be an empty list.
Set Start Time, End Time, Date (optional), and Error Message.
Select the field for start time of the time range. Only the fields inside the table can be selected.
This parameter accepts the following field types:
Select the field for end time of the time range. Only the fields inside the table can be selected.
This parameter accepts the following field types:
If the “Start Time” is a date and time field, and the “End Time” is a time field, the date of the “End Time” will be assumed to be the same day as that of the “Start Time.” An overlap check will be conducted, taking the date into account. When considering it as the same day, it is judged based on the time zone of the logged-in user.
Specifying that “Start Time” is a Time field and “End Time” is a Date field will result in an error.
This parameter can be selected when the Time field is selected as “Start Time” and “End Time”. Only the fields inside the table can be selected. This is used when the date and time are entered as separate fields.
Selecting the Time fields for both “Start Time” and “End Time” while omitting “Date (optional)” means the date will not affect the check for overlapping times.
Selecting the time fields for both “Start Time” and “End Time,” along with “Date (optional)” specified, will consider the date when checking for overlapping times.
Even if an overlap error is detected, no errors will be displayed in the field specified by this “Date (optional).”
This parameter accepts the following field types:
Enter an error message to display if an overlap error is detected.
If the Start Time is later than the End Time, a normal overlap judgment will not be made.
This action does not support krewSheet.
Only checks can be performed within a single table. Overlap checks cannot be performed across multiple tables.