Template: Use Google Calendar to help you manage your events

Link to the template: http://goo.gl/9Ctcz

All-in-one template:
Easily embed a calendar in your website to let people register to events, schedule appointments,...
Based on Google Apps, Docs, Calendar, Scripts

Category:

Howto & Style

Tags:

• Google Apps
• Google spreadsheet
• Google apps script
• Google Calendar
• Calendar
• event registration
• Online appointment scheduling
• Online Appointments
• Appointment Scheduling
• event booking

[rissamari]

I'm having trouble limiting the number of participants for an event. I've tested it out and the event currently allows more than my 'max participants' amount of people to accept the calendar invite. Am I doing something wrong, or misunderstanding the feature of stipulating the max participants in the spreadsheet? As in, is that column just informational rather than functional?

[romainvialard]

@rissamari

No, it is functional (or mean to be). Did you put the trigger to send email confirmations ?

[rissamari]

@romainvialard I did, but found that more than the max # of people could both register for an event using the form and also say that they were attending via Google Calendar. I might be a bit confused because there are two methods of RSVP'ing?

[romainvialard]

@rissamari

No, they can only register via the form. But then the script mark them as attending in Google Calendar.

I checked and the max participants feature works well for me, nothing seems to be broken.

[mxminime]

How i can modify the template if I need to add the information to the (Venue) Place, I hope you can help me.

[romainvialard]

@mxminime

You can already add this info (it's not shown in the video but you will easily find it in the template)

[pattyrucks]

@rissamari @romainvialard

I am having the same problem. It doesn't seem to be restricting the number of people that can sign up. Are there any hints about how to make this work?

[ajames571]

HI

Thank you very much for the effort and work; it is very impressive. I have managed to create my own copy, create a new calendar, make the modifications in the templates sheet and create and import some events. I have also modified the form as I am in a gmail domain so the form will collect the username. I have deleted the two questions and just left the prefilled box on the form with submit.

The problem i have is the form will not prepopulate. Any advice? I can send to you if helpful?

[zpga1]

why no sound?

[romainvialard]

@cadpoobah

I'll try to add that soon :)

[cadpoobah]

Awesome stuff! Is there a way to "modify" an event and have it updated on the calendar? If I change an event in the spreadsheet, it just adds a new event, leaving the original one. Thanks!