CODEWITHSUNDEEP
google-apps-script
NateV
NateV

Reputation: 13

HTMLService forms and responses

New to Google scripts. I cannot for the life of me get a Google script for forms working. The documentation is not helpful and I could not find any complete examples.

In sheets, I went to the script section. I created a basic "hello world" html. I added a function useMyForm, that will call on the script that has the form in it. After submit I cannot get the form to call the other script that has onFormSubmit.

Can someone write me a form with one entry and a call to the function that will process the data? Maybe my functions shouldn't be in separate scripts.

I write c, php, java..... this google script stuff is killing me.

Upvotes: 1

Views: 1904

Answers (1)

Bjorn Behrendt
Bjorn Behrendt

Reputation: 1264

Here is the sample code from the documentation, if there is something you don't understand please post your own version of the code that is not working: https://developers.google.com/apps-script/guides/html/communication#forms

Code.gs

function doGet() {
  return HtmlService.createHtmlOutputFromFile('index')
      .setSandboxMode(HtmlService.SandboxMode.NATIVE);
}

function processForm(formObject) {
  var formBlob = formObject.myFile;
  var driveFile = DriveApp.createFile(formBlob);
  return driveFile.getUrl();
}

index.html

<script>
  function updateUrl(url) {
    var div = document.getElementById('output');
    div.innerHTML = '<a href="' + url + '">Got it!</a>';
  }
</script>
<form id="myForm">
  <input name="myFile" type="file" />
  <input type="button" value="Submit"
      onclick="google.script.run
          .withSuccessHandler(updateUrl)
          .processForm(this.parentNode)" />
</form>
<div id="output"></div>

The one thing that took me a while to grasp is that when you run google.script.run.withSuccessHandler(updateUrl).processForm(this.parentNode)

.processForm(variable) will run a function in the .gs file. The return from that function (in the .gs file) gets sent to the .withSuccessHandler(updateUrl) function. Which in the example above is the "url" variable from function updateUrl(url)

Upvotes: 1

Related Questions