Skip to content

Instantly share code, notes, and snippets.

@rheajt

rheajt/Code.gs

Created July 8, 2020 02:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rheajt/db0278e66908909f850619716d02f22a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rheajt/db0278e66908909f850619716d02f22a to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. rheajt created this gist Jul 8, 2020.
    14 changes: 14 additions & 0 deletions Code.gs
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    function doGet() {
    var html = HtmlService
    .createHtmlOutputFromFile('form')
    .setSandboxMode(HtmlService.SandboxMode.IFRAME)
    .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);

    return html;
    }

    function submit(name) {
    SpreadsheetApp.getActive()
    .getActiveSheet()
    .appendRow([name, new Date()]);
    }
    24 changes: 24 additions & 0 deletions form.html
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,24 @@
    <!DOCTYPE html>
    <html>
    <head>
    <base target="_top">
    </head>
    <body>
    <div id="demo">
    <input id="name" type="text" placeholder="Input your name here..." />
    <button id="btn" type="button">Submit</button>
    </div>

    <script>
    function submit(e) {
    var name = document.getElementById('name').value;

    google.script.run.submit(name);
    }

    document
    .getElementById('btn')
    .addEventListener('click', submit);
    </script>
    </body>
    </html>