Using Rules for fields

Question

I created a form with a radio group field  and a checkbox field. And I have a date intervall field.

The radio group has this options:

1=desk1

2=desk2

3=desk3

4=desk4

5=desk5

I want tot do as follows: No double booking for the options desk1-desk5. If the checkbox is checked the booking for the options 1-5 is no longer possible. If there a desks already booked you cannot check the checkbox. Checking the Checkbox= all desks are booked.

I can`t figure out the rule that would makes this work properly :-(

Nicole Uschman · Answer

Great. That works just fine. But one more thing: There should be another choice for the radio group for booking all of the desks(= the room completely) And if this option is already choosen no desk can be booked at all for the same intervall. How can I implement this?

Alex Medved _ConfiForms_ · Answer

Hi @Nicole Uschman Not very trivial, as it includes the check for date intervals overlapping, but here it is A video And the storage format for the reference form

trueform

dtidtidatetimeinterval

!dti:[empty]deskdti.queryCount(form:@self;desk:[entry._func.asEntryRef(entry.desk)] AND dti.startDate:<[entry.dti.endDate] AND dti.endDate:>[entry.dti.startDate]):0Apply Filter on a fielddtidesk:[entry._func.asEntryRef(entry.desk)] AND dti.startDate:>[entry.dti.endDate] AND dti.endDate:<[entry.dti.startDate]

trueformEmbedded

Hope it helps Alex

Nicole Uschman · Answer

That would be perfect