0

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

null
    • Fred
    • 4 wk ago
    • Reported - view

    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.

    appointment.ninox
    • Angel_Del_Pino_Velez
    • 4 wk ago
    • Reported - view

    Thank you very much for your prompt response. I will adapt it to the table that I am creating shortly.

    • Angel_Del_Pino_Velez
    • 3 wk ago
    • Reported - view
    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=" + "")
      • Fred
      • 3 wk ago
      • Reported - view

      I don't do any api work, so I don't have anything to add. To get the most eyes on this issue, I would recommend you start a new post.

    • Angel_Del_Pino_Velez
    • 3 wk ago
    • Reported - view

    thank you

Login to reply

Content aside

  • 3 wk agoLast active
  • 5Replies
  • 57Views
  • 2 Following