How to create Login and Register Form using Google spreadsheet data?

If this video useful to you, Don't forget to subscribe, like and comment.
Source code:
Subscribe to my channel and I will post useful videos for you. so don't forget to subscribe.
plefigos.com/p...
How do link to your website after the user logged in?
• How do link to your we...
How to submit a HTML form to Google Sheets (with full source code):
Type (1)
• How to submit HTML for...
Type (2)
• How to submit HTML for...
How to send HTML form to Gmail?
• How to submit HTML for...
__________
1) Learn Google Apps Script
• Learn Google Apps Script
2) How to host your HTML code for free on google drive?
• How to host your HTML ...
3)Learn HTML,CSS,JS
play.google.co...

[@gauritanwar6624]

Thank you sooo much for this video I was looking for it its been 3 days since I was struggling to make the login page. Thank you so much. Subscribed

[@bhavikaseth6788]

Hi

[@bhavikaseth6788]

Can you help me in filling one Google form

[@bhavikaseth6788]

It's part of my project

[@bhavikaseth6788]

And put business associate in designation

[@elishaa2096]

Thanks for this video... will definitely need it at the end of my google sheet / appsheet project. Subscribed!

[@ClassicCoding]

You're welcome

[@MokimAhmed-s8l]

Thanks Aap ki video kabile tarif hae SIR

[@babosammo]

This is so great! Please how do you add WARNING username, email, or phone has already been used? And is it possible to point each user to different URL when they login? I really appreciate your work.

[@hackerspro2268]

this dude is amazing

[@hackerspro2268]

your videos are the best here on youtube

[@ClassicCoding]

Thank you ☺️

[@coolvibesreloaded7946]

done, done, done.... now i need this to redirect back to my site once people logged in

[@michaelmemphistransportser6393]

Thanks for the videos bro really helped..just wanna ask is after login how to go to specific page ? is it possible ?

[@gruvitec4236]

excelent video, and thanks for source code. and make more video like this... 👍

[@dimitrisvoudouris]

thank you, there will be videos with user login and then we can edit, delete items on a sheet as a database

[@bonzpon9724]

this is grape thank you so much for the idea and sharing also the source code.. grape grape!!! :D

[@obolaji]

Thanks for sharing this 🙏🏾🥰❤️. I've tested it, and it worked just exactly...

[@mrmf4712]

A good example how not to do authentication. 1) No one, including site owner should be able to see passwords of "registered" users. In the demo they are visible in plain text in the spreadsheet. 2) This "login" is useless until security token is given back to the web browser, which is not shown and not explain. How do you protect subsequent pages which meant to be shown to "signed in" users? Its better if you picked up another example, instead of "security". Btw did you kn ow that instead of ... = 'FALSE' you should be writing ... = false. There are such things as types in JS code....

[@majhawk8431]

can we create multiple sheets for a single user registered in another sheet and getting the name of new sheet from the register sheet

[@MaliturStudio]

Can you make a tutorial about how people can change their password or mail?

[@michaelsglas]

Hey awesome tutorial. By chance is it possible to add a photo at the top of the login?

[@SubhranshuChoudhury]

Possible

[@pedroguerreiro6045]

amazing! thank you. How can I stop the log in being successful when username and password fields are blank? cheers

[@kshiprachoubisa1499]

Just add required attribute in them

[@ederson2905]

@@kshiprachoubisa1499 Even putting required it works with blank login username and password

[@พรมณีขําเลิศ]

Thanks for the awesome tutorial video. After login how to go to specific url?😀

[@arkirubakaranraman7732]

❤️keep going thala osm work😍

[@ClassicCoding]

😄Hmm TQ da😃

[@bhavikaseth6788]

Hi

[@bhavikaseth6788]

Can you please fill one Google form,it's part of my project

[@bhavikaseth6788]

Fill business associate in designation

[@Ceon-t2q]

its showing invalid data even though i am putting correct credentials rest all code is working fine except login button plsee help !!!! or suggest some solution i have copied as it is your code and reviewed as well but then to login button is not working!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@A_GraphiX6]

wow nice

[@ClassicCoding]

😄

[@kynanglaptrinhcntt]

I wan't show email and phone ?

[@jedidiahthenewhomemarketin4285]

After you copied the web app URL what system is that that you’re using to create that script 8:10 in the video I can’t go any further without that

[@Saad.Elrefaey]

there are problrm nothing iam follow all your step and nothing , iam sucess at create new user but when try log in nothing where is the problem

[@ayushiderhgawen4407]

Is there no audio in this? I don't hear any audio.

[@rsrkimo]

I have a question for your advice! I just watched your high-quality video dozens of times, and I also downloaded two code files on your cloud. But my registration message can never be returned to (Google Sheets). My operation steps are exactly the same as your video.I don‘t know where the problem is? Please help me. Thank you.

[@rsrkimo]

I don‘t know if the two code in the video is the same as the two code versions in your cloud?

[@ClassicCoding]

Kindly watch video again, do what I did, it will work definitely....

[@KeviPegoraro]

For who is not getting succes in realize the login two things that will solve for you: 1) Remove the touppercase from the checkLogin function, that don't work anymore in app script: function checkLogin(username, password) { var url = 'YOUR SHEET LINK HERE'; var ss= SpreadsheetApp.openByUrl(url); var webAppSheet = ss.getSheetByName("DATA"); var getLastRow = webAppSheet.getLastRow(); var found_record = ''; for(var i = 1; i

[@coolvibesreloaded7946]

my forms not working could you help please........

[@ClassicCoding]

@coolvibesreloaded7946 Hi

[@ClassicCoding]

You can see the video, don't skip the video, do what I doing.

[@coolvibesreloaded7946]

@@ClassicCoding I did watch your video I didn't skip it, I've got the form up I'm pressing create now but nothings happening I've done everything in video!!

[@coolvibesreloaded7946]

@@ClassicCoding i'v now got it working but im trying to customize the buttons but its not letting me?

[@hero-os3nl]

Google sheets is far better and good than phpmyadmin

[@ClassicCoding]

yeah you're right💯👍

[@hero-os3nl]

@@ClassicCoding Bro some error came in doing this.....When I did all steps after that I copied link but it didn't showed anything in

[@ClassicCoding]

I guess you did not put the HTML file name in code.gs Watch the video again. don't skip the video. It works 💯% follow every steps.

[@muthukumar.e1005]

Useful

[@aryannanjappa6827]

super helpful

[@gutembergcosta5667]

Are you is top!!!

[@coolvibesreloaded7946]

Hello please answer how can i re-direct people to a web page after they have signed up.... How can i send them a confirmation email? Please answer

[@ayenimayokun4341]

How can I get notified when someone actually submit forms to the google sheet?

[@yohanajohn33]

Works thxz

[@jazneo150]

Thanks ❤ for scricpt

[@IdkMyName-v1t]

100% you got copyright...Thats ok! Excellent video btw! keep up th good work!!!!!!!!

[@ClassicCoding]

No. I don't get copyright, it's my own content, thanks you

[@IdkMyName-v1t]

@@ClassicCoding ohh no no I mean for the music. For 2 seconds in the video, music plays but not for the entire video. I thought you muted it. Sorry.

[@ClassicCoding]

It's ok, you are right ☺️, I got the copyright, but I took the music from the KZbin music library, then I don't know why it got copyrighted, that's why I muted the music ☺️..

[@IdkMyName-v1t]

@@ClassicCoding lol KZbin sucks 😅

[@ClassicCoding]

☺️

[@PhD-JWT]

When I open the loginandregfrom.html I get an error prompt "Sorry, unable to open the file at this time. Please check the address and try again." Now....I've copied and pasted the addresses.....so..... Any suggestions?

[@gpasindu_55]

thanksssss bro love you all day

[@rakanmurad8344]

cant to login

[@MaliturStudio]

How do I ban people or how do I delete accounts?

[@engupul]

Hello, I tried and noted that login form logged in for EMPTY username & Password..... Solution ?

[@ederson2905]

I´ve seen this too. I read here that we have to add required attribute in them. I´m trying to know how to do this.

[@talkwithtech07]

How can I add delay of some seconds on page 4th and then after redirect on my website.

[@ClassicCoding]

Ok it's possibl to set timings... MSG me what's app+919042804835

[@skrillex1107]

9:00 what is your program name?

[@coolvibesreloaded7946]

where is the source code you say apparently you put in description? @ClassicCoding

[@luongkiengxuong7653]

Sir I have a question, how to add button with code for forget password (to reset password when user forget it) please help me thank you verry much

[@ravikiranmutta1124]

login button not working once click on login what should i do

[@jaisankare1352]

Thanks

[@aryannanjappa6827]

Just back with a doubt that in our website where we intergrated it, after we have a successful login we want to redirect to the main page can you please help.

[@ClassicCoding]

Yes I will help you. See this video kzbin.info/www/bejne/a5OtZo2EfKqWq9E

[@aryannanjappa6827]

@@ClassicCoding Thanks

[@maitrechat276]

Hello. Is that working to connect on a google sheet ? I not want get email of users (security). So I find other login system to manage a shared google sheet, to know who clic on a button, and to show some information only to current user according to his pseudo.

[@BlueSky1]

amazing work plz if u can after login every student have his name and his marks :)) from iraq big thank

[@ClassicCoding]

Ok I will make the video

[@vinaykumar-zk8yr]

thank you sir👌

[@sandgaur]

Amazing work!

[@srikeerthiy2308]

thank u

[@ClassicCoding]

You're welcome

[@Notifi_Gamer]

I am getting error while deploying. Please help

[@luigigeremicca2041]

Congratulations for the video .. How can I integrate this procedure into my site created with google site?

[@HenkoEduca]

I keep getting the Invalid Data error everytime I try to login, why is that?

[@Goldenknowledgeforyou]

Thanks you so much : )

[@whitsney]

Valeu!

[@Michael-wc1ge]

Thank you good 👍🏻

[@toonimation_official]

Please tell me can we change the screen that appears after correct information is entered in login page. If yes then how? Please tell me its urgent.

[@ClassicCoding]

Yes we can change screen but right now, I don't have time to tell you. After 7pm only as per Indian time. You MSG me after 7

[@toonimation_official]

@@ClassicCoding can you just give me a hint..because i know programming very well so i can solve it by a hint..

[@LOTTOLAKAYBOULCHO]

Need theme plate for blogger with login and sign up

[@ClassicCoding]

Yes, I have themes, and I will make what you expect, message me what's app, [phone] ,will discuss....

[@musiccelebrity1690]

Hello! If I share this file HTML, will I always receive the data?

[@ClassicCoding]

Yes

[@chintala5817]

If i want to execute a new page of html after user logged in where can i write the code

[@alessandraalves8585]

hello friend I really liked it and I'm learning a lot with you could you show me how to do Google sites login and password

[@mortensrensen624]

can you use this control access to a google sheet file?

[@srikeerthiy2308]

thank u very much sir, can u tell me the date u will post it on

[@ClassicCoding]

I will try to post within a week. Okay

[@ClassicCoding]

kzbin.info/www/bejne/a5OtZo2EfKqWq9E

[@showbikshowmma3520]

how to encrypt the password in google sheet

[@remengame5530]

I want to download html file, but file isn't available... please help bro

[@Withnitish]

Kya ese Google forms pe bhi add kr skte h

[@bhavikaseth6788]

Can you please fill this form it's part of my project

[@bhavikaseth6788]

Put business associate in designation

[@gijswillemsen-o7r]

thx

[@umangjangid9524]

how to open different website with different id and password through google seets

[@mohamaddarwish3765]

Tq

[@kibe859]

how to show user data after login with the help of google sheets and app script

[@ikc06]

Bro this is awesome bro . I am running education website . I need to display user rank bro . How can I display that

[@ClassicCoding]

Okay, I will post soon. First, I put a video on how to display sheet data on a webpage. After that I will post. stay connect until then....

[@ikc06]

@@ClassicCoding Yeah bro I am waiting and please upload javascript full tutorials bro

[@Zashcrypto1]

Sir web app url copy kar ka ap kon sa app pa gay han

[@ClassicCoding]

Watch full video,

[@QA_johngonzales]

how to get the script pllss help

[@cotychaveS]

Bro, thank you very much!, how can I show more rows of the same user?

[@supasounds2024]

don't see the script editor under tools

[@ovizfashion9072]

how to display sheet2 after login?

[@buenmarjulom8621]

Hello guys It is avail to use Excel?

[@srikeerthiy2308]

sir i have to enter to my website after logging in sir can w talk about it pls on phone

[@VivekGurav-zy2mu]

Blogger pein kaise use karenge

[@ClassicCoding]

Msg me what's app, I will help you, [phone]

[@Denver_Dude_777]

Can i change how it looks?

[@thomasanders1954]

I have a entry from created in sheet that i want to share to 10 user, so i duplicate the usersheet to 10 separate spreadsheet. I wanna to make a web form login, that if User A login it goes to A spreadsheet so on So the form is just a gateway to another sheet. Can it possible?

[@SaiKrishna-tu1uc]

can you help us with the code script

[@ishaansinghvlogs]

Sir ye website me open nahi ho raha hai

[@shreyashk246]

can u paste the code here please

[@mybgmmusic]

Hi may I know how to create a App Script HTML log in and register form using google sheet data and show the log in user data in google sheet

[@sidiefofanah9548]

where is the link to the code please

[@surajsoni1938]

Bhai achi video thi but mujhe ek cheej karni hai code mai help kardo bhai

[@ClassicCoding]

Kindly comment in English brother.

[@harshvardhan3299]

login button dont work

[@pit_lemal]

I have a question, how can i link my website after user had been logged in?

[@ClassicCoding]

Okay I will make video soon.

[@pit_lemal]

@@ClassicCoding Thank you very much Sir

[@pit_lemal]

Is it possible to explain me in an email how to do it, because it’s urgent

[@ClassicCoding]

I will post the video today.

[@pit_lemal]

@@ClassicCoding Thank you really much Sir

[@mohammedsiraj6162]

How can I use it with Google Sites? Please, explain.

[@alessandraalves8585]

you found out?

[@md.shamsurrahman2126]

thanks

[@felicitomanuelcaliwcaliw5932]

How to prevent double registration?

[@MaxBhardwaj]

Bhai website se attached krne ka source code de do.

[@Anonymous-mz2fl]

doGet issues, code doesnt work

[@ClassicCoding]

Watch the video again, don’t skip the video, just do what I do. It works 💯👍

[@kynanglaptrinhcntt]

I want display username, email, phone when the login

[@ClassicCoding]

It's easy, just understand the code

[@kynanglaptrinhcntt]

@@ClassicCoding I haven't done this yet, can you do it and send me the code ?Thank

[@ClassicCoding]

Okay , I will send the code

[@amboupe6143]

How to add data input page after successful login, thank you

[@srikeerthiy2308]

I have a question, how can i link my website after user had been logged in? pls sir make a video on it i wish it comes soon

[@ClassicCoding]

Well I will make the video soon👍

[@ClassicCoding]

kzbin.info/www/bejne/a5OtZo2EfKqWq9E

[@ClassicCoding]

Hi

[@venkatvenky7876]

It's not working