In this quick demo you can see how the phone numbers utilization could be implemented with ConfiForms Form and visualized with ConfiForms CalendarView
We can register phones, and their "use time" - with validation for "overlaps"
ConfiForms Form Definition |
---|
formName | myphones |
---|
registrationFormTitle | Register phone use |
---|
|
phonePhonefalse[phone1=Phone 1|phone2=Phone 2|phone3=Phone 3|phone4=Phone 4|phone5=Phone 5|]label;falseselect2 usetimeUse timedatetimeinterval (usetime.startDate:<=[entry.usetime.endDate] AND usetime.endDate:>=[entry.usetime.startDate] AND !id:[entry.id] AND phone:[entry.phone])This phone is in use at these dates - dates overlapValidation rule dataset trueINLINE
|
...