Google Sheets UserForm - Send Data from Form to Spreadsheet
Why Stack Overflow recommends it
Stack Overflow users cite it as the step-by-step guide they followed when building Google Sheets userforms, usually in questions about why their form submission or button does not write to the sheet.
Recommended by 2 people across 2 different months, 2021 to 2021.
What it is
A 23-minute tutorial from the Learn Google Sheets & Excel Spreadsheets channel, Part 2 of its Userform Level 2 series. It shows how to build an HTML form with Bootstrap in Google Apps Script and send the submitted data into a Google Sheets spreadsheet.
What people said
Recommends Amir Flax · 2021-03 · Stack Overflow · on “submission form on google sheets”
I followed this tutorial, [this video] trying to create a form on a google spread sheet. i followed all the steps, form loading script is working ok, form body displays ok, but form data after submission does not appear on spreadsheet as expected. i must have missed something, but i went through the tutorial several times, and still can't figure it out so here is the html code: (the form code is taken from bootsrap) <!doctype html> <html lang="en"> <head> <!-- Required meta tags --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <!-- Bootstrap CSS --> <link rel="stylesheet" href=" [LINK] " integrity="sha384-B0vP5xmATw1+K9KRQjQERJvTumQ
Recommends Jorge Becgar · 2021-11 · Stack Overflow · on “A Button on a sidebar project to include a line on a spreadsheet is not working”
I´m creating a SideBar project, following this tutorial [this video] With all the code baked, my button doesn´t work. I´ve triple checked evertything but don´t find any. Don´t know if it´s a concept or sintax error. Included Bootstrap V.4.1.3 as the one followed by the tutorial. uform.html !doctype html> <html lang="en"> <head> <!-- Required meta tags --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <!-- Bootstrap CSS --> <link rel="stylesheet" href=" [LINK] " integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous"> <title>My SideBar</title> </head> <body> <div> <div class="mb-3">
Cites user15198522 · 2021-02 · Stack Overflow · on “"TypeError: Cannot read property 'ID' of undefined" I am trying to make a User Form on Google Sheets”
I'm trying to make a userform to enter jewelry into a spreadsheet. I'm following this tutorial: [this video] . I keep getting this "TypeError: Cannot read property 'ID' of undefined" error message. Please Help! Pictures [LINK] [LINK] [LINK] Code Functions Code function addNewRow(rowData) { const ss = SpreadsheetApp.getActiveSpreadsheet(); const ws = ss.getSheetByName("Interface"); ws.appendRow([rowData.ID,rowData.Description,rowData.Color,rowData.Num,rowData.Stock,rowData.Orderers]); return true; } function anotherFunc() { addNewRow({ ID: "Clip-On", Description: "Ew", Color: "Green", Num: "8", Stock: "5", Orderers: "Shannon" }) } Userform/App Code <!doctype html> <html lang="en"> <head> <!-- Requ