DEV Community

Discussion on: Submit a Form to a Google Spreadsheet

Collapse
 
nicollambias profile image
Nicolas Llambías

Hello Omer! I'm migrating another script with this same use scenario, from JQuery.ajax to Fetch. After searching in the web, found this page and tried it.

I keep getting Success!, 200 response, but no data is actually inserted in me G-Sheet. Been through the issues in the original GitHub and many are saying the same. Did you actually make this work?

Collapse
 
omerlahav profile image
Omer Lahav

Hi Nicolas!
It was actually the only way that worked for me successfully.
Haven’t tried it with jQuery, but since you’ve managed to get a “success” message - did you check the table itself? The columns’ headlines should be identical (they’re case-sensitive) to the name attributes of the form’s inputs.

Anyway, feel free to contact me and send a message via the social networks (or the form in my website) that are in my profile and I’ll try to troubleshoot it with you :)

Collapse
 
edtechbymeera profile image
Meera Menon

the url can be my form file in the codepen file as well?

Thread Thread
 
omerlahav profile image
Omer Lahav

Which URL/codepen are you referring to?

Thread Thread
 
edtechbymeera profile image
Meera Menon

codepen.io/meeramenon07/pen/KKdomOb
I have this above form file is it possible to deploy this form to google online>?

Thread Thread
 
omerlahav profile image
Omer Lahav

I think it might work, but I haven't tried it myself so you better try and let us all know :)