Google Apps Script - script runs twice?

Question

I'm fairly new to Google Apps Script and I may be missing something, but I'm trying to make a very basic script for testing purposes and literally everything I write runs twice. Absolutely no idea why. Can someone point me in the right direction for some reading I can do on this?

Right now, I'm just working with the Calendar API and getting the names of my calendars, but they always print twice. Here is the code:

function myFunction() {
  let calendars = CalendarApp.getAllCalendars();
  let haveCalendar = false;
  for(i=0;i<calendars.length;i++){
    if (calendars[i].getTitle() == "Holidays"){
      Logger.log(calendars[i].getTitle());
      haveCalendar = true;
    } else if (haveCalendar == true || calendars[i].getTitle() != "Holidays"){
      Logger.log("already have calendar");
    }
  }
}

myFunction();

The current output for this is:

already have calendar
already have calendar
Holidays
already have calendar

already have calendar
already have calendar
Holidays
already have calendar

I'm completely baffled. Any help would be greatly appreciated. Thanks in advance!

Related: stackoverflow.com/questions/63605833

TheMaster
– TheMaster

2022-01-14 10:22:01 +00:00
Commented Jan 14, 2022 at 10:22 — TheMaster
– TheMaster, Commented Jan 14, 2022 at 10:22

Kelvin Chong · Accepted Answer · 2022-01-14 03:49:45Z

3

I don't recall much from Google app but i think it's because you called the function twice

remove the last line

myFunction();

and I think it should be fine. Cause their example from google as well don't call the function again

answered Jan 14, 2022 at 3:49

Kelvin Chong

2301 gold badge3 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

CJ Stewart Over a year ago

I've never felt so dumb in my life. Thank you!

MrChadMWood Over a year ago

Does this mean that the entry point must be names myFunction? How does google know where to start running the script?

uzluisf Over a year ago

Thanks for pointing this out, Kelvin! @MrChadMWood The entry point will be whatever function's name you choose in the dropdown when running the function manually or whatever function you choose in the trigger.

Cooper · Accepted Answer · 2022-01-14 04:09:52Z

2

Call from run button

function donothing(a = "one") {
  Logger.log(a);
}

donothing("two");

Execution log
9:06:36 PM  Notice  Execution started
9:06:36 PM  Info    two
9:06:36 PM  Info    one
9:06:37 PM  Notice  Execution completed

answered Jan 14, 2022 at 4:09

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Collectives™ on Stack Overflow

Google Apps Script - script runs twice?

2 Answers 2

3 Comments

Call from run button

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Call from run button

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related