Workaround: Automatically Installing OnEdit Trigger to Copied Google Spreadsheet using Google Apps Script
This is a workaround for automatically installing the OnEdit trigger to the copied Google Spreadsheet using Google Apps Script.
The sample situation for this workaround is as follows.
- You have a Google Spreadsheet.
- Your Spreadsheet is shared with a user as the writer.
- Your Spreadsheet has a button for executing a script for copying the active Spreadsheet.
- Your Spreadsheet has a function
installedOnEdit
for executing by the installable OnEdit trigger.