Apps script: Get html form values inputted into a web app

Question

I am working on a script that requires html form data to be inputted to a web app, I then want to be able to process that form data and put it on a google sheet. The thing is I can't seem to do that. Here is my code:

Index.html

<form id="Form" onsubmit="event.preventDefault(); 
google.script.run.getData(this)">
  <input type="text" name="firstname">
  <input type="submit">
</form>

Code.gs

function getData(data) {
    var sheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Logs');
    sheet.getCurrentCell().setValue(data.name);
}

What am I doing wrong?

Wicket · Accepted Answer · 2021-09-24 21:37:42Z

1

The issue in your code is that your your data doesn't have a name member/key. Hence, you are writing a null value in your current cell which will result to an empty cell value.

Sample Code:

function getData(data) {
  Logger.log(data)
  Logger.log(data.name)
  var sheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Logs');
  sheet.getCurrentCell().setValue(data.firstname);
}

Execution Logs:

Output:

In this example, my current active cell is in A1

edited Sep 24, 2021 at 21:37

Wicket

39.4k9 gold badges81 silver badges201 bronze badges

answered Sep 24, 2021 at 18:43

Kristkun

6,0031 gold badge7 silver badges19 bronze badges

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

Comments

Neven Subotic · Accepted Answer · 2021-09-24 18:00:46Z

0

Check the documentation for a practical example. In your case, you have a form which you submit. In that case the form does not know which is the active cell. Therefore you should replace getCurrentCell()with getRange() or appendRow()

Reference

appendRow - You could do this appendRow([formObject.name])
getRange - Paired with getLastRow(), you can then set the value in it

answered Sep 24, 2021 at 18:00

Neven Subotic

1,4291 gold badge9 silver badges19 bronze badges

Collectives™ on Stack Overflow

Apps script: Get html form values inputted into a web app

2 Answers 2

Sample Code:

Execution Logs:

Output:

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Sample Code:

Execution Logs:

Output:

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related