Help with this problem Thank you
Good evening, I am using an appointment field to display on the calendar. I want that when I have a busy hour range, it does not allow me to make another appointment in that range. With a Formula field: Let a:= quote;
Let b := (select citations where citations = a);
If CNT (b) >1 then
Styled ( “appointment busy”, “red”, warning2)
This tells me that the seat is busy but if I change the time 10 minutes later it would let me take it. Any advice
5 replies
-
Hi Angel -
Attached is a sample DB.
If you open the Dashboard table and the first tab shows you an appointment field and a button. When you select an Appointment then click on the button it will check to if the start time and end time fall within the start and end time of any records in the Invoice table. If it does then it will put up an alert. If not then it will create a new record in the Invoice table with the same appointment data.
-
Thank you very much for your prompt response. I will adapt it to the table that I am creating shortly.
-
Thank you for the help you have provided, with some changes to adapt the formula to my needs. I've been wondering how to get Ninox to send an appointment confirmation via WhatsApp with this formula but it only opens the WhatsApp page where I'm wrong openURL("https://api.whatsapp.com/send?phone=34" + number(fone) + " " + "&text=" + "")
-
thank you
Content aside
- 7 mths agoLast active
- 5Replies
- 66Views
-
2
Following