How to create Login and Register Form using Google spreadsheet data?
ฝัง
- เผยแพร่เมื่อ 26 ก.ย. 2024
- 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...
Thanks Aap ki video kabile tarif hae SIR
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
Hi
Can you help me in filling one Google form
It's part of my project
And put business associate in designation
Thanks for this video... will definitely need it at the end of my google sheet / appsheet project. Subscribed!
You're welcome
your videos are the best here on youtube
Thank you ☺️
excelent video, and thanks for source code. and make more video like this... 👍
Thanks for sharing this 🙏🏾🥰❤️.
I've tested it, and it worked just exactly...
done, done, done.... now i need this to redirect back to my site once people logged in
this is grape thank you so much for the idea and sharing also the source code.. grape grape!!! :D
thank you, there will be videos with user login and then we can edit, delete items on a sheet as a database
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.
this dude is amazing
Can you make a tutorial about how people can change their password or mail?
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
my forms not working could you help please........
@coolvibesreloaded7946 Hi
You can see the video, don't skip the video, do what I doing.
@@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!!
@@ClassicCoding i'v now got it working but im trying to customize the buttons but its not letting me?
Thanks for the videos bro really helped..just wanna ask is after login how to go to specific page ? is it possible ?
Thanks for the awesome tutorial video. After login how to go to specific url?😀
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....
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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
can we create multiple sheets for a single user registered in another sheet and getting the name of new sheet from the register sheet
Useful
❤️keep going thala osm work😍
😄Hmm TQ da😃
Hi
Can you please fill one Google form,it's part of my project
Fill business associate in designation
Thanks ❤ for scricpt
Need theme plate for blogger with login and sign up
Yes, I have themes, and I will make what you expect, message me what's app, +919042804835 ,will discuss....
I wan't show email and phone ?
amazing! thank you. How can I stop the log in being successful when username and password fields are blank? cheers
Just add required attribute in them
@@kshiprachoubisa1499 Even putting required it works with blank login username and password
super helpful
wow nice
😄
How do I ban people or how do I delete accounts?
Thanks
Hey awesome tutorial. By chance is it possible to add a photo at the top of the login?
Possible
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
100% you got copyright...Thats ok! Excellent video btw! keep up th good work!!!!!!!!
No. I don't get copyright, it's my own content, thanks you
@@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.
It's ok, you are right ☺️, I got the copyright, but I took the music from the TH-cam music library, then I don't know why it got copyrighted, that's why I muted the music ☺️..
@@ClassicCoding lol TH-cam sucks 😅
☺️
cant to login
Is there no audio in this? I don't hear any audio.
Works thxz
thanksssss bro love you all day
How can I add delay of some seconds on page 4th and then after redirect on my website.
Ok it's possibl to set timings... MSG me what's app+919042804835
Are you is top!!!
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
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
9:00 what is your program name?
Google sheets is far better and good than phpmyadmin
yeah you're right💯👍
@@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
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.
thank u
You're welcome
thank you sir👌
Thank you good 👍🏻
Hello, I tried and noted that login form logged in for EMPTY username & Password..... Solution ?
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.
Thanks you so much : )
Tq
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?
thx
Congratulations for the video .. How can I integrate this procedure into my site created with google site?
where is the source code you say apparently you put in description? @ClassicCoding
Amazing work!
I am getting error while deploying. Please help
Blogger pein kaise use karenge
Msg me what's app, I will help you, +919042804835
how to encrypt the password in google sheet
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.
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
@@ClassicCoding can you just give me a hint..because i know programming very well so i can solve it by a hint..
how to display sheet2 after login?
Valeu!
how to open different website with different id and password through google seets
how to get the script pllss help
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.
Yes I will help you. See this video th-cam.com/video/5bJ5ZNGEcuo/w-d-xo.html
@@ClassicCoding Thanks
how to show user data after login with the help of google sheets and app script
login button not working once click on login what should i do
Bro this is awesome bro . I am running education website . I need to display user rank bro . How can I display that
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....
@@ClassicCoding
Yeah bro I am waiting and please upload javascript full tutorials bro
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.
can you use this control access to a google sheet file?
Bro, thank you very much!, how can I show more rows of the same user?
thank u very much sir, can u tell me the date u will post it on
I will try to post within a week. Okay
th-cam.com/video/5bJ5ZNGEcuo/w-d-xo.html
can you help us with the code script
Hello guys
It is avail to use Excel?
If i want to execute a new page of html after user logged in where can i write the code
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
Can i change how it looks?
I keep getting the Invalid Data error everytime I try to login, why is that?
don't see the script editor under tools
I want to download html file, but file isn't available... please help bro
Kya ese Google forms pe bhi add kr skte h
Can you please fill this form it's part of my project
Put business associate in designation
sir i have to enter to my website after logging in sir can w talk about it pls on phone
How to add data input page after successful login, thank you
thanks
can u paste the code
here
please
Bhai achi video thi but mujhe ek cheej karni hai code mai help kardo bhai
Kindly comment in English brother.
Sir ye website me open nahi ho raha hai
Bhai website se attached krne ka source code de do.
I want display username, email, phone when the login
It's easy, just understand the code
@@ClassicCoding I haven't done this yet, can you do it and send me the code ?Thank
Okay , I will send the code
How to prevent double registration?
Is Google script diamond money to run script
Hata={Error}
Exception: Bad value
Very good sir, Please give me that text file of the code
login button dont work
where is the link to the code please
I have a question, how can i link my website after user had been logged in?
Okay I will make video soon.
@@ClassicCoding Thank you very much Sir
Is it possible to explain me in an email how to do it, because it’s urgent
I will post the video today.
@@ClassicCoding Thank you really much Sir
Make video on without app script
In which backend language u want? Like php.. ?
@@ClassicCoding SQL is ok php also ok
Ok,. Do u have what's app? If there, MSG me, +919042804835
Hello brother
doGet issues, code doesnt work
Watch the video again, don’t skip the video, just do what I do. It works 💯👍
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?
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
Well I will make the video soon👍
th-cam.com/video/5bJ5ZNGEcuo/w-d-xo.html
Hi
login and show email, phone. Thank
It's not working
Redirect in same page after login bro
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
I frame not working bro please help 😭
Ok i will help you, watch video again ,do what I did, will work definitely.