iansan5653 / gapps-appointment-scheduler Goto Github PK
View Code? Open in Web Editor NEWSimple appointment scheduling program that integrates with Google Forms, Sheets, and Calendar.
License: MIT License
Simple appointment scheduling program that integrates with Google Forms, Sheets, and Calendar.
License: MIT License
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!
New to Google scripts, but I have some experience coding in R.
I followed the instructions given on the code page, but when I initiate the trigger the 'updateAppointmentsTimeslots' is not available. The only option available is 'myTrigger'. Any ideas on what might be causing this?
Thanks,
Jake
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.