trying appscrips

[JUAN PERINI]

Hello everyone, I'm trying to automate the creation of events in the calendar based on information I have in Google Sheets. In the spreadsheet, I have the date, start time, and end time in separate cells. How can I make AppScript detect these cells separately to establish the start and end time of the event?

[George Ghanem]

Create a trigger and trigger it to run your function when the spreadsheet is edited. Then you can have your trigger function look at what changed and determine if you want to create or delete the calendar event.

This would need to be an installable trigger and not a simple trigger as you are invoking functions outside the spreadsheet.

On Tue, Apr 30, 2024, 8:07 p.m. JUAN PERINI <jpe...@solucionesaudiovisuales.com> wrote:

Hello everyone, I'm trying to automate the creation of events in the calendar based on information I have in Google Sheets. In the spreadsheet, I have the date, start time, and end time in separate cells. How can I make AppScript detect these cells separately to establish the start and end time of the event?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/6a55e33a-ac4b-4e4b-bfc9-f54a00408154n%40googlegroups.com.

[Michael O'Shaughnessy]

Not an exact answer to your question HOWEVER, this is a spreadsheet that I use to be able to add events to a calendar.  I use it to track my daily work and then run the "Add Events".  This is a lot easier than manually entering an event on a calendar.  Also, using the spreadsheet I can do easy things like track a 15 minute phone call or 25 minutes of work on code for a customer.  I also use hashtags and another calendar solution to track each "project".

Here is the link: https://docs.google.com/spreadsheets/d/1T8F9OzVv5wJ4_csptdpjTwm_kjlnPH5KD91eIu_YSug/edit?usp=sharing

Make a copy and have a look at the code.  Pretty straightforward.  Any questions do not hesitate to ask!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAA4K68aeJ7r%3DhrDo5BeL0B37onhru2yY61GQv71mKrqg-1XrQw%40mail.gmail.com.