Feature request: Update 2 different calendars?

[ktib1]

Hi Dave,

First of all, thank you very much for this amazing script. It works perfectly fine and will help me a lot.

I don't have any issue, I would just like to know if it could be improved with this feature: The possibility to link to two calendars, and update either one or the other depending on the value of the cell of a specific column.

Example: Let's say I manage a limo business, and I have two limos, a blue one and a red one. I put the bookings in a worksheet, specifying for each row if i'll assign the blue or red limo. I would like to have 2 separate calendars to check the availability of either one.

I'm no programmer, but I have a feeling it could be done fairly easily, by adding a function: "if value of column C is "blue", assign this calendar ID, if value of column C ir "red", assign this calendar ID." (note that I removed all the Calendar to Spreadsheet syncing function - I don't want to update the calendar, only the spreadsheet)

As I said, i'm not a programmer, so it may be much more tricky than that, and it would possibly slow down the script by a lot. So, I thought about another easier solution: Duplicate your script, assign 2 different calendars to each one, modify a few things, then I would have 2 different menus to update each calendar separately. The 2 problems are:

• I would have to update twice instead of just once (I can live with that)
• I would prefer to have one same menu to update each calendar, and I don't know how to do that

Any help would be very appreciated! Thank you

Kevin

[davepar]

Hi Kevin,

You're the second person to suggest this. I can see how it would be really useful. It's not super hard, but not trivial either. The tricky part would be keeping the current functionality where it's easy to update just one calendar (i.e. without the red/blue column). And the testing would be tricky to make sure it all works correctly.

I don't have time this week to work on it, but perhaps in the future I'll look into it more. Thanks for the suggestion!

Dave

[samdavis21]

Sorry, just saw this thread, exactly what i was trying to suggest. Anyway the code is great, thank you so much!

[davepar]

I think updating multiple calendars would be pretty complicated. I'll try to work on it. But for now I just added the ability to set a color on an event. That may help some people, for example the first poster could use red and blue for the two limos.