Timeline for Google Sheets - Fetch random value from array for each new line created with form
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 24, 2018 at 20:40 | vote | accept | Elad Ratson | ||
| May 24, 2018 at 14:23 | comment | added | Brian | You can't run it from the code editor because that range is defined when the form is submitted. Go to your form, make a test submission, and then look. Also, make sure your Sheet names match. You can change either the sheet or the script. | |
| May 24, 2018 at 12:53 | comment | added | Elad Ratson | Thank you @Brian. I tried the code but I get Error: TypeError: Cannot read property "range" from undefined. (line 13, file "Code") | |
| May 24, 2018 at 1:56 | history | answered | Brian | CC BY-SA 4.0 |