Apps Script: Dynamic Forms Multiple Choice

Поділитися
Вставка
  • Опубліковано 26 сер 2024

КОМЕНТАРІ • 32

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

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

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

  • @geraldinebrigante4710
    @geraldinebrigante4710 4 роки тому

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

  • @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 5 років тому +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

  • @realtorsmumbai
    @realtorsmumbai Рік тому

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

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

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

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

  • @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 4 роки тому

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

    • @marcnaidu5804
      @marcnaidu5804 4 роки тому

      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 4 роки тому +1

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

    • @SKETCHTV33
      @SKETCHTV33 4 роки тому

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

    • @marcnaidu5804
      @marcnaidu5804 4 роки тому

      Andre Gomes ok noted thanks ☀️

  • @admireargumentactivity
    @admireargumentactivity 6 років тому

    Great tuts!

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

  • @optimizedpatch
    @optimizedpatch 3 роки тому

    hey!
    is this available for the checkbox?

  • @joshuahamm8869
    @joshuahamm8869 4 роки тому

    Why does everyone always whisper in these tutorials?

  • @abdullahquhtani4247
    @abdullahquhtani4247 5 років тому

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

  • @ManishKumar-ts2sp
    @ManishKumar-ts2sp 4 роки тому

    It is safe or not