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

Поделиться
HTML-код
  • Опубликовано: 2 ноя 2024

Комментарии • 195

  • @elishaa2096
    @elishaa2096 3 года назад +7

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

  • @gauritanwar6624
    @gauritanwar6624 Год назад +2

    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

  • @hackerspro2268
    @hackerspro2268 2 года назад +1

    your videos are the best here on youtube

  • @gruvitec4236
    @gruvitec4236 2 года назад +2

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

  • @coolvibesreloaded7946
    @coolvibesreloaded7946 10 месяцев назад

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

  • @MokimAhmed-s8l
    @MokimAhmed-s8l Месяц назад

    Thanks Aap ki video kabile tarif hae SIR

  • @obolaji
    @obolaji Год назад

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

  • @bonzpon9724
    @bonzpon9724 2 года назад +2

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

  • @michaelmemphistransportser6393
    @michaelmemphistransportser6393 2 года назад +2

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

  • @babosammo
    @babosammo 2 года назад +6

    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.

  • @MaliturStudio
    @MaliturStudio Год назад +1

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

  • @pedroguerreiro6045
    @pedroguerreiro6045 3 года назад +4

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

    • @kshiprachoubisa1499
      @kshiprachoubisa1499 2 года назад +1

      Just add required attribute in them

    • @ederson2905
      @ederson2905 Год назад

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

  • @dimitrisvoudouris
    @dimitrisvoudouris 3 года назад +1

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

  • @michaelsglas
    @michaelsglas 2 года назад +4

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

  • @พรมณีขําเลิศ
    @พรมณีขําเลิศ 2 года назад +2

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

  • @LOTTOLAKAYBOULCHO
    @LOTTOLAKAYBOULCHO Год назад +1

    Need theme plate for blogger with login and sign up

    • @ClassicCoding
      @ClassicCoding  Год назад

      Yes, I have themes, and I will make what you expect, message me what's app, +919042804835 ,will discuss....

  • @muthukumar.e1005
    @muthukumar.e1005 3 года назад +3

    Useful

  • @majhawk8431
    @majhawk8431 2 года назад +1

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

  • @arkirubakaranraman7732
    @arkirubakaranraman7732 3 года назад +2

    ❤️keep going thala osm work😍

  • @luigigeremicca2041
    @luigigeremicca2041 2 года назад

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

  • @jazneo150
    @jazneo150 3 года назад +1

    Thanks ❤ for scricpt

  • @gpasindu_55
    @gpasindu_55 2 года назад

    thanksssss bro love you all day

  • @maitrechat276
    @maitrechat276 2 года назад

    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.

  • @jedidiahthenewhomemarketin4285
    @jedidiahthenewhomemarketin4285 2 года назад +1

    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

  • @aryannanjappa6827
    @aryannanjappa6827 2 года назад +2

    super helpful

  • @A_GraphiX6
    @A_GraphiX6 3 года назад +2

    wow nice

  • @talkwithtech07
    @talkwithtech07 Год назад +1

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

    • @ClassicCoding
      @ClassicCoding  Год назад

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

  • @alessandraalves8585
    @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

  • @cotychaveS
    @cotychaveS 2 года назад

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

  • @kynanglaptrinhcntt
    @kynanglaptrinhcntt 3 года назад +1

    I wan't show email and phone ?

  • @rsrkimo
    @rsrkimo 2 года назад

    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
      @rsrkimo 2 года назад

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

    • @ClassicCoding
      @ClassicCoding  2 года назад +1

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

  • @srikeerthiy2308
    @srikeerthiy2308 3 года назад +1

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

    • @ClassicCoding
      @ClassicCoding  3 года назад

      I will try to post within a week. Okay

    • @ClassicCoding
      @ClassicCoding  3 года назад

      ruclips.net/video/5bJ5ZNGEcuo/видео.html

  • @coolvibesreloaded7946
    @coolvibesreloaded7946 8 месяцев назад

    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

  • @gutembergcosta5667
    @gutembergcosta5667 3 года назад +1

    Are you is top!!!

  • @IdkMyName-v1t
    @IdkMyName-v1t 2 года назад

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

    • @ClassicCoding
      @ClassicCoding  2 года назад

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

    • @IdkMyName-v1t
      @IdkMyName-v1t 2 года назад

      @@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
      @ClassicCoding  2 года назад

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

    • @IdkMyName-v1t
      @IdkMyName-v1t 2 года назад

      @@ClassicCoding lol RUclips sucks 😅

    • @ClassicCoding
      @ClassicCoding  2 года назад +1

      ☺️

  • @ikc06
    @ikc06 3 года назад +2

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

    • @ClassicCoding
      @ClassicCoding  3 года назад +2

      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
      @ikc06 3 года назад +3

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

  • @Ceon-t2q
    @Ceon-t2q 2 месяца назад

    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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @skrillex1107
    @skrillex1107 2 года назад +1

    9:00 what is your program name?

  • @aryannanjappa6827
    @aryannanjappa6827 2 года назад +1

    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
      @ClassicCoding  2 года назад

      Yes I will help you. See this video ruclips.net/video/5bJ5ZNGEcuo/видео.html

    • @aryannanjappa6827
      @aryannanjappa6827 2 года назад

      @@ClassicCoding Thanks

  • @mortensrensen624
    @mortensrensen624 2 года назад

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

  • @BlueSky1
    @BlueSky1 3 года назад +1

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

  • @engupul
    @engupul 2 года назад +1

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

    • @ederson2905
      @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.

  • @sandgaur
    @sandgaur 3 года назад +3

    Amazing work!

  • @luongkiengxuong7653
    @luongkiengxuong7653 2 года назад

    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

  • @vinaykumar-zk8yr
    @vinaykumar-zk8yr 2 года назад

    thank you sir👌

  • @mrmf4712
    @mrmf4712 Год назад +1

    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....

  • @Michael-wc1ge
    @Michael-wc1ge Год назад

    Thank you good 👍🏻

  • @ovizfashion9072
    @ovizfashion9072 Год назад

    how to display sheet2 after login?

  • @Goldenknowledgeforyou
    @Goldenknowledgeforyou 2 года назад

    Thanks you so much : )

  • @PhD-JWT
    @PhD-JWT 2 года назад

    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?

  • @mybgmmusic
    @mybgmmusic 2 года назад

    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

  • @PneumaticSystems
    @PneumaticSystems 2 года назад

    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

  • @jaisankare1352
    @jaisankare1352 Год назад +1

    Thanks

  • @chintala5817
    @chintala5817 2 года назад

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

  • @MaliturStudio
    @MaliturStudio 2 года назад +1

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

  • @Denver_Dude_777
    @Denver_Dude_777 2 года назад

    Can i change how it looks?

  • @coolvibesreloaded7946
    @coolvibesreloaded7946 10 месяцев назад

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

  • @toonimation_official
    @toonimation_official 5 месяцев назад

    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
      @ClassicCoding  5 месяцев назад

      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
      @toonimation_official 5 месяцев назад

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

  • @yohanajohn33
    @yohanajohn33 5 месяцев назад

    Works thxz

  • @srikeerthiy2308
    @srikeerthiy2308 3 года назад

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

  • @amboupe6143
    @amboupe6143 3 года назад

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

  • @surajsoni1938
    @surajsoni1938 2 года назад +1

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

  • @srikeerthiy2308
    @srikeerthiy2308 3 года назад +2

    thank u

  • @Withnitish
    @Withnitish 3 года назад +1

    Kya ese Google forms pe bhi add kr skte h

    • @bhavikaseth6788
      @bhavikaseth6788 6 месяцев назад

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

    • @bhavikaseth6788
      @bhavikaseth6788 6 месяцев назад

      Put business associate in designation

  • @musiccelebrity1690
    @musiccelebrity1690 3 года назад +1

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

  • @rakanmurad8344
    @rakanmurad8344 Год назад +1

    cant to login

  • @buenmarjulom8621
    @buenmarjulom8621 2 года назад

    Hello guys
    It is avail to use Excel?

  • @thomasanders1954
    @thomasanders1954 3 года назад +1

    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?

  • @QA_johngonzales
    @QA_johngonzales 6 месяцев назад

    how to get the script pllss help

  • @kibe859
    @kibe859 2 года назад

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

  • @ayenimayokun4341
    @ayenimayokun4341 Год назад

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

  • @Zashcrypto1
    @Zashcrypto1 2 месяца назад

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

  • @hero-os3nl
    @hero-os3nl 3 года назад +8

    Google sheets is far better and good than phpmyadmin

    • @ClassicCoding
      @ClassicCoding  3 года назад +4

      yeah you're right💯👍

    • @hero-os3nl
      @hero-os3nl 3 года назад +2

      @@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
      @ClassicCoding  3 года назад +1

      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.

  • @Notifi_Gamer
    @Notifi_Gamer Год назад

    I am getting error while deploying. Please help

  • @mohammedsiraj6162
    @mohammedsiraj6162 Год назад

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

  • @mohamaddarwish3765
    @mohamaddarwish3765 2 года назад +1

    Tq

  • @kynanglaptrinhcntt
    @kynanglaptrinhcntt 3 года назад +1

    I want display username, email, phone when the login

    • @ClassicCoding
      @ClassicCoding  3 года назад

      It's easy, just understand the code

    • @kynanglaptrinhcntt
      @kynanglaptrinhcntt 3 года назад +1

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

    • @ClassicCoding
      @ClassicCoding  3 года назад

      Okay , I will send the code

  • @HenkoEduca
    @HenkoEduca 2 года назад

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

  • @umangjangid9524
    @umangjangid9524 2 года назад

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

  • @whitsney
    @whitsney 2 месяца назад

    Valeu!

  • @SaiKrishna-tu1uc
    @SaiKrishna-tu1uc 7 месяцев назад

    can you help us with the code script

  • @remengame5530
    @remengame5530 3 года назад

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

  • @pit_lemal
    @pit_lemal 3 года назад +1

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

    • @ClassicCoding
      @ClassicCoding  3 года назад +1

      Okay I will make video soon.

    • @pit_lemal
      @pit_lemal 3 года назад

      @@ClassicCoding Thank you very much Sir

    • @pit_lemal
      @pit_lemal 3 года назад

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

    • @ClassicCoding
      @ClassicCoding  3 года назад

      I will post the video today.

    • @pit_lemal
      @pit_lemal 3 года назад +1

      @@ClassicCoding Thank you really much Sir

  • @srikeerthiy2308
    @srikeerthiy2308 3 года назад

    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

  • @ravikiranmutta1124
    @ravikiranmutta1124 Год назад

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

  • @supasounds2024
    @supasounds2024 Год назад

    don't see the script editor under tools

  • @showbikshowmma3520
    @showbikshowmma3520 7 месяцев назад

    how to encrypt the password in google sheet

  • @ayushiderhgawen4407
    @ayushiderhgawen4407 Месяц назад

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

  • @KeviPegoraro
    @KeviPegoraro 2 года назад +5

    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
      @coolvibesreloaded7946 10 месяцев назад

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

    • @ClassicCoding
      @ClassicCoding  10 месяцев назад

      @coolvibesreloaded7946 Hi

    • @ClassicCoding
      @ClassicCoding  10 месяцев назад

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

    • @coolvibesreloaded7946
      @coolvibesreloaded7946 10 месяцев назад

      @@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
      @coolvibesreloaded7946 10 месяцев назад

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

  • @VivekGurav-zy2mu
    @VivekGurav-zy2mu Год назад +1

    Blogger pein kaise use karenge

    • @ClassicCoding
      @ClassicCoding  Год назад

      Msg me what's app, I will help you, +919042804835

  • @md.shamsurrahman2126
    @md.shamsurrahman2126 2 года назад

    thanks

  • @gijswillemsen-o7r
    @gijswillemsen-o7r 8 месяцев назад

    thx

  • @shreyashk246
    @shreyashk246 Год назад

    can u paste the code
    here
    please

  • @sidiefofanah9548
    @sidiefofanah9548 Год назад

    where is the link to the code please

  • @sonysuorn1037
    @sonysuorn1037 Год назад

    Very good sir, Please give me that text file of the code

  • @felicitomanuelcaliwcaliw5932
    @felicitomanuelcaliwcaliw5932 2 года назад

    How to prevent double registration?

  • @MaxBhardwaj
    @MaxBhardwaj Год назад

    Bhai website se attached krne ka source code de do.

  • @ishaansinghvlogs
    @ishaansinghvlogs 2 года назад

    Sir ye website me open nahi ho raha hai

  • @Suchit_Plays07
    @Suchit_Plays07 Год назад

    Make video on without app script

    • @ClassicCoding
      @ClassicCoding  Год назад +1

      In which backend language u want? Like php.. ?

    • @Suchit_Plays07
      @Suchit_Plays07 Год назад

      @@ClassicCoding SQL is ok php also ok

    • @ClassicCoding
      @ClassicCoding  Год назад

      Ok,. Do u have what's app? If there, MSG me, +919042804835

  • @harshvardhan3299
    @harshvardhan3299 2 года назад

    login button dont work