how to add a textbox on google docs

2 Answers 2

answered Dec 29 '16 at 13:50

Karl_SKarl_S

3,136 1 gold badge 14 silver badges 33 bronze badges

Thank you Karl. But GForm is not a solution for this time. I need to change dynamically 1 cell of GSheet from the site which has already attached GForm. I need something with Web App using doGet etc.. with Gadget, but I couldn't find any working simple example...

Dec 29 '16 at 17:13
In conjunction with the doGet functions in the above Web App page link, I like reusing the code from this Mail Merge Tutorial Especially from the getRowsData function down in the Full Code section. It allows for easy iteration and manipulation of the existing data. Anything I have done to manipulate existing data uses that code and the HTMLService often with Templated HTML

Dec 29 '16 at 17:44
Also, IF you are changing an item submitted from the form, you may want to use a link to the form submission to change it, as opposed to changing the value in the spreadsheet. The value is stored in the Form as well and you have a disconnect if you edit the spreadsheet item without editing the form response. There is code in this thread to save the Edit Form Response URL

Dec 29 '16 at 17:55

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.

answered Dec 1 '20 at 3:41