Apps Script: Dynamic Forms Multiple Choice

Пікірлер: 32

  • @kevinnichols9836
    @kevinnichols98362 жыл бұрын

    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!

  • @geraldinebrigante4710
    @geraldinebrigante47104 жыл бұрын

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

  • @admireargumentactivity
    @admireargumentactivity6 жыл бұрын

    Great tuts!

  • @tinkershukla1725
    @tinkershukla17255 жыл бұрын

    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

  • @GerzaynFuentesKoltekmx
    @GerzaynFuentesKoltekmx3 жыл бұрын

    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.

  • @issamlotfi
    @issamlotfi5 жыл бұрын

    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 жыл бұрын

    I'd like to know that too!)

  • @MohamadSaat

    @MohamadSaat

    5 жыл бұрын

    🤔

  • @gohan794

    @gohan794

    4 жыл бұрын

    Did you guys found an answer?

  • @igainc.7633
    @igainc.76334 жыл бұрын

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

  • @omersolis3928
    @omersolis39285 жыл бұрын

    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!

  • @jamesjakub4668
    @jamesjakub46685 жыл бұрын

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

  • @hectortd
    @hectortd4 жыл бұрын

    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

  • @marcnaidu5804
    @marcnaidu58045 жыл бұрын

    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 жыл бұрын

    @@marcnaidu5804not sure if this helps, might be able to add a onForm open trigger instead of button in sheets kzread.info/dash/bejne/oWd1rpl6g6zFk6Q.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 ☀️

  • @riteshpandey5082
    @riteshpandey50824 жыл бұрын

    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
    @monicaraviraj85444 жыл бұрын

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

  • @ThiagoAlves-bs3cq
    @ThiagoAlves-bs3cq4 жыл бұрын

    Hello Jordan how would a cpf validator in a form

  • @realtorsmumbai
    @realtorsmumbai Жыл бұрын

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

  • @cedricchinable9626
    @cedricchinable96265 жыл бұрын

    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.

  • @bumpersmith
    @bumpersmith4 жыл бұрын

    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)

  • @optimizedpatch
    @optimizedpatch3 жыл бұрын

    hey! is this available for the checkbox?

  • @abdullahquhtani4247
    @abdullahquhtani42475 жыл бұрын

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

  • @joshuahamm8869
    @joshuahamm88694 жыл бұрын

    Why does everyone always whisper in these tutorials?

  • @ManishKumar-ts2sp
    @ManishKumar-ts2sp4 жыл бұрын

    It is safe or not