How to create textbox on Google Site and send its value to a Spreadsheet

5.9k views Asked by At

There is a google site. I need to add a text box and button, and a service (script) which can send a data of a textbox to a specified spreadsheet.

2

There are 2 answers

3
Karl_S On

You could use a Google Form and Insert that into the site. This video shows how. The other option would be custom code, saved as a Web App and Inserted using an Include Gadget found under Insert->More Gadgets. For just 1 field, I would go with the Google Form.

0
Fighter178 On

You can create a script \Here], then make it extract a document, after that you allow the user to edit it through your site and only there then, add that to the search bar by editTaskbar in the embed section then well in the {} do this: s+2%[where you want it to go ex:(search)this adds it to the search bar]=docs.[name of document].name there you can make it add to a textbox that you added.

EX:

almost to limit of characters so go to scripts.google.com and Ctrl+V after googleing "how to extract and add a doc to a site in google sites" oh instead of doc do sheet. Forgot it was sheets Sorry.