Google Sheets - UserForm Web App using HTML5 & Bootstrap 4

This video will start Google Sheets Userform Level 2 series. We'll be building a Web App as a sidebar in our spreadsheet using HTML5, Bootstrap 4 & JavaScript.

This tutorial is Part 1 from Google Sheets Userform - Level 2 series

If you don't already know front-end HTML/JavaScript, you should watch this playlist first.
HTML & CSS Crash Course for a JavaScript Developer series.

 #googlesheets #userform #webapp #tutorial

[georgenicholsoniii]

There is an enormous amount of educational content available on YouTube, and much of it is very good. But if you keep looking, every now and then you will come across a creator who stands above the rest in their ability to distill complex information and who is truly a gifted educator. This is one such channel. My friend, you are a gifted educator. Thank you for so much truly valuable and useful content.

[a]

this is the best & complete tutorial of google sheet ever

[kyle]

Super excited for this playlist! I've been looking to add something like your issue boxes, where you can add/remove additional inputs, for a while so I can't wait to see how you do it.

[michaelknichel]

I agree, you are truly gifted. Love your vids

[techtbe]

This is a great way to overcome userform use issues in mobile devices and tablets. Thanks Bro

[apoorvpurohit]

let me say this, you are a gifted educator/teacher :), I am not surprised with 81.2K subscribers :)

[findthetruth]

Waiting for the video. I am really thankful for what you have done, even I have asked you about that before. So, you just did what I really need it :) Thanks again, best video on youtube

[MarcShapins]

I have gone through a few of your videos and I am trying to create a script where I can enter in multiple people's names (already on a google sheet) and have a report generated with only those people's information. Have you done a video for this type of custom script yet?

[GoldoPLOX]

Wah amazing content. Lifesaver! Would your code be available to download?

[askfarouk]

but if you share the file the script will stop working, right?

[nghilam]

Is there anyway that UserForm can be use to input data (expected amount and Paid amount) as in Cashflow format? (Weekly)
EX: Week 4 of Jun; Total in and out of an item that can be sum to one cell?
PS: Is there a Level 3 + 4 of User form? :((
Thank you so much for the extremely useful videos you have made in your channel.

[tmkricky]

I would like to know if data shown on sidebar can be updated when a button on spreadsheet has been clicked. Thx.

[fernandobrito]

You're amazing dude! I'm addicted to your videos. Thanks for this, truly!
Another thing, can I submit Brazilian Portuguese subtitles to your videos? Your content is so relevant, but a lot of my friends over here in Brazil don't speak English.

[planet_]

can use this user form from google sheet app installed in phone ?

[chrispilipczuk]

Hi, first of all, thanks for sharing your knowledge, your channel is amazing. Quick question ... i have a inventory spreadsheet with multiply tabs for each sku. Spreadsheets is linked to Google data studio for inventory forecasting. Is there a way to create a UserForm to update data for each tab ? Thanks

[blackjohnson]

So much value content on your channel that is insane!

[shamsiddinrashidkhujaev]

Thank you for upcoming great series of using userform in google sheets. Is there any way to lock tab to which userform appends data, so when it was used by many users, users could enter data only thru userform and not be able to edit tab directly?

[bocobox]

Thanks for the great video truly. I have one question with metioned below code which means, I understand, block the blank in qty-received. but it still runs and updated with blank. am I getting it wrong?
function afterSubmit(e){
var qty =
qty.value = "";

[emmasafran]

Wow looks awesome !
Thanks for all this teaching !
Could you pls tell me if is there a way to automatically add an ID to each line and then we could call a line by his ID and modify the existing data thru the html form ??

[helmouthtrujillo]

thank so much for your videos, so excellent and important for me learning. Any question it’s possible create un user and password by script in google app script