Create a Data Entry Form with Google HTML Service and Submit Data to Google Sheets
Code Code.gs function doGet ( request ) { return HtmlService . createTemplateFromFile ( 'Index' ) . evaluate ( ) ; } /* @Include JavaScript and CSS Files */ function include ( filename ) { return HtmlService . createHtmlOutputFromFile ( filename ) . getContent ( ) ; } /* @Process Form */ function processForm ( formObject ) { var url = "https://docs.google.com/spreadsheets/d/1esdBN1frPQoo-rKi3-cg7-Zk4H9ZwWkonU7glN5p-so/edit#gid=0" ; var ss = SpreadsheetApp . openByUrl ( url ) ; var ws = ss . getSheetByName ( "Data" ) ; ws . appendRow ( [ formObject . first_name , formObject . last_name , formObject . gender , formObject . dateOfBirth , formObject . email , formObject . phone ] ) ; } Index.html <!DOCTYPE html > < html > < head > < base target =" _top " > < link rel =...
Commentaires
Enregistrer un commentaire