Appointment Management with Dynamic Drop Down
Requirement
Allow patients to book appointments with their doctors.
Use Case
A clinic wants to digitize its booking system.
There are multiple specialists and different dates/times for appointments. Each appointment lasts for 30 minutes. There are two forms: the Doctor form, to add the details of specialization and availability of the doctors who visit, and the Appointment
form to book an appointment.
Steps to follow
Form | Form Link Name | Field Type | Field Name | Field Link Name |
Doctor | Doctor | Name | Doctor Name | Doctor_Name |
Drop Down | Specialization | Specialization | ||
Time | From | From | ||
Time | To | To | ||
Appointment | Appointment | Name | Patient Name | Patient_Name |
Phone | Phone | Phone_Number | ||
Lookup (Doctor) | Doctor Name | Doctor_Name | ||
Drop Down | Date of Appointment | Date_of_Appointment | ||
Drop Down | Appointment Slot | Appointment_Slot |
Add a few fields of specialization to the Specialization choices ->
(General, Gynacology, Obstetrics, Neonatalogy, Pediatrics, Dermatology, Ophthalmology, Cardiology, Pulmonology).
2. Insert a few records to the Doctor form.
3. Let us now create a workflow to populate dates in the
Date of Appointment
field in the
Appointment
form. A patient is allowed to book appointments for the next five days. We shall create a workflow to execute during the load of the
Appointment
form.
4. Click
Add New Action
and add the below code in Deluge Editor:
- //Booking from the next day
- startDate = zoho.currentdate.addDay(1);
- //Allow booking for the next 5 days
- endDate = startDate.addDay(4);
- //Loop through the dates and add them to the Date of Appointment drop down field. We need the next five dates. Hence adding 5 elements to a list. For adding more dates, check Points To Note.
- list = {1,2,3,4,5};
- for each index l in list
- {
- input.Date_of_Appointment:ui.add(startDate.toString());
- //update startDate to get the next date
- startDate = startDate.addDay(1);
- }
5. In the same way, after a
Date of Appointment
is selected, the slots available in those days for the chosen doctor should be populated in the
Appointment Slot
field.
6. Click
Add New Action
and add the below code in the Deluge Editor:
- //Take the details of the chosen doctor
- doctor = Doctor[ID == input.Doctor_Name];
- //Getting the visiting hours of the doctor chosen
- from = doctor.From;
- to = doctor.To;
- //Getting the hours
- diff = from.hoursBetween(to);
- selectedSlots = List();
- //To get already selected slots for the chosen doctor on the chosen date
- for each d in Appointment[Doctor == input.Doctor_Name && Date_of_Appointment == input.Date_of_Appointment]
- {
- selectedSlots.add(d.Appointment_Slot);
- }
- //Multiplying the number of hours by 2, since each appointment is assumed to be 30 minutes
- //We are padding diff * 2 number of spaces to 1 and then we are changing the spaces to 1. This will now help us to add diff * 2 number of slots from which the patient can choose.
- //We are using the below list to control the number of iterations in the following loop.
- list = leftpad("1",diff * 2).replaceAll(" ","1,").toList();
- for each index a in list
- {
- //Add the slot only when it is not already selected by another patient
- if(!selectedSlots.contains(from.toString()))
- {
- input.Appointment_Slot:ui.add(from);
- }
- //Find the next slot by adding 30 minutes.
- from = from.addMinutes(30);
- }
See how it works
Points to Note
-
To add more dates, check the below code:
- startDate = zoho.currentdate.addDay(1);
- //Allow booking for the next 30 days
- endDate = startDate.addDay(30);
- list = leftpad("1",30).replaceAll(" ","1,").toList();
-
The field type of From and To in the Doctor form is Time. Thus, the time difference can be a little difficult to calculate sometimes. We can have them as Date-Time fields too.
Related Links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Appointments Management
This app is published in accordance with Marketplace review process. For pricing details, you can refer to this page. Category - IT and Administration Vendor - Zoho Corporation Pricing - Free Overview Schedule and streamline your service appointments ...Dynamic help text while filling a form
Requirement Display tooltips for fields and dynamic help texts for picklist (radio or drop-down) choices. Use Case The careers page on a salon website contains a form listing the current openings for stylists. A dynamic text displays the ...Understand drop down field
The Drop Down field enables your users to select a value from a predefined set of choices that are displayed in a dropdown menu. When to use this field?You may consider the following pointers to determine when to use a drop down field: Opt to use a ...Filter report using dynamic values from a function
Requirement When a user accesses a report, data is filtered based on the logged-in user's role so that only the required details are visible to the user. Use Case An employee management system has two forms, Department and Employees. The Department ...Dynamic calculation of price based on the calculated distance
Requirement Calculate the cost of a taxi or hired car based on distance. Use Case A cab booking application calculates and displays the approximate cost of a trip based on pickup and drop-off addresses, after which the user can choose to book the ...
New to Zoho LandingPage?
Zoho LandingPage Resources