Apps Script: Dynamic Forms Multiple Choice

[@kevinnichols9836]

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]

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.

[@geraldinebrigante4710]

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

[@omersolis3928]

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]

Any solutions? Regards!

[@igainc.7633]

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

[@tinkershukla1725]

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

[@issamlotfi]

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]

I'd like to know that too!)

[@MohamadSaat]

🤔

[@gohan794]

Did you guys found an answer?

[@riteshpandey5082]

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.

[@realtorsmumbai]

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

[@jamesjakub4668]

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

[@ThiagoAlves-bs3cq]

Hello Jordan how would a cpf validator in a form

[@monicaraviraj8544]

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

[@marcnaidu5804]

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]

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

[@marcnaidu5804]

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]

@@marcnaidu5804not sure if this helps, might be able to add a onForm open trigger instead of button in sheets kzbin.info/www/bejne/pWSkfWp3iK6SmaM

[@SKETCHTV33]

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

[@marcnaidu5804]

Andre Gomes ok noted thanks ☀️

[@bumpersmith]

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)

[@hectortd]

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

[@optimizedpatch]

hey! is this available for the checkbox?

[@cedricchinable9626]

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

[@JordanRhea]

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

[@admireargumentactivity]

Great tuts!

[@joshuahamm8869]

Why does everyone always whisper in these tutorials?

[@abdullahquhtani4247]

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

[@ManishKumar-ts2sp]

It is safe or not