Booking Calendar add-on for Google Forms

1. Introduction 
Step 1.
Booking Calendar is an add-on use for Google forms. It permits form's respondents to book the appointment from the form's admin' Calendar.
The add-on auto loads the events that the form's owner has created on the selected calendar under the rules that were set on the add-on interface. In the publish mode, the form's respondents can select and book an appointment via the form. Receiving the respondent's response, the add-on process the data then adds the respondent as an attendee of the appointment slot that was booked by him.
We expect that Booking Calendar will be a useful add-on.
2. Setup Steps 
Step 1: 
- Select appointment calendar with the notice that the calendar has some events that create as appointment slots [1].
- Select (or create then select) a drop-down field of the form then the add-on will load and add the calendar events as drop-down's choices [2].
- Active the form "Collect email addresses" feature or create an Email address field in short answer type. Let sure the add-on select the respondent's email field correctly then it can add the respondent as an attendee of booking appointment [3].
Step 2: 

This step is how the name of the loading events will be presented.
You can select one of given formats [4] or try your own format by checking the "Custom text format" [5].
Step 3: 
Step 3.

This step set the amount and condition to load appointment slots.
- The suggestion number of appointments is smaller or equal 10 [6].
- The add-on will hide the event that receives enough amount of invited or accepted guests following the admin's setup [7].
- The add-on will hide the too close upcoming event following the admin's setup [8].

That's all. Let save the add-on, wait a bit then check if it loads the events to the drop-down or not. If Ok, go to the form publish mode to test your own submission with another email input different the Calendar's owner' email. If the respondent is added to the selected event it's finally successful.

29 comments:

  1. How do I add calendars that I do not own, but have editing rights to?

    ReplyDelete
    Replies
    1. Sync the events into a drop-down ... i am unable to see my form name here... how to proceed now?

      Delete
  2. I have no options available for "add attendee adresses." I enabled the form to collect emails, but there are no options in the drop down for the "add attendee adresses"

    ReplyDelete
  3. Says event not found for me and I've tried so many times and think I've followed all the instructions correctly. Nothing is populating in my form drop down. TY

    ReplyDelete
    Replies
    1. You can't use the appointments in google calendar. You therefore have to create an event for every timeslot, then they will show up. I think it works better for group events as opposed to appointments since you only have a small maximum you can list.

      Delete
  4. How do I change the time format to not show military times?

    ReplyDelete
    Replies
    1. Change HH to hh in the custom code. You can also add a lowercase letter a afterward to display AM or PM. For example: hh:mm a

      Delete
    2. Thank you for the answer

      Delete
  5. Love this add-on, but it just stopped working. When I try to locate it at google apps, I get a google 500 error. What's going on?

    ReplyDelete
  6. I'm able to setup the addon so you can see events in the Google Form dropdown. However when new events are added or when users fill out the form, the events dropbown never updates. I have enabled the setting "Load event for booking until it reaches 1 invited guests" so I would expect events to disappear after a user fills out the form.

    As the user above suggested, is this addon still active?

    ReplyDelete
  7. When I try to Configure Calendar, it says 'drive.google.com refuses to connect'. Do you know what is wrong?

    ReplyDelete
  8. Hi! it says "La página drive.google.com ha rechazado la conexión."
    Could you help me? thanks!

    ReplyDelete
  9. Hey I want to add my credit but lemme ask this first. If i add $5 credit, Im getting 5 more slots to my booking calendar right. Is it restricted to 1 form or for 1 google account?

    ReplyDelete
  10. I'm a paid user for the plugin. I have set the "Load event for booking until it reaches" to 2, and I have only one event in the drop down. The form still loads and accepts new appointment even after 2 bookings. This is a bug in the plugin. Please advise on how to resolve this issue.

    ReplyDelete
  11. I'm a paid user for the plugin. I have set the "Load event for booking until it reaches" to 2, and I have only one event in the drop down. The form still loads and accepts new appointment even after 2 bookings. This is a bug in the plugin. Please advise on how to resolve this issue.

    ReplyDelete
  12. Hi, can I select multiple appointments from the dropdown list so I can send multiple invites at the same time tomy clients?

    ReplyDelete
  13. We have 2 week intervals between the 16 open slots. It works fine but when I have selected 1 of the times, it then displays the first one of the next period. I want it to keep the 16 in the beginning and then the list gets shorter everytime someone has taken a time. How do I do that?
    I have tried setting the [8] for 2 weeks, and for 1 week dosen't seem to do it.

    ReplyDelete
  14. Hi, the bookings are not going onto my calendar, and the chosen slot is not getting eliminated. NI followed the instructions as is.

    ReplyDelete
  15. i am trying to set the limit of the number of slots to reserve the schedule. did i write the correct code? i wanted to set the limit to 50 guests or applicants only
    ${"Event title"} | ${"Start MMM d, yyyy HH:mm"} - ${"End HH:mm MMM d, yyyy"} (${"Number of guests = 50"} attendees)

    ReplyDelete
  16. at this "Select the Calendar: "
    I can't choose some item, what can I do ?

    ReplyDelete
  17. like this
    https://www.facebook.com/messenger_media/?thread_id=1609684699119885&attachment_id=665168527746853&message_id=mid.%24cAAXtDIqqe8l7DfpgrF03LUS882AS

    ReplyDelete
  18. You say that there needs to be events set up in the calendar for the app to pick from, but you don't give any instructions beyond that on how it's supposed to be done.

    ReplyDelete
  19. "event not found" but I have no clue what event it is looking for....

    ReplyDelete
  20. Is this app still working? My form will not refresh the dropdown in Google Forms from the calendar. It acts like the sync has stopped.

    ReplyDelete
    Replies
    1. Same here, I created a full day event every 15 minutes and I asked it to skip 30 minutes before start time, it didn't skip. Hence people can still book an event in the past!

      I refresh manually by clicking save on the add-on, but it's supposed to refresh by itself

      Delete
  21. Event not found, can't type in email address field, will not save? HELP!

    ReplyDelete
  22. This comment has been removed by the author.

    ReplyDelete
  23. Is this a free add on to use for 1 user and 1 calendar?

    ReplyDelete

Contact Us

Name

Email *

Message *