Add new line of data on google sheet



    Guntar Susatyo

    The code appends a row to the sheet containing the following data:

    new Date(), waktuEdit, userEmail, 'TEKS', kodePOD

    The code first creates a new Date object and stores it in the recordSheet.newDate column. Then it creates a waktuEdit object and stores it in the recordSheet.waktuEdit column. Finally, it stores the userEmail and 'TEKS' values in the recordSheet.userEmail and recordSheet.teks columns, respectively. Finally, the code assigns the kodePOD value to the recordSheet.kodePOD column.

    Shortcut: sheetAppendNewRow

    recordSheet.appendRow([new Date(), waktuEdit, userEmail, 'TEKS', kodePOD]);
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.