-
YoungsIncentiveAsked on April 8, 2018 at 4:21 PM
On this form
https://form.jotform.com/80865928016161
I'd love after they select the incentive, that the description could show up below it.
If I was in excel I'd use a vlookupm but not sure how to do it on JotForm
Page URL: https://form.jotform.com/80865928016161 -
AdrianReplied on April 8, 2018 at 4:42 PM
You can show or hide fields based on user's answers but I am not sure if this is what you are looking for.
Complete Guide: How to Show or Hide Fields Base on User's AnswerI can see that you are using the Auto Complete Widget on that field.
What description would you like to show after the selection is made?
Is the description unique for each option?I also suggest you check the Spreadsheet to Form Widget which can be used to prepopulate the form using the values you have on the spreadsheet.
Complete Guide: How to Use the Spreadsheet to Form Widget
-
YoungsIncentiveReplied on April 8, 2018 at 4:45 PM
Yes each selection as it's own description
This selection
On /Off , FOLEY FAMILY WINES , 1804-086 , Four Graces /Roth/Chalk Hill PODS , Runs4 - 5 , End Of Program , Roth, Chalk Hill Estate, Four Graces ,
Would bring up
Sales Representative PNW or Portfolio Specialist: $20.00 per menu mention or feature *3btl min* * 3 Btl MinFeature* 90 Day Buy Non-Buy. -
jonathanReplied on April 8, 2018 at 5:03 PM
As mentioned already, you can achieve this using the method described on the user guide
https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer
Since the options contains multiple texts/phrase I suggest you use the condition state "Contains with..." instead of "Equal to".
The "Contains" rule is more flexible when searching long descriptive texts or phrases from field's select options.
Let us know if you need further assistance doing this.
-
YoungsIncentiveReplied on April 8, 2018 at 5:05 PM
yea that's a lot more work because it's constantly changing.
I'll wait for widget to come out before I offer the descriptions on the form.
Thank you both!