-
Visit the above web link
-
Copy all the scripts
-
Open the target sheet>scripts>paste all>delpoy
-
Go to block section.
-
If you are having 5 textboxes, create one local variable (name as data) make a list (5 fields) add the textbox1 text, and so on..
-
When button click
Add the above said local variable)
Set web url to
https://scripturl?ID=gsheetID&FN=writeCol&COL=2&DATA=getdata)
This will write datas into Col B