Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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