1

I am getting an error Bad Value (line 47, file "scriptName", project "projectName") when running the script from Send form by email and track responses in spreadsheet. I followed all the instructions but can't get it to work. I've also changed the var _spreadsheetId = 'spreadsheetID'; to var_spreadsheetID = '1gEdXyh-xT006vTaDAgxM-2eF_6F0QjKdypp245GvkxE'; but still getting the error. The ID was from the URL after the "/d/" and before the "/edit..."

Btw, I am a beginner in using JScript but I can follow. I just can't debug this one. I appreciate your response. Thanks!

Community
  • 1
  • 1
Zouchii
  • 21
  • 8
  • 1
    Please provide the errors for us to look at and a sample of your code if possible – David Aug 14 '15 at 14:49
  • Open-ended "How to" questions are difficult to answer, and tend to generate follow-up comment discussions. To improve your chances of getting a helpful answer, [edit] your question to provide greater focus on the specific problem you're facing. You should show what error messages you receive, and explain how you're running the code when you see them. See [ask]. – Mogsdad Aug 14 '15 at 15:18
  • @DavidAnderton This is the error for when I submit the form in the email. "Bad value (line 47, file "Code", project "Control Framework Monitoring")". Edit: I'll review again the code. I just arrived from the office. I think I can solve this one. Will keep you posted though once I get through this thing. Thanks! – Zouchii Aug 18 '15 at 01:28
  • @Mogsdad I'll revise the question later. I think I can give it a try again. – Zouchii Aug 18 '15 at 01:31
  • @zouchii sounds like on line 47 you are sending a value that is different from what you expect and that is causing the error. Check the line number and most likely your problem will be nearby. – David Aug 18 '15 at 11:04
  • @DavidAnderton sorry for the late update, i have fixed it now I have another one, well bugs after bugs. Thanks btw! – Zouchii Aug 18 '15 at 11:13
  • @Zouchii if you can answer your own question here that would be awesome - perhaps someone else will run into the same issue – David Aug 18 '15 at 11:27

1 Answers1

0

As I followed the instructions in the Send form by email and track responses in spreadsheet. In the declaration of the variable for spreadsheetID: var _spreadsheetId = '--- Spreadsheet ID ---'; instead of using ' (apostrophe), use " (quotation marks) on both ends.

Community
  • 1
  • 1
Zouchii
  • 21
  • 8
  • this is not correct. in javascript you can use ' or " for strings (unless the string already contains ' but yours doesn't) – Zig Mandel Sep 25 '15 at 13:28