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
works here, but only post text data, don't work with de input type file, does note upload files.
How can i make a form that upload a file from inputs type file AND set de data of other inputs (or textareas etc) in the spreadsheet AND put a link to the file in the same spreadsheet?
I managed to upload a file by this method: https://issuetracker.google.com/issues/36764534
i also managed to set other kind of data to the google drive's spreadsheet, from other form, by the method of this page.
but i can't do both in the same html form. Is it possible?