Skip to content

Instantly share code, notes, and snippets.

@neverlock
Forked from neno-tech/code.gs
Created April 14, 2023 06:13
Show Gist options
  • Select an option

  • Save neverlock/7711c96624c86eca96b49cc3699b1780 to your computer and use it in GitHub Desktop.

Select an option

Save neverlock/7711c96624c86eca96b49cc3699b1780 to your computer and use it in GitHub Desktop.

Revisions

  1. @neno-tech neno-tech revised this gist Oct 3, 2021. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions options
    Original file line number Diff line number Diff line change
    @@ -7,6 +7,7 @@
    <div class="card-header text-white bg-primary">
    ฟอร์มบันทึกข้อมูล
    </div>
    <div class="card-body">
    </div>

    -----google font--------------
  2. @neno-tech neno-tech revised this gist Oct 3, 2021. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion ่javascript
    Original file line number Diff line number Diff line change
    @@ -9,7 +9,7 @@ function processForm(formObject){
    formObject.gender,
    formObject.dateOfBirth,
    formObject.email,
    "'"+formObject.phone
    formObject.phone

    ]);
    }
  3. @neno-tech neno-tech revised this gist Oct 3, 2021. 4 changed files with 34 additions and 30 deletions.
    14 changes: 0 additions & 14 deletions code.gs
    Original file line number Diff line number Diff line change
    @@ -4,17 +4,3 @@ function doGet() {
    .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
    }

    function processForm(formObject){
    var ss= SpreadsheetApp.openById('xxx');
    var ws=ss.getSheets()[0]
    ws.appendRow([
    new Date(),
    formObject.first_name,
    formObject.last_name,
    formObject.gender,
    formObject.dateOfBirth,
    formObject.email,
    "'"+formObject.phone

    ]);
    }
    16 changes: 0 additions & 16 deletions index.html
    Original file line number Diff line number Diff line change
    @@ -57,22 +57,6 @@
    </div>
    </div>

    <script>
    function preventFormSubmit(){
    var forms=document.querySelectorAll('form');
    for (var i=0;i<forms.length;i++){
    forms[i].addEventListener('submit',function(event){
    event.preventDefault();
    });
    }
    }
    window.addEventListener('load',preventFormSubmit);

    function handleFormSubmit(formObject){
    google.script.run.processForm(formObject);
    document.getElementById("myForm").reset();

    }
    </script>
    </body>
    </html>
    File renamed without changes.
    34 changes: 34 additions & 0 deletions ่javascript
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,34 @@
    -----code.gs---------
    function processForm(formObject){
    var ss= SpreadsheetApp.openById('xxx');
    var ws=ss.getSheets()[0]
    ws.appendRow([
    new Date(),
    formObject.first_name,
    formObject.last_name,
    formObject.gender,
    formObject.dateOfBirth,
    formObject.email,
    "'"+formObject.phone

    ]);
    }

    ------- index.html------
    <script>
    function preventFormSubmit(){
    var forms=document.querySelectorAll('form');
    for (var i=0;i<forms.length;i++){
    forms[i].addEventListener('submit',function(event){
    event.preventDefault();
    });
    }
    }
    window.addEventListener('load',preventFormSubmit);

    function handleFormSubmit(formObject){
    google.script.run.processForm(formObject);
    document.getElementById("myForm").reset();

    }
    </script>
  4. @neno-tech neno-tech created this gist Oct 3, 2021.
    20 changes: 20 additions & 0 deletions code.gs
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    function doGet() {
    return HtmlService.createTemplateFromFile('index').evaluate()
    .addMetaTag('viewport', 'width=device-width, initial-scale=1')
    .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
    }

    function processForm(formObject){
    var ss= SpreadsheetApp.openById('xxx');
    var ws=ss.getSheets()[0]
    ws.appendRow([
    new Date(),
    formObject.first_name,
    formObject.last_name,
    formObject.gender,
    formObject.dateOfBirth,
    formObject.email,
    "'"+formObject.phone

    ]);
    }
    78 changes: 78 additions & 0 deletions index.html
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,78 @@
    <!DOCTYPE html>
    <html>

    <head>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css"
    integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
    </head>

    <body>
    <div class="container">
    <div class="row">
    <div class="col-6">
    <br>
    <form id="myForm" onsubmit="handleFormSubmit(this)">
    <div class="form-row">
    <div class="form-group col-md-6">
    <label for="first_name">ชื่อ</label>
    <input type="text" class="form-control" id="first_name" name="first_name" placeholder="ชื่อ">
    </div>
    <div class="form-group col-md-6">
    <label for="last_name">สกุล</label>
    <input type="text" class="form-control" id="last_name" name="last_name" placeholder="สกุล">
    </div>
    </div>

    <div class="form-row">
    <div class="form-group col-md-6">
    <p>เพศ</p>
    <div class="form-check form-check-inline">
    <input class="form-check-input" type="radio" name="gender" id="male" value="ชาย">
    <label class="form-check-label" for="male">ชาย</label>
    </div>
    <div class="form-check form-check-inline">
    <input class="form-check-input" type="radio" name="gender" id="female" value="หญิง">
    <label class="form-check-label" for="female">หญิง</label>
    </div>
    </div>
    <div class="form-group col-md-6">
    <label for="dateOfBirth">วันเกิด</label>
    <input type="date" class="form-control" id="dateOfBirth" name="dateOfBirth">
    </div>
    </div>

    <div class="form-group">
    <label for="email">อีเมล</label>
    <input type="email" class="form-control" id="email" name="email" placeholder="อีเมล">
    </div>

    <div class="form-group">
    <label for="phone">เบอร์โทร</label>
    <input type="tel" class="form-control" id="phone" name="phone" placeholder="เบอร์โทร">
    </div>

    <button type="submit" class="btn btn-primary btn-block">บันทึก</button>
    </form>
    <div id="output"></div>
    </div>
    </div>

    <script>
    function preventFormSubmit(){
    var forms=document.querySelectorAll('form');
    for (var i=0;i<forms.length;i++){
    forms[i].addEventListener('submit',function(event){
    event.preventDefault();
    });
    }
    }
    window.addEventListener('load',preventFormSubmit);

    function handleFormSubmit(formObject){
    google.script.run.processForm(formObject);
    document.getElementById("myForm").reset();

    }
    </script>
    </body>
    </html>
    35 changes: 35 additions & 0 deletions option
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,35 @@
    -----row center--------------
    <div class="row justify-content-md-center">


    -----bootstrap card--------------
    <div class="card border-primary mb-6 " style="max-width:48rem;">
    <div class="card-header text-white bg-primary">
    ฟอร์มบันทึกข้อมูล
    </div>
    </div>

    -----google font--------------
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Prompt:wght@400&display=swap" rel="stylesheet">
    <style>
    body {
    font-family: 'Prompt', sans-serif;
    }
    </style>

    -----font awesome--------------
    <script src="https://kit.fontawesome.com/6a972cf3a7.js" crossorigin="anonymous"></script>
    <i class="fas fa-address-card"></i>

    -----sweet alert--------------
    <script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script>

    Swal.fire({
    position: 'center',
    icon: 'success',
    title: 'บันทึกเรียบร้อย',
    showConfirmButton: false,
    timer: 1500
    })