search

davepar / gcalendarsync

Apps Script for syncing a Google Spreadsheet with Google Calendar
MIT License
161 stars 46 forks source link

All Day Events #8

Open ard1984 opened 8 years ago

ard1984 commented 8 years ago

Hi,

First, this is a great script! Thank you so much for sharing it with the world! I'm using your script to create a communications plan for my organization, and now I can update the information in one place and have it push out to my entire group in real time through a shared calendar.

Since all of my events are "All Day" events, I don't need the start time and end time feature. Is there a way I can change those to be just one column called "Date" that uses a MM/DD/YYYY format?

Thanks!

davepar commented 8 years ago

Glad to hear it's helpful.

The "End Time" column can be hidden (there's a little dropdown menu in the column header). You should be able to change the format of start time to not show the time.

Changing the name for "Start Time" will require one change to the script. You can call it whatever you like and then change "Start Time" to that name on line 10 of the script.

ard1984 commented 8 years ago

Hi,

Thanks for getting back to me. I changed the column on my spreadsheet to be called 'Date,' then updated line 10 to say 'Date' instead of start time. I got the following error message:

Spreadsheet must have Title, Start Time, End Time, All Day Event, and Id columns

It looks like the script is looking for 'Start Time' in a few other places. In line 141, I changed 'Start Time' to be Date, but that just changed the error message; it didn't fix the error.

Any other ideas about what other lines might need to be changed? Thanks!

Landino commented 8 years ago

Hi Dave, this is a terrific apps script. Thank you very much! I didn't find anything like that in the web. Can you give me a hint how to sync two different calendars on the same sheet? I don't know which terms in the (necessary) second script should be changed so that the second calendar can correspond with the right columns. Thank you in advance, Joachim (from Germany)

davepar commented 8 years ago

Looks like I never answered @ard1984:

Sorry, but I misspoke earlier. Looks like the column does need to be "Start Time". That name is converted to lowercase and the space removed to create the field "starttime", which is what the Google Calendar API is expecting. I'll keep the issue open as a reminder that I should make the script more flexible with respect to column names, but I don't have time to do it right now.

@Landino: The script depends on a one-to-one correspondence between a calendar and a spreadsheet in order to sync back and forth. The way it's structured right now, it's not possible to sync to 2 calendars from one spreadsheet. Sorry.