Google Sheets - Userform

Learn how to create a user form in Google Sheets using Apps Script and Materialize CSS. In this tutorial we'll add UI elements like Sidebar & Dialog Boxes with a userform to our spreadsheet and pass information from our user interface to our worksheet.
For more advanced user form check out Userform Level 2 Series:
• Google Sheets Userform...

[@rezamirrahizar2523]

Thank you for such a great tutorial. Just wanted to share if anyone is having trouble with the "google.script.run" not executing, it might have something to do with multiple accounts signed into Google (at least that was the case for me). So try signing out of the other accounts and it will work

[@billmical8008]

Just spend the last two days dumbfounded on why my code was not working. Thank you so much for your comment!!!

[@rafaom]

Thanks, thanks a lot!!!!

[@teacherwisleykid2088]

You're such a good teacher! All the explanations are very clear! Thank you for this content.

[@tomatina21]

Thanks for another great tutorial!! How can you create an edit button to edit/update/delete a previous form entry ? Could you make a tutorial on this?

[@lpanebr]

I watched your web app serie. Showing the HTML inside like this is also very nice! One thing I did differently was that I used HTML5 validation. Thank you!

[@immanuelsuleiman7550]

I wasn't looking for this whatsoever but I'm glad that I found it Thank you so much you are an awesome person

[@santosahernandezmendoza7147]

With some modifications I managed to create more fields to add to my spreadsheet. Thank you, your tutorials are extraordinary. ☑

[@ExcelGoogleSheets]

Great to hear!

[@LAQUABI]

Thank you very much for this video. I did not know we could do this inside Google Sheets until now. If possible, could you please do more videos about Google Sheets using Apps Script and Materialize CSS like this one? There are so many other useful things I saw on Materialize CSS and it would be so much easier to understand with your explanations. You're really good at teaching! I'm looking forward to seeing more of your tutorials.

[@andrezein]

You are a wonderful teacher! Loved it, and subscribed, as I am seriously getting hooked to this type of development.

[@Prince_Chaurasia]

Thank-you so much for great tutorial Please make part 2 with following thing 1. Spreadsheet will come in read-only mode when cancel user form 2. Spreadsheet will close when cancel user form 3.Entry should be done only ten digit phone no in phone section

[@tamjinhongmonkeystudio6120]

Great tutorial!! i followed all the step shown in the tutorial. But the data in the form din't update in my sheet. i can't figured out why. i have go through all the spelling and brackets but still fail to update the data on my sheet. Please help

[@shyammourya8317]

Thanks for this great and useful tutorial. This video is really useful to me.

[@Ahmedabushaban8]

I used this at my work and managed to significantly expand it. I also managed to insert formulas into a cell from gs Thank you so much!!

[@ThangHoang-ns6mq]

@VNP SHEQ Consulting have you solved it? I have the same error :(

[@mousaji]

Intresting thing executed in simple way. Hats off buddy..

[@jennylenesmith-drayton8677]

Very good video explaining the use of macros. I like the use of multiple examples to demonstrate

[@sofees]

you are actually awesome

[@mehdibellatig8776]

This is incredible ! Thank you sooo much for sharing all this!

[@AlbanoLaTorella]

fantastic guide, I'm a beginner, is it easy to use the same form to read and modify the data entered? if yes who can tell me how

[@arnavrajiv4070]

I've been following along the video and "google.script.run.appendData(data);" doesn't work, I have faced a similar problem in another tutorial as well! Please help

[@stocker6315]

Same here. Have you figured it out yet?

[@hafizarman3784]

Very fantastic video Please explain us about duplicate value How to stop duplicate value via userform in google sheets

[@wirot125]

Merry Christmast and A Happy New Year. Thank you very much for your worthly lessons. They give me the big inspiration!

[@indoremechanics]

TypeError: Cannot read property 'name' of undefined (line 48, file "Menus")Dismiss what can i doo

[@indoremechanics]

when i remove data from append row, it works fine.

[@ianpropst-campbell6028]

Had the same exact problem

[@jorgemendoza1160]

This is completely usefull! If you have an online class in Udemy or in another website, let me know 🙌

[@downhillindad7689]

This is a fantastic tutorial! Thank you for taking the time to do this. However, I am struggling with getting the button to do anything. Am I the only one who can't get the submit button to work? I have paired it down all the way to simply getting a message box to pop up indicating that I'm in the function that the button activates, but it's simply dead. It's not going into the function. No errors, just nothing happens. Any help would be great

[@SinghSumi01]

This is not working for me. I write the script exactly according to your video, but the data from the form does not load the sheet. Please help.

[@slucianofreire]

Same to me

[@guptaflavio5383]

same

[@SuperIdeas_org]

Be sure to open the script editor from inside the spreadsheet: prnt.sc/r4jlwv

[@Grace-fd8qp]

Same to me

[@deFunkyMofo]

Excellent work young man ...

[@matthewdevenecia7898]

Thanks! This helps a lot!

[@axies-learningthatmatters5387]

I have an existing problem. How to apply onOpen(e) here. And is it possible that the modal will not be closed?

[@DominikBarchanski]

i have a bit problem with this when i want to execute function google.script.run.function(); it don't do any things what should i do

[@evannerosedaganio8708]

help i need a function that popup the userform when its reload that i dont need to run it over the Tools/Script

[@renzonicolini7062]

Hello my friend, I have a web site and i need to put a form inside the web site y colect all data from clients in google sheets. How can I do that?

[@MsBoolo]

Awesome 👌. Great tutorials 👍

[@watsonpinkaew3069]

Hi, thanks a lot. Your clip is very easy to follow step by step. It's great! Thumbs up.

[@davidps]

so cool

[@Sachin-sw6om]

Hello, I have a add on installed in google sheet (when I fill the data in google sheet it triggers a data to add on app) . The problem is when I get the data in google sheet from google forms, it is not triggering data to add on . Pls give me solution. I have tried the spreadsheet.flush option, it’s not working

[@orlandsalas7346]

Awesome Tutorial

[@Syzyf37]

I have a question. How do you save "name" and "phone" data in a spreadsheet in any selected columns, for example in columns C and E?

[@ExcelGoogleSheets]

watch my basic apps script video series.

[@shabnamnaseemahmed.5072]

I have the following error while running the script. Exception: Cannot call SpreadsheetApp.getUi() from this context. (line 5, file "Code")Dismiss

[@sheyanran508]

I followed everything, however, it does not work. The data I am inputting was not added.

[@singhalmonica]

Thanks sir, pls help to prevent editing in entered data

[@orzel7690]

Is a way to read data to this userform, than edit and add again to sheet ?

[@sioetan9492]

Thanks for another great tutorial , please help me... how to create a new name in a particular table, for example in the H section?...... thanks for the answer

[@asia22]

Litty, thank you so much 🔥🔥🔥🔥🔥

[@AntonioSantos-ve6zv]

Awesome content! Thanks a lot!

[@geniewu390]

The video is so helpful! Have you thought about doing a tutorial on combing google form instead of creating your own form?

[@ExcelGoogleSheets]

I do have Google Forms videos. Web App is much more flexible but you should use whatever works for you.

[@Talas99]

what about uploading files ? how to deal with that

[@apolovzla_ccs]

as always, great video dude... thank you

[@edwinalfonsomonteromontero5843]

Hola puedes hacer un ejemplo donde se consulte un spreadsheets por medio del form, es decir, dado un identificador buscar y mostrar el nombre asociado al identificador almacenado en una tabla en sheets. Gracias y muy buen vídeo.

[@ynneky]

Thanks for the video! How can I create a dropdown list within the input box?

[@ExcelGoogleSheets]

Please watch my web app series.

[@ynneky]

@@ExcelGoogleSheets Thanks alot! I have managed to create it! Btw, how do I create a button to clear all the input fields?

[@opsocs7401]

Help! I copied his script character by character and it still won't work! There will be a sidebar, but once I hit "Add", nothing happens! Can anyone help a brother out?

[@Grace-fd8qp]

the same situation to me please help :))

[@kostnuzula2833]

just look at the very bottom, my input is put on bottom, because it already have content

[@burhansrengat]

Thank you !!

[@dr.bhavinmodi6935]

Very nice! Got to learn something new. My Question: How can I creat patient records sheet?

[@materialuoat7860]

Hi, i'm amazed with the thing you doing with these videos, thanks for every video you upload!. With this i have a problem in "google.script.run." never run in the way you show, but i look over there in forums, and nothing, until i decide delete of minified JavaScript code, and they works, but of course, the animation of button an text stops, so i decided to put again but after the script you write, and works perfectly, i decided put here if anyone else have the same problem. i ask you to make some video with explanation of Class Blob in Apps Script, and if its possible wok with that ina "showSidebar(html)", i try to read in other foums an in the same google documentation, but nothing, and you way of explain its very useful to absolute beginers, like me. Thanks again

[@sabrananda]

i delete minified javascript but still not work,, anyone with same problem? i use G-Suite for education account, is that an issue?

[@sabrananda]

i try again with my regular @gmail.com account, it's work! anyone can do this on G-Suite For Education account? cause my company use G-Suite for education to work in shared drive

[@trijayagroup7857]

hello, thank you for the video, very nice explanation and helpful.... what about if i want to validate some things, like if the userform input any same telephone number, then the msg box will pop up and shows that "duplicate phone number"?

[@altamis4410]

yes very nice, but i think it would be nice to add the log data into another spreadsheet, not the current one, anyways is someone have the sheet link will face with the userform too ?

[@julia.vasilieva]

Thanks! Great tutorial!! I have a question: how to align a button in the center?

[@pichit.raetai]

thank you very much. i see ur all video

[@mictralif7515]

this adds on the next blank rows... some parts of my rows has formulas.. how do i enter data on blank cells on a row

[@ryanbrasher5684]

Also, excellent video, and thank you so much.

[@dewaynewest7756]

Can we add multiple checkboxes and get the value of each checked box???

[@ilayarajaramasamy1263]

Will it work on android phone also?

[@racheldelgado5541]

Thank you so much... I learned a lot :)

[@66Komodo]

very useful videos.

[@MrYoubetube22]

Hello, I try to copy the complete script and does't work. when I full feel with name and phone after I click the name and phone number are not save i the sheets. tell please what I shut do?

[@somethingiswrong6362]

Awesome

[@venkatpavankumar1945]

how to auto adjust the userform width and height automatically based on the content

[@avhvsmatej]

in 9:17 shows "TypeError: template.evaluate is not a function" how to solve that

[@0emile]

ensure that there are ()

[@Zawodowieec]

Great tutorial, thank you pal ;)

[@IntrepidFox]

Many thanks for this!

[@ExcelGoogleSheets]

Glad you like it. Check out the new level 2 series kzbin.info/aero/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh

[@vegasilkit]

How could you do an edit form which would display data from the row that you click in? Certain parts of the data would not be editable i.e. the persons iD number and name. Have you already addressed this somewhere? This was a great video!

[@pankajjoshi8292]

Can i implement them in Google sheet ? Can you pls tell how to create Login id Password form , using Google sheet which i can use google sheet. thaking you lots

[@sharpandtannanaonboardingp3720]

Can you Please Provide, Script Files?

[@crazyworld7485]

Great tutorial but when i try on mobile such Chrome or Google sheet app the script not working. Please help how to script work on mobile.

[@ManojGuptahome]

The button click cant be captured

[@nikluz3807]

is there a way to pass data from the google sheet into the html form?

[@rafaelwendel1400]

Then some funmaker inputs a formula that deletes everything

[@CIVILKNOX]

how can do a pop up form

[@venkatpavankumar1945]

Hello sir how to increase or decrease the width of the user form.

[@ivanyumul1542]

how can you trigger the form without running the script?

[@LASONORALIMITE]

how login app to google sites with google apps script. please help me . thanks. sorrry for my english. i speak spanish

[@rainraindontgoaway4881]

Is there a way to prevent duplicate entries?

[@canamiecan2525]

How to add in user form print button. I hope you can help me.

[@webserviceargentina7025]

hello from Argentina. data its ok but form desapear when clicked the button. somebody have a same problem?? thankyou

[@marioagustinbeguiriztain1074]

A mi igual ¿Pudiste arreglarlo?

[@GustavoMOrralaPonce]

Excelente

[@LoneSMyrup]

Hi :-) Somehow buttons never work for me in forms. I have tried several tutorials including this and have verified that everyting is exactly the same - but iIeither get nothing og TypeError: Cannot read property 'name' of undefined. Please help me - what am I doing wrong?

[@ExcelGoogleSheets]

One thing a lot of people miss is that JavaScript is case sensitive. So everything you do, make sure you match cases.

[@perepausancho]

¡Gracias!

[@ExcelGoogleSheets]

Gracias!

[@christopherb.223]

¡Amazing Work!

[@ExcelGoogleSheets]

Thanks a lot! Check out the new series kzbin.info/aero/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh

[@mattiaticconi90]

Hi, name is not definited, why?

[@elabinnovations]

Is this support the Google sheet Android app?

[@nickieoakwood6926]

Alright. Got the sidebar all working. Error message everything. Only thing is. Once I have closed the spreadsheet and reopen, no form. Open project and the black play button is greyed. How to get form embedded into sheet so it is there on opening? Di I need to be opening spreadsheet in here somehow var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("SALES"); Something like: var ws = SpreadsheetApp.openSpreadsheet(THEN THE SSID IN HERE?).getSheetByName("SALES"); As you can probably tell am not coder but using G Sheets as my Uni project and other Sheets things like formula etc am cool with but coding is like reading Chinese Mandarin (Simplified).

[@ExcelGoogleSheets]

kzbin.info/www/bejne/lXrUY2CVjMx5mrs

[@nickieoakwood6926]

@@ExcelGoogleSheets thank you is tonight's isolation entertainment.

[@Tripleit1g4]

How to create search engine for those table?

[@mictralif7515]

@Learn Google Spreadsheets HI! thank you for helping those who wants to learn. if the form was close how can you re-open it? can there be a shortcut on the sheet? or is there a way so that use can not close the form? or can the form show up when i open the form?

[@ExcelGoogleSheets]

kzbin.info/www/bejne/lXrUY2CVjMx5mrs

[@mictralif7515]

@@ExcelGoogleSheets thank you very much sir!

[@xperimentsqf3823]

it's great.. but can we publish them and deploy as web app?

[@ExcelGoogleSheets]

yes.

[@xperimentsqf3823]

i try to publish using deploy web app, but error doGet when open in my computer browser, when i tried open on my mobile browser the page not reach.. how to make it work?

[@ExcelGoogleSheets]

Check my other channel to learn how to do it kzbin.info/door/JebzvfCuA5ymtb79DQm36A

[@duckdodgers2843]

anyone had success replicating this via a Google Document? Unfortunately, I can't seem to pass the collected HTML object / data values to app script so I can then change some values on my Google Doc via the replace text method. Any help or a link to a working document someone is willing to share so I can see their code would be greatly appreciated.

[@lecaonguyen79]

Thank You!

[@AshleyCreighton]

Watched this three times and copied it *to the absolute letter*; still can't get the form to add records to the worksheet 🤔

[@cgadistribuicao9420]

So do I

[@AshleyCreighton]

FWIW, I forgot to capitalize something in the javascript 🙃 Joined the channel's Patreon and got some help directly from the mastermind himself. Happy to support his excellent work here. 👏👏👏

[@SuperIdeas_org]

Be sure to open the script editor from inside the spreadsheet: prnt.sc/r4jlwv

[@emersonatico9475]

Kindly help me on this " TypeError: Cannot read property "name" from undefined. (line 13, file "Code")

[@DesignwithAsif]

instead of writing this: var data = { name : nameBox.value, phone: phoneBox.value }; google.script.run.appendData(data); try this: var name = nameBox.value; var phone = phoneBox.value; google.script.run.appendData(name, phone); and in gs file try: function appendData(name, phone){ var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("you sheet name here"); ws.appendRow([name, phone]); }

[@emersonatico9475]

@@DesignwithAsif thank you

[@taekilkim]

@@DesignwithAsif I did try this and still it wouldn't work.... It just doesn't add any new row

[@DesignwithAsif]

@@taekilkim Is there any error? Did you type the sheet name properly?

[@taekilkim]

@@DesignwithAsif not really. I just doesnt work 😭😭

[@nickieoakwood6926]

I suppose I should just give up at 01:30. What is puzzling me is the different names for like name, tel no. It would be a lot easier if you kept these uniform or gave a clearer explanation. I have followed to the T but just called SALES ORDER NO and PRODUCTS but the form won't populate the sheet. Most of the way there!

[@newborn7850]

Very nice. how to create a fullsize HMTL page and deploy the link or share the link of html page

[@ExcelGoogleSheets]

kzbin.info/www/bejne/iIO0p6yJrcZ2jZI

[@davidqicatabua5296]

Great channel content is great and another useful video. However I did try the same steps described in the video and the inputs are not showing in the sheet. What could be the cause of this?

[@potato_weeb8274]

there could've been an error possible error: function addRecord(){ var data = { name: nameBox.value, phone: phoneBox.value }; I typed in 'name = nameBox.value, ' I fixed it and it worked

[@lottoalgoritmos3895]

Cannot call SpreadsheetApp.getUi() from this context. (line 5, file "Code" .....Do you Know what Does mean??? Help me Up Please!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@lottoalgoritmos3895]

Never Mine I Solved Open Google Drive and then the spreadsheet tools and appscript