How do I prevent a double booking in a desk-reservation tool created with Conforoms Makro using rule

[Nicole Uschman]

We have one room with 6 different desks. I created a desk-reservation tool in confluence using Confofrms Macro.  Here is what i created so far:

Field:Mirarbeiter, Definition User

Field:Datum, Defition Date Time Intervall

Field:Arbeitsplatz, Defition Checkbox Group with 6 alternatives

id1=Arbeitsplatz1

id20Arbeitsplatz2 etc...

I have a rule for field definition as follows: 

!id:[entry.id] AND Arbeitsplatz:[entry.Arbeitsplatz] AND (Datum.startDate:<=[entry.Datum.endDate] AND Datum.endDate:>=[entry.Datum.startDate])

So it works just fine, if the user makes a reservation for only one desk. But the problem is as soon as you make a resevation for more than one desk is doen´t seem to work. Here`s an example:

User A makes a reservation for desk 1-6. User B makes a reservation for only desk 1 = the rule works and prevents the desk 1 from beeing booked. But if User B makes a reservation 1 and 2 the rule doens´t work and both desk seem to be bokkable. 

Can I apply a rule preveting this problem? 

[David Berclaz _Apwide_]

Hi @Nicole Uschman

You want the rule to block any reservation if at least one desk in the new selection is already reserved for the same time interval. Have you tried something like that?

!id:[entry.id] 
AND Arbeitsplatz IN ([entry.Arbeitsplatz]) 
AND (Datum.startDate <= [entry.Datum.endDate] AND Datum.endDate >= [entry.Datum.startDate])

Have a nice day,

David