...
The formula itself is where you define the condition for the rule. If the formula evaluates to true, it will result in a conflict. You can use various logical operators such as == (equal), != (not equal), > (greater than), >= (greater than or equal to), < (less than), <= (less than or equal to), CONTAINS, LIKE, NOT, and ISBLANK, STARTSWITH.
Additionally, there are functions available for performing calculations and filtering lists. When linked to a dimension, you can access special variables like overlappingReservations and matchingAvailabilities to further rules for availability checking or double bookings.
...
Reservations are checked against the capacity of the room, or bypassed if the status allows double booking
Code Block B25__Quantity__c
+
SUM(overlappingReservations,
B25__Quantity__c)
>
B25__Resource__r.B25__Capacity__c
AND
B25__Status__r.B25__AllowDoubleBooking__c
==
false
Reservations are not allowed when going over the sum of all availabilities' capacity
```B25B25__Quantity__c + SUM(overlappingReservations, B25__Quantity__c) > SUM(matchingAvailabilities, Capacity__c)
...
Resource Availability rule, also for the widget.
Raises a conflict if there is no availability or unavailability
...
COUNT(FILTER(matchingAvailabilities
...
AS
...
ava,
...
ava.B25__Unavailability__c
...
==
...
true))
...
!=
...
0
...
OR
...
COUNT(FILTER(matchingAvailabilities
...
AS
...
ava,
...
ava.B25__Unavailability__c
...
!=
...
true))
...
==
...
0
Resource Capacity rule, raises a conflict if the B25LP__Quantity_For_External_Client__c quantity of all reservations at the same point exceeds the resource capacity.
SUM(overlappingReservations, B25LP__Quantity_For_External_Client__c) + B25LP__Quantity_For_External_Client__c > B25__Resource__r.B25__Capacity__cCOUNT(overlappingReservations) > 0 and $Permission.B25__ALLOW_DOUBLE_BOOKING == false
Other Relevant Articles
“Unshared conflict checking” Shared vs Unshared Conflict Checking
Timeslot picker Time Slot Picker (for record pages)