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

แชร์
ฝัง
  • เผยแพร่เมื่อ 18 ธ.ค. 2024

ความคิดเห็น • 198

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

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

      Hi

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

      Can you help me in filling one Google form

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

      It's part of my project

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

      And put business associate in designation

  • @elishaa2096
    @elishaa2096 3 ปีที่แล้ว +8

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

  • @ChhotiMotiChidia
    @ChhotiMotiChidia 18 วันที่ผ่านมา

    I love You bro I am Wondering From 2 months but I had Never seen such a amazing vedio

    • @ClassicCoding
      @ClassicCoding  6 วันที่ผ่านมา

      Thank you so much 😀

  • @hackerspro2268
    @hackerspro2268 2 ปีที่แล้ว +1

    your videos are the best here on youtube

  • @coolvibesreloaded7946
    @coolvibesreloaded7946 ปีที่แล้ว

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

  • @gruvitec4236
    @gruvitec4236 2 ปีที่แล้ว +2

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

  • @bonzpon9724
    @bonzpon9724 2 ปีที่แล้ว +2

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

  • @obolaji
    @obolaji ปีที่แล้ว

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

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

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

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

  • @whitsney
    @whitsney 3 หลายเดือนก่อน

    Valeu!

  • @MokimAhmedBlp
    @MokimAhmedBlp 2 หลายเดือนก่อน

    Thanks Aap ki video kabile tarif hae SIR

  • @skrillex1107
    @skrillex1107 2 ปีที่แล้ว +1

    9:00 what is your program name?

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

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

  • @MaliturStudio
    @MaliturStudio ปีที่แล้ว +1

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

  • @พรมณีขําเลิศ
    @พรมณีขําเลิศ 2 ปีที่แล้ว +2

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

  • @arkirubakaranraman7732
    @arkirubakaranraman7732 3 ปีที่แล้ว +2

    ❤️keep going thala osm work😍

    • @ClassicCoding
      @ClassicCoding  3 ปีที่แล้ว +1

      😄Hmm TQ da😃

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

      Hi

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

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

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

      Fill business associate in designation

  • @michaelsglas
    @michaelsglas 2 ปีที่แล้ว +4

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

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

  • @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 2 ปีที่แล้ว

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

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

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

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

  • @aryannanjappa6827
    @aryannanjappa6827 3 ปีที่แล้ว +2

    super helpful

  • @gpasindu_55
    @gpasindu_55 2 ปีที่แล้ว

    thanksssss bro love you all day

  • @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 TH-cam 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 TH-cam sucks 😅

    • @ClassicCoding
      @ClassicCoding  2 ปีที่แล้ว +1

      ☺️

  • @muthukumar.e1005
    @muthukumar.e1005 3 ปีที่แล้ว +3

    Useful

  • @jazneo150
    @jazneo150 3 ปีที่แล้ว +1

    Thanks ❤ for scricpt

  • @coolvibesreloaded7946
    @coolvibesreloaded7946 10 หลายเดือนก่อน

    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

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

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

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

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

  • @A_GraphiX6
    @A_GraphiX6 3 ปีที่แล้ว +2

    wow nice

  • @toonimation_official
    @toonimation_official 6 หลายเดือนก่อน

    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  6 หลายเดือนก่อน

      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 6 หลายเดือนก่อน

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

  • @aryannanjappa6827
    @aryannanjappa6827 3 ปีที่แล้ว +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  3 ปีที่แล้ว

      Yes I will help you. See this video th-cam.com/video/5bJ5ZNGEcuo/w-d-xo.html

    • @aryannanjappa6827
      @aryannanjappa6827 3 ปีที่แล้ว

      @@ClassicCoding Thanks

  • @kynanglaptrinhcntt
    @kynanglaptrinhcntt 3 ปีที่แล้ว +1

    I wan't show email and phone ?

  • @luigigeremicca2041
    @luigigeremicca2041 2 ปีที่แล้ว

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

  • @Detronic_Gamer
    @Detronic_Gamer หลายเดือนก่อน

    thanks bro

  • @mortensrensen624
    @mortensrensen624 2 ปีที่แล้ว

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

  • @Zashcrypto1
    @Zashcrypto1 3 หลายเดือนก่อน

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

    • @ClassicCoding
      @ClassicCoding  3 หลายเดือนก่อน

      Watch full video,

  • @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 ปีที่แล้ว

      th-cam.com/video/5bJ5ZNGEcuo/w-d-xo.html

  • @sandgaur
    @sandgaur 3 ปีที่แล้ว +3

    Amazing work!

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

  • @engupul
    @engupul 2 ปีที่แล้ว +1

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

    • @ederson2905
      @ederson2905 2 ปีที่แล้ว

      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.

  • @Withnitish
    @Withnitish 3 ปีที่แล้ว +1

    Kya ese Google forms pe bhi add kr skte h

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

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

    • @bhavikaseth6788
      @bhavikaseth6788 7 หลายเดือนก่อน

      Put business associate in designation

  • @chintala5817
    @chintala5817 2 ปีที่แล้ว

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

  • @Ceon-t2q
    @Ceon-t2q 3 หลายเดือนก่อน

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

  • @MaliturStudio
    @MaliturStudio 2 ปีที่แล้ว +1

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

  • @vinaykumar-zk8yr
    @vinaykumar-zk8yr 2 ปีที่แล้ว

    thank you sir👌

  • @gutembergcosta5667
    @gutembergcosta5667 3 ปีที่แล้ว +1

    Are you is top!!!

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

  • @coolvibesreloaded7946
    @coolvibesreloaded7946 ปีที่แล้ว

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

  • @ayenimayokun4341
    @ayenimayokun4341 ปีที่แล้ว

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

  • @musiccelebrity1690
    @musiccelebrity1690 3 ปีที่แล้ว +1

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

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

  • @cotychaveS
    @cotychaveS 2 ปีที่แล้ว

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

  • @srikeerthiy2308
    @srikeerthiy2308 3 ปีที่แล้ว

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

  • @Michael-wc1ge
    @Michael-wc1ge ปีที่แล้ว

    Thank you good 👍🏻

  • @Goldenknowledgeforyou
    @Goldenknowledgeforyou 2 ปีที่แล้ว

    Thanks you so much : )

  • @kibe859
    @kibe859 2 ปีที่แล้ว

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

  • @BlueSky1
    @BlueSky1 3 ปีที่แล้ว +1

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

  • @ovizfashion9072
    @ovizfashion9072 ปีที่แล้ว

    how to display sheet2 after login?

  • @surajsoni1938
    @surajsoni1938 2 ปีที่แล้ว +1

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

    • @ClassicCoding
      @ClassicCoding  2 ปีที่แล้ว

      Kindly comment in English brother.

  • @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 ปีที่แล้ว

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

    • @ClassicCoding
      @ClassicCoding  ปีที่แล้ว

      @coolvibesreloaded7946 Hi

    • @ClassicCoding
      @ClassicCoding  ปีที่แล้ว

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

    • @coolvibesreloaded7946
      @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
      @coolvibesreloaded7946 ปีที่แล้ว

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

  • @Notifi_Gamer
    @Notifi_Gamer ปีที่แล้ว

    I am getting error while deploying. Please help

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

  • @ayushiderhgawen4407
    @ayushiderhgawen4407 3 หลายเดือนก่อน

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

  • @Denver_Dude_777
    @Denver_Dude_777 2 ปีที่แล้ว

    Can i change how it looks?

  • @ravikiranmutta1124
    @ravikiranmutta1124 ปีที่แล้ว

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

  • @VivekGurav-zy2mu
    @VivekGurav-zy2mu ปีที่แล้ว +1

    Blogger pein kaise use karenge

    • @ClassicCoding
      @ClassicCoding  ปีที่แล้ว

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

  • @QA_johngonzales
    @QA_johngonzales 7 หลายเดือนก่อน

    how to get the script pllss help

  • @rakanmurad8344
    @rakanmurad8344 ปีที่แล้ว +1

    cant to login

  • @HenkoEduca
    @HenkoEduca 2 ปีที่แล้ว

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

  • @supasounds2024
    @supasounds2024 ปีที่แล้ว

    don't see the script editor under tools

  • @umangjangid9524
    @umangjangid9524 2 ปีที่แล้ว

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

  • @buenmarjulom8621
    @buenmarjulom8621 2 ปีที่แล้ว

    Hello guys
    It is avail to use Excel?

  • @mohammedsiraj6162
    @mohammedsiraj6162 ปีที่แล้ว

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

  • @remengame5530
    @remengame5530 3 ปีที่แล้ว

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

  • @srikeerthiy2308
    @srikeerthiy2308 3 ปีที่แล้ว +2

    thank u

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

  • @amboupe6143
    @amboupe6143 3 ปีที่แล้ว

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

  • @yohanajohn33
    @yohanajohn33 7 หลายเดือนก่อน

    Works thxz

  • @ishaansinghvlogs
    @ishaansinghvlogs 3 ปีที่แล้ว

    Sir ye website me open nahi ho raha hai

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

  • @farukazam7250
    @farukazam7250 3 ปีที่แล้ว +1

    Thanks

  • @showbikshowmma3520
    @showbikshowmma3520 8 หลายเดือนก่อน

    how to encrypt the password in google sheet

  • @SaiKrishna-tu1uc
    @SaiKrishna-tu1uc 9 หลายเดือนก่อน

    can you help us with the code script

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

  • @felicitomanuelcaliwcaliw5932
    @felicitomanuelcaliwcaliw5932 2 ปีที่แล้ว

    How to prevent double registration?

  • @sonysuorn1037
    @sonysuorn1037 ปีที่แล้ว

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

  • @mohamaddarwish3765
    @mohamaddarwish3765 2 ปีที่แล้ว +1

    Tq

  • @sidiefofanah9548
    @sidiefofanah9548 ปีที่แล้ว

    where is the link to the code please

  • @MaxBhardwaj
    @MaxBhardwaj ปีที่แล้ว

    Bhai website se attached krne ka source code de do.

  • @shreyashk246
    @shreyashk246 ปีที่แล้ว

    can u paste the code
    here
    please

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

  • @Suchit_Plays_Song
    @Suchit_Plays_Song ปีที่แล้ว

    Make video on without app script

    • @ClassicCoding
      @ClassicCoding  ปีที่แล้ว +1

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

    • @Suchit_Plays_Song
      @Suchit_Plays_Song ปีที่แล้ว

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