Using Multiple Scripts Together

It is possible to use multiple scripts in the same Apps Script project. However, if the same function name or trigger exists more than once, one process may overwrite another or the same process may run multiple times.

For safer operation, add one script at a time, save, authorize, reload, and test it. Add the next script only after confirming that the previous one works correctly.

function onOpen(e) {
  KOKOCAL_buildMenu(e);
}

function KOKOCAL_buildMenu(e) {
  const ui = SpreadsheetApp.getUi();
  const menu = ui.createMenu('KOKOCAL');

  if (typeof KOKOCAL_IncrementalSync_registerMenu === 'function') {
    KOKOCAL_IncrementalSync_registerMenu(menu);
  }

  if (typeof KOKOCAL_DuplicateFinder_registerMenu === 'function') {
    KOKOCAL_DuplicateFinder_registerMenu(menu);
  }

  menu.addToUi();
}

1. 1

   Back up existing code before adding

   Copy existing .gs and HTML files so you can restore them before starting. For business files, also back up the file itself when possible.

2. 2

   Organize the project name and file names

   When adding multiple scripts, manage the Apps Script project name, KOKOCAL_Menu.gs, KOKOCAL_<ToolName>.gs, and HTML files with clear names.

3. 3

   Check duplicate function names

   If a function with the same name already exists in the project, later pasted code can overwrite behavior or run an unintended process.

4. 4

   Keep one KOKOCAL_Menu.gs file

   The top-menu entry point is centralized in KOKOCAL_Menu.gs. Do not keep multiple different KOKOCAL_Menu.gs files; use one current version.

5. 5

   Check menu names and menu items

   Multiple features are grouped under the top-level KOKOCAL menu. Confirm that each installed feature appears as an item there.

6. 6

   Do not register duplicate triggers

   Running setup functions repeatedly can duplicate time-driven or installable triggers. Check the trigger list and remove unnecessary duplicates.