form htmlservice issue with passing parameters

Question

I have looked at other posts and am struggling with the same issue of how to pass form values to GAS. Since GUI editor has been depreciated, I decided to go the htmlservice form route. In this simple code below, I'm just trying to access the form field aField and paste it in a cell.

function doGet() {

return HtmlService.createHtmlOutputFromFile('myForm.html');
}  

function processForm(value) {
  
var myRange = SpreadsheetApp.openById("xxx").getSheetByName("Results-List").getDataRange("B20");    
myRange.setValue(value.aField);

 }

This is the HTML template myForm.html:

 <html>

 <form id="myForm">
 <input name="aField" id="aField">
 <input type="button" id="submit" value="submit" onclick = "sendData()">
 </form>

 <script>
   function sendData() {
    google.script.run.processForm(document.getElementById("myForm"));
}

 </script>
 </html>

jad · Accepted Answer · 2013-03-28 22:08:42Z

1

.getDataRange() has a different use. Use .getRange('B20') to get this to work.

answered Mar 28, 2013 at 22:08

jad

5822 gold badges9 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

form htmlservice issue with passing parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related