Not adding calendar entry

[earwickerh]

Thanks for publishing this Ian! I'd be most grateful if you could advise me on an issue I'm having. I'd happily make a donation to your favorite charity.
Nothing is being added to the calendar when i submit a form. The date/time choices show up on the form and the sheet gets updated but no calendar entry(and therefore no timeslot update either). The only changes I made to the settings were the ones described in the instructions, e.g added calendar id and I also made the trigger update every 1 minute instead of the default 1 hour.

To debug I tried to run the functions individually. Here's what I found:

• The testHandleAppointmentRequest function works fine and adds the calendar entry.

• The onFormSubmit function throws TypeError: Cannot read property 'namedValues' of undefined
  onFormSubmit @ line 6: handleAppointmentRequest(e.namedValues);
  Also getting undefined for handleAppointmentRequest, isOnWeekend, and updateAppointmentSignupTime.

This may be normal

I thought maybe I had contained the script in the wrong place e.g. in the form instead of the sheet double checked , it's definitely in the sheet. I followed the steps to the letter and even created 3 different sets(sheet,calendar,form).

Strange occurrence: after following all the steps, when I test a form submission, a new sheet gets created called "form responses 1" and the data goes there instead of the original "Sheet 1" that I renamed "Appointments". This happened even when i restarted from scratch.

Thanks in advance for any help you might be able to provide, and thanks again for having made this public in the first place. Have an awesome weekend!

[iansan5653]

Hi @earwickerh, thanks for the report! To be honest I haven't used or updated this code in a very long time - it may simply be incompatible with the latest changes to Google Apps. I'll try it out though and get back to you.

Are you by any chance using a work or school G Suite account? There is now a native implementation of this same functionality using Google Calendar appointment slots. If not, there's also the Google Individual Workspace plan that has built-in appointment scheduling support (sadly not free though).

[helioxgroup]

How would you setup to send invites to all including myself

[iansan5653]

@helioxgroup you'd need to fork this repository and update the code as I am no longer maintaining or supporting this project. I'm going to mark the repo as "Archived" to indicate that.