Google Sheets - Userform
Vložit
- čas přidán 14. 03. 2019
- 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...
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!
I wasn't looking for this whatsoever but I'm glad that I found it
Thank you so much you are an awesome person
You're such a good teacher! All the explanations are very clear! Thank you for this content.
This is incredible ! Thank you sooo much for sharing all this!
You are a wonderful teacher! Loved it, and subscribed, as I am seriously getting hooked to this type of development.
Merry Christmast and A Happy New Year.
Thank you very much for your worthly lessons.
They give me the big inspiration!
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.
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?
Hi, thanks a lot. Your clip is very easy to follow step by step. It's great! Thumbs up.
Very good video explaining the use of macros. I like the use of multiple examples to demonstrate
With some modifications I managed to create more fields to add to my spreadsheet. Thank you, your tutorials are extraordinary. ☑
Great to hear!
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
Intresting thing executed in simple way. Hats off buddy..
as always, great video dude... thank you
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!!
I have tried this work more than 3 times and I get this error ws.appendRow([data.name,data.phone]); } please if possible share your sheet with me at victorkhube@gmail.com
@@vnpsheqconsulting9449 have you solved it? I have the same error :(
This is completely usefull! If you have an online class in Udemy or in another website, let me know 🙌
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
Just spend the last two days dumbfounded on why my code was not working. Thank you so much for your comment!!!
Thanks, thanks a lot!!!!
Litty, thank you so much 🔥🔥🔥🔥🔥
Also, excellent video, and thank you so much.
Thanks for this great and useful tutorial. This video is really useful to me.
Thanks! This helps a lot!
Thank you so much... I learned a lot :)
thank you very much. i see ur all video
Awesome content! Thanks a lot!
Excellent work young man ...
Great tutorial, thank you pal ;)
Awesome Tutorial
Thank You!
Thanks! Great tutorial!! I have a question: how to align a button in the center?
Awesome vid, thanks. Is there a way to make this work offline? i.e. so the UI is talking directly to the sheet? Or does the sheet always need to be online to work because gs runs server side?
Very fantastic video
Please explain us about duplicate value
How to stop duplicate value via userform in google sheets
Awesome 👌. Great tutorials 👍
Many thanks for this!
Glad you like it. Check out the new level 2 series czcams.com/play/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh.html
Thank you !!
The video is so helpful! Have you thought about doing a tutorial on combing google form instead of creating your own form?
I do have Google Forms videos. Web App is much more flexible but you should use whatever works for you.
very useful videos.
you are actually awesome
Wow ! Thanks !
¡Amazing Work!
Thanks a lot! Check out the new series czcams.com/play/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh.html
Is a way to read data to this userform, than edit and add again to sheet ?
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?
Can we add multiple checkboxes and get the value of each checked box???
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
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
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
Very nice!
Got to learn something new.
My Question: How can I creat patient records sheet?
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.
Hey, That very nice tutorial.
Can the form converted into mobile application
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"?
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
How to add in user form print button. I hope you can help me.
I always get this TypeError: Cannot read property "name" from undefined on data.name why?
up
up
Same here. Have you figured it out?
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
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
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?
Will it work on android phone also?
Is this support the Google sheet Android app?
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?
watch my basic apps script video series.
Excelente
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!
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
Same here. Have you figured it out yet?
How to create search engine for those table?
how to auto adjust the userform width and height automatically based on the content
I have the following error while running the script.
Exception: Cannot call SpreadsheetApp.getUi() from this context. (line 5, file "Code")Dismiss
is there a way to pass data from the google sheet into the html form?
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.
Hello sir how to increase or decrease the width of the user form.
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
i delete minified javascript but still not work,, anyone with same problem? i use G-Suite for education account, is that an issue?
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
Awesome
Is there a way to prevent duplicate entries?
how can you trigger the form without running the script?
Obrigado!
Thanks for the video! How can I create a dropdown list within the input box?
Please watch my web app series.
@@ExcelGoogleSheets Thanks alot! I have managed to create it! Btw, how do I create a button to clear all the input fields?
Thanks!! I am learning a lot from your tutorials. However, your web app series has some problem.
My and are showing in red color. I have checked all subsections of the HTML code are properly formatted ad closed. Why is this in red? --It works though.
With all due respect, there are no problems in the series. When you work with code, you have to be extremely detail oriented. One comma, semicolon, quote in the wrong place will throw everything off. Just because your HTML brackets are closed it does not mean you don't have some JavaScript mistakes or simply an extra div or attribute syntax error.
so cool
Cannot call SpreadsheetApp.getUi() from this context. (line 12, file "Code")Dismiss
only this error show
Be sure to open the script editor from inside the spreadsheet: prnt.sc/r4jlwv
TypeError: Cannot read property 'name' of undefined (line 48, file "Menus")Dismiss
what can i doo
when i remove data from append row, it works fine.
Had the same exact problem
help i need a function that popup the userform when its reload that i dont need to run it over the Tools/Script
possible to provide the code for us to use too? thanks!
Please how to login user html to google sheet
Hi! Very useful videos on your channel.
I tried to write a script exactly according to your video, but the data from the form does not load the sheet.
What could be the reason?
I am having the same problem.
@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?
czcams.com/video/_Iq2-_WgFdY/video.html
@@ExcelGoogleSheets thank you very much sir!
¡Gracias!
Gracias!
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?
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
I followed everything, however, it does not work. The data I am inputting was not added.
in 9:17 shows "TypeError: template.evaluate is not a function" how to solve that
ensure that there are ()
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.
Hi. First and foremost I would like to thank you for the veery helpful instructional videos. I have been able to replicate most of your tutorials however I'm trying to establish dependent drop down boxes on the UI. I'm stumped on how I can get the 2nd drop down box to update its values based on the input of the first box. Any video that can help with this? It's with the HTML side that I'm having trouble in getting to update.
If you're having issues with HTML side, then I really recommend watching the videos in this playlist czcams.com/play/PLv9Pf9aNgemuYdHkUa_knXKMYZcW9WEaf.html
Next week there will be an example of a dependent dropdown in this playlist
czcams.com/play/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh.html
I have a question- how do you change the icons that are currently displayed next to the text input fields in the form?
I am halfway to the answer: account_circle within the div for that button.
my question is, where do I access the list of other prefix icons available?
For anyone else with this question- icons list is here: material.io/resources/icons/?style=baseline .
So I would change the icon by changing account_circle to thumb_up in
thumb_up
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 ?
I have an existing problem. How to apply onOpen(e) here. And is it possible that the modal will not be closed?
is there any way to change the sidebar width? i've tryed a few things without any result! and it's getting me crazy ! please HELP!
you can do HtmlService.createHtmlOutputFromFile('Page').setWidth(300);
however, with sidebat I think there is minimum and maximum width, so it can only be changed a little. For more control use Dialog.
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.
Same to me
same
Be sure to open the script editor from inside the spreadsheet: prnt.sc/r4jlwv
Same to me
how login app to google sites with google apps script. please help me . thanks. sorrry for my english. i speak spanish
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
Thanks sir, pls help to prevent editing in entered data
Cannot call SpreadsheetApp.getUi() from this context. (line 5, file "Code" .....Do you Know what Does mean??? Help me Up Please!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Never Mine I Solved Open Google Drive and then the spreadsheet tools and appscript
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
Hello, I just tried your code and I had to deactivate the new App Script runtime for chrome V8 for it to work. The issue occured when calling the appenData function. It failed to execute. Do you know what should be changed in the code for this to work in the new environment?
What's the error message?
I just took the time to write the exact code in this tutorial in V8 engine and it works fine.
Maybe try to move document.getElementById("btn").addEventListener("click",addRecord);
below addRecord function, instead of having it above.
Just to be clear, I didn't do this change, I just wrote the same exact code and it worked fine.
Learn Google Spreadsheets There is no error message. When I go in the execution log it just mentions that appendData failed to execute. I will try to do what you said and see if it works. Thank you for your answer
I have tried to adapt this script to my project but i just can't get the submit button to work or the append function to collect the data. I've gone through all the suggestions below but nothing is working, wondering if you could provide some advice. Each function runs without errors, just no data is populated.
98% of the time spelling error or brackets missing in the HTML file.
@@ExcelGoogleSheets Thank you, found the problem bracket after a little sleep.
@@ExcelGoogleSheets I have checked everything and I cant get trhe button to work help please!!