This collection of files serves as a simple static demonstration of how to post to a google spreadsheet from an external html <form>
following the example by Martin Hawksey
Depreciation Warning: This code is not maintained, and should be seen as reference implementation only. If you're looking to add features or update, fork the code and update as needed.
You should be able to just open index.html
in your browser and test locally.
However if there are some permissions errors you can make a quick html server with python
. Open terminal and cd to the directory where the gist files are located and enter python -m SimpleHTTPServer
. By default this creates a local server at localhost:8000
If you're using python 3 the command differs slightly.
The spreadsheet is located here
- Resolve 405 Error on Safari
- Workaround for 405 error with Safari browser check
- Add user feedback while ajax is submitting the request
- Validation using Bootstrap Validator
I am using similar code but little change on my html form to display success/error, I am successfully able to enter the records in the google sheet but i am not getting any response back from the script, if i check for response or data objects on UI its either null or undefined or I get reference error message. Also if I click on the variable which stores my serialized data and click on that link it show The script completed but did not return anything. I think because of this I am getting response or data object as not defined or null. Can you please tell me how should i get this corrected as I can see the records are getting inserted but I cant show the message as successful on UI