Apps Script: Dynamic Forms Multiple Choice

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ก.ย. 2024

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

  • @omersolis3928
    @omersolis3928 5 ปีที่แล้ว +4

    Hi Jordan. Can I get data from a google Sheet after selecting a choise from a dropdown?. For example, I select the userID from the dropdown list, so with this userId I could get the address and telephone from a google Sheet, and show these data in the same google formin static mode?

    • @gohan794
      @gohan794 4 ปีที่แล้ว

      Any solutions? Regards!

  • @issamlotfi
    @issamlotfi 5 ปีที่แล้ว +5

    Thanks Jordan ! it's an awesome tutorial !
    A question : Can we dynamically create the elements of a drop-down list following to a choice made on a previous drop-down list (before sending the form) ? - the data is on a google sheet.

    • @julia.vasilieva
      @julia.vasilieva 5 ปีที่แล้ว +1

      I'd like to know that too!)

    • @MohamadSaat
      @MohamadSaat 5 ปีที่แล้ว

      🤔

    • @gohan794
      @gohan794 4 ปีที่แล้ว

      Did you guys found an answer?

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

    How do i get MULTIPLE CHOICE (auto added here) in ALPHABETICAL order each time it is added ?

  • @igainc.7633
    @igainc.7633 4 ปีที่แล้ว +1

    Would it be easier to setting a worksheet to use the formula =Unique(colStart:colEnd) and pull in that data using app script?

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

    hey Jordan,
    thanks for the great lesson. I was curious to know if we can add conditional filter to the form's app script and make the changes without the form submit option

  • @geraldinebrigante4710
    @geraldinebrigante4710 4 ปีที่แล้ว

    Sir Jordan,
    Thank you very much, you just gained another subscriber :)
    Great job explaining!

  • @abdullahquhtani4247
    @abdullahquhtani4247 5 ปีที่แล้ว

    Do you do freelance tasks? Kindly send me your email if so.

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

    Hi, does anyone knows if I can create a hidden field in Google Forms?

    • @JordanRhea
      @JordanRhea  5 ปีที่แล้ว

      Sorry but no hidden fields in a Google Form. You have to create your own form with HTML for that.

  • @riteshpandey5082
    @riteshpandey5082 4 ปีที่แล้ว

    Hello Sir, are you well? We are missing you videos from last 4 months, you have not uploaded any videos. Please take care of yourself.

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

    Thank you! Help me a lot... I'm a Sales Manager and I want to create a follow up sale pipeline using a workflow with forms. One form to create a client, this form should validate if the client already exist, then create the sales opportunity and give a sales stage and a probability to win. Then I want to create a remainder email with the pre-fill form to all seles force to update their opportunities on every friday... At this moment this video help me to present a list of all customer, so the can select one or create a new one... It will be grate if you can show more tips to do this.

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

    Before I make it to the end of this video, I want to say thank you for being a teacher and making this video short sweet and to the point! Excellent Job!

  • @monicaraviraj8544
    @monicaraviraj8544 4 ปีที่แล้ว

    can we link the time parameter in the google form to the system time!? lik writing a function jt fr the time display

  • @hectortd
    @hectortd 4 ปีที่แล้ว

    Jordan it works great thanks a lot, I just want to get the values from other sheet in the same spreadsheet, I know its pretty basic but i cant get it to work, could you help me with that?/ Thanks for the videos

  • @bumpersmith
    @bumpersmith 4 ปีที่แล้ว

    How can a login form be created (with email and password) after a user has registered in the past to allow the user to continue to another page on a personal google site (not school)

  • @joshuahamm8869
    @joshuahamm8869 4 ปีที่แล้ว

    Why does everyone always whisper in these tutorials?

  • @optimizedpatch
    @optimizedpatch 4 ปีที่แล้ว

    hey!
    is this available for the checkbox?

  • @ThiagoAlves-bs3cq
    @ThiagoAlves-bs3cq 5 ปีที่แล้ว

    Hello Jordan how would a cpf validator in a form

  • @jamesjakub4668
    @jamesjakub4668 6 ปีที่แล้ว

    Awesome tutorials, Jordan is there a way to contact you ?

  • @ManishKumar-ts2sp
    @ManishKumar-ts2sp 4 ปีที่แล้ว

    It is safe or not

  • @marcnaidu5804
    @marcnaidu5804 5 ปีที่แล้ว

    useful video thanks Jordan. I want to dynamically pull in question choices from a google sheet real time. any tips for that? To be clear, on form load, it will pull up all the possible field value choices I have on my google sheet. Possible?

    • @SKETCHTV33
      @SKETCHTV33 5 ปีที่แล้ว

      Yep possible, but do you still want to add to that list from the form?

    • @marcnaidu5804
      @marcnaidu5804 5 ปีที่แล้ว

      Andre Gomes not need to pull more field choice from the google form. The entire list of forked choice can come dynamically from the google sheet. How can this be done ?

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

      @@marcnaidu5804not sure if this helps, might be able to add a onForm open trigger instead of button in sheets th-cam.com/video/o3AL7ASI_cA/w-d-xo.html

    • @SKETCHTV33
      @SKETCHTV33 5 ปีที่แล้ว

      @@marcnaidu5804 oh also not sure if forked choices can be done. You can direct choices to a new question with options.

    • @marcnaidu5804
      @marcnaidu5804 5 ปีที่แล้ว

      Andre Gomes ok noted thanks ☀️

  • @admireargumentactivity
    @admireargumentactivity 6 ปีที่แล้ว

    Great tuts!