How to setup scheduling for a music school using Weekly Appointment Planner?

  • Profile Image
    dclngoi
    Asked on June 18, 2020 at 10:15 PM

    Hi, I am trying out your Weekly Appointment Planner for my music school's scheduling. Here is the scenario: 
    The school has 5 rooms. 3 teachers are using them between 9am-6pm from Mon to Fri for 45-min lesson.

              Room 1   -   Room 2   -   Room 3   -   Room 4   -   Room 5

    9-10   (occupied,

              Teacher B) etc

    10-11 (available) etc

    etc.  

    The form will be used by the school admin. 

    After looking at all the related templates you provide, none of them satisfy my requirements fully. I wonder if I can build one with the required feature using JotForm. Please advise.



    1592531733Screenshot 2020-06-19 at 9.54.



  • Profile Image
    Vanessa_T
    Answered on June 19, 2020 at 01:31 AM

    Yes you are right, you can actually create your own from scratch.

    You may check the following guides to help you get started:

    How-to-Create-Your-First-Web-Form

    Quick-Overview-of-Form-Fields

    How-to-schedule-an-appointment

  • Profile Image
    dclngoi
    Answered on June 19, 2020 at 01:53 AM

    Hi, thanks.

    Re How-to-schedule-an-appointment, how to know if the slot is available or not?

  • Profile Image
    Vanessa_T
    Answered on June 19, 2020 at 03:06 AM

    When all the slots for the specified time is already taken, that time slot will be grayed out and will no longer be selectable by other users. You can make a test form to check out all the other features that the appointment slot offers.

  • Profile Image
    dclngoi
    Answered on June 19, 2020 at 03:10 AM

    Thanks. If I want to schedule class for different rooms, I can just do the following, right?

    Room 1

    [Appointment field 1]

    Room 2

    [Appointment field 2]

    etc.


  • Profile Image
    Vanessa_T
    Answered on June 19, 2020 at 04:27 AM

    Yes, you are right. Then for each appointment field, make sure to check the properties and adjust it according to your needs.

    159255496800633.jpg

  • Profile Image
    dclngoi
    Answered on June 19, 2020 at 08:38 AM

    Hi, many thanks!

  • Profile Image
    dclngoi
    Answered on June 19, 2020 at 11:14 PM

    Hi, I have one more question in relation to this issue. How to reschedule/cancel an appointment entered earlier? Is this possible with Jotform?

  • Profile Image
    Vanessa_T
    Answered on June 19, 2020 at 11:17 PM

    Yes that is possible, simply edit or delete the submission to free up the previously selected slot.

    How-to-Edit-Submissions-Made-on-Your-Forms

    How-to-Delete-Form-Submission-Data

  • Profile Image
    dclngoi
    Answered on June 20, 2020 at 02:04 AM

    That's great! Thanks again.

  • Profile Image
    dclngoi
    Answered on June 20, 2020 at 09:10 AM

    Hi, I have another question. Does 'Spreadsheet to Form Widget' work with 'Appointment Field'? FYI, I am exploring the possibility of using 'Appointment' for different school branches that keep different scheduling.

    Thanks

  • Profile Image
    Amin_N
    Answered on June 20, 2020 at 12:27 PM

    The "Spreadsheet to Form" Widget pre-populates your form fields from an uploaded spreadsheet values.

    Are you referring to do that on the Appointment field?

    If so, please note that, unfortunately, this is not possible. Appointment field time slots can not be pre-populated that way.

  • Profile Image
    dclngoi
    Answered on June 20, 2020 at 10:53 PM

    Yes, you have answered my question. Thanks.

    Can a spreadsheet be loaded from a local drive dynamically during 'form filling'? I am exploring to use Jotform for a simple database application for different clients. 
  • Profile Image
    Vanessa_T
    Answered on June 20, 2020 at 11:04 PM

    Since your last question is not related to the original query, I have moved it to a separate ticket and will answer you there shortly:

    https://www.jotform.com/answers/2402108