IanGrant
2 months agoQrew Member
Preventing Scheduling Conflicts
I'm helping develop an app to track and reserve company vehicles. One of the requirements given to me was to prevent scheduling conflicts for the vehicles - essentially not allowing any overlaps for ...
- 2 months ago
I think that the formula you want to look for conflicts would be
var text QUERY =
"{7.OAF.'" & [Start] & "'}" // 7 is the fid of the field [END]
& " AND "
& "{6.OBF.'" & [End] & "'}" & " AND " // 6 is the fid of the field [Start]
& "{8.EX.'" & [Vehicle Identifier] & "'}"; // replace 8 with the field ID for the [Vehicle Identifier]Size(
GetRecords($QUERY))I believe that it will count the unsaved record, so it does not matter if the record is saved. If the value returned is >1, then there is a conflict overlap.