form-to-google-sheets
form-to-google-sheets copied to clipboard
jamiewilson
Data does not show on google sheet
Hi, i follow the step by stap but, when i submit the form i recived success status 200 but data does not show on google sheet. Can you help me? Thank you so much . https://docs.google.com/spreadsheets/d/1sfi8DuGK-DIFWvpYcucnjULzV1fL2juhncLjWNbZqrA/edit?usp=sharing
Please check for conflicting JavaScript also go to inspect element and check the problem. Post a screenshot here others might be able to help you
I think there is an issue if you change sheet name, change it back to 'Sheet1' and it will work.
I think there is an issue if you change sheet name, change it back to 'Sheet1' and it will work.
Sheet renaming helped me in my case, thank you.
Not sure where or what the problem is, but in my case it got solved by cloning the original sheet, using clones of the same file keeps on working.
I think there is an issue if you change sheet name, change it back to 'Sheet1' and it will work.
Maybe it's because there is a variable in the first line, here: var sheetName = 'Sheet1'
Anyway, when I test the code it says: Script function not found: doGet
make sure your permissions are set and your code is authorized to access the sheet. Or if that doesn't work try changing the version. You need to save a new version and publish the new version to make sure your app gets updated properly.
Sheet name must be same as that in the code entered in Script Editor -> Code.gs. It will function regardless of whatever name - Sheet1 or custom, as long as ^(above) criteria is met.
IT DOESN'T SEEM TO BE WORKING ONLY IN THE CASE OF IOS/ CHROME on IOS/ SAFARI on IOS. I have not tried it on any other mobile browser yet, though...
I've used the polyfills, but they aren't working. The polyfill links provided by @jamiewilson are displaying #504 Errors - Gateway Timeout. https://wzrd.in/standalone/whatwg-fetch@latest https://wzrd.in/standalone/promise-polyfill@latest https://wzrd.in/standalone/formdata-polyfill
I'm using attached polyfills, but with unsuccessful results. polyfill.zip Are they bad/ outdated polyfills? Does this code require a transpiler in addition to polyfills? Pl check = https://javascript.info/polyfills
PLEASE HELP!
Anyway, when I test the code it says: Script function not found: doGet
Same here. Checked the spreasheet name Tried to publish a new version
Still get the same error
EDIT: OK I must be tired. Just be sure that when you put your URL, remove the "<" and ">" from the example.
const scriptURL = 'https://script.google.com/macros/s/…/exec'
It must look like the example above. In my case I just replaced the letters URL with my link, forgetting to remove < >
how do i implement in react .. However it gets undefined data in sheets
Sheet name must be same as that in the code entered in Script Editor -> Code.gs. It will function regardless of whatever name - Sheet1 or custom, as long as ^(above) criteria is met.
IT DOESN'T SEEM TO BE WORKING ONLY IN THE CASE OF IOS/ CHROME on IOS/ SAFARI on IOS. I have not tried it on any other mobile browser yet, though...
I've used the polyfills, but they aren't working. The polyfill links provided by @jamiewilson are displaying #504 Errors - Gateway Timeout. https://wzrd.in/standalone/whatwg-fetch@latest https://wzrd.in/standalone/promise-polyfill@latest https://wzrd.in/standalone/formdata-polyfill
I'm using attached polyfills, but with unsuccessful results. polyfill.zip Are they bad/ outdated polyfills? Does this code require a transpiler in addition to polyfills? Pl check = https://javascript.info/polyfills
PLEASE HELP!
Same problem here!!!
take a look here https://github.com/jamiewilson/form-to-google-sheets/issues/42
