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
|
...