Learn-to-send-email-via-google-script-html-no-server: Can we remove the setup() function?

[nelsonic]

See: https://github.com/nelsonic/html-form-send-email-via-google-script-without-server/blob/292b32f28a109d0bdf98c6469b4f1f803a8fc746/google-apps-script.js#L36-L39
Is it _necessary_...?

[nelsonic]

[mckennapsean]

Currently, this is setting a property (the ID of the spreadsheet) which is used to push the data into the spreadsheet. You may be able to just move the code that grab's the active spreadsheet ID and move it into the function/s that need it.

[grimmthetallest]

Agreed, this can be hardcoded in the script and called by a variable with very little added complexity. The person setting this up for the first time would have to replace some text in the script itself to include the spreadsheet ID. Doesn't seem too complicated as the same thing already happens in step 2 and 7 of the guide for the email/form action URL. Losing the drop down run function is a small thing imo.

I would suggest a few variables just at the top of the file, something easy like this

var webApp = '_published script URL goes here_'
var sheetLink = '_spreadsheet ID goes here_'
var sendTo = '_recipient email goes here_'

[mckennapsean]

The spreadsheet ID/URL can be detected by Google's API, so the developer should not need to specify this.

[mckennapsean]

We already fixed and removed this step a while ago! :)

[nelsonic]

@mckennapsean thanks for tidying up. 👍