jamiewilson/form-to-google-sheets

Modifying sheet name in script and of spreadsheet causes failure

bottbott opened this issue · 0 comments

I have this script working and receiving multiple different fields from a form and populating the table correctly, but only if the Sheet is named "Sheet1" and the sheetName variable is set to "Sheet1". When I started out with a custom named sheet it wasn't working, and only started to work once both were set to "Sheet1".

Not a huge issue (although it would be nice to have multiple forms write back to different worksheets instead of multiple workbooks). Just curious if anyone else ran into the same issue and was able to find a solution.