I need a Google App code to automatically transfer events/bookings from a Google spreadsheet to multiple Google calendars.
Its pretty much what they are doing in this link:
[url removed, login to view]
I think most of the code needed is in this link.
I would like it so that the information in each row of the spreadsheet automatically transfers to the specific calendar upon FORM completion if possible.
Just like the link there are 3 calendars in my account and 3 corresponding columns in the spreadsheet. Each row entry has an 'ADD' in the calendar column if that data is to be entered to that calendar. Once that entry has been transferred to the calendars it is to be marked 'ADDED' so that it does not get transferred again.
P.S i have column headers so all relevant information starts on row 2
P.P.S is it possible to create a spreadsheet/calendar mashup so that calendar will update from spreadsheet AND spreadsheet will change if i edit the event in the calendar?
3 freelanceria on tarjonnut keskimäärin 183 £ tähän työhön
I am a software developer with 3 years of experience. I can do your project in the professional way while considering the performance and quality in mind.