How to make a keyword conditional rule for a dropdown field?

  • sjakubik
    Asked on October 8, 2018 at 4:52 PM

    How can I set conditions by keyword? What I'm trying to do is expand a set of questions based on a certain keyword present in a dropdown selection. This was easy with the old editing program but I don't see it now. Thanks! 

     

    Susanna

    Ridge Point High School

  • Jed_C
    Replied on October 8, 2018 at 9:19 PM

    What you can do is pass the value selected from the Dropdown to a Short Text Entry field via condition. Now use the condition to scan for the keyword in the short text entry field. To do that, use the "Contains" statement.

    ex.

    1539047799contain statement Screenshot 10

    What I used was the Show and Hide then Update/Calculate field condition.

    1539047896The Easiest Online Form Builde Screenshot 21

    I hope this helps. Let us know if you have any questions or if you need further assistance. 

  • sjakubik
    Replied on October 9, 2018 at 8:43 AM
    I cannot use short text entry. These are orders that are already placed and they won’t find their name in the drop down until they pay. What else can we do? Thanks!
    Susanna S. Jakubik
    Ridge Point High School Journalism
    theAthlon yearbook sponsor
    RPHS Journalism Website
    Request an announcement by clicking here!
    Click here to watch ProwlerTV
    susanna.jakubik@fortbendisd.com
    ...
  • David JotForm Support
    Replied on October 9, 2018 at 11:15 AM

    Apologies, I am not certain I follow.  The condition would work the same as any other condition, it would simply have one extra intermediary step where the value selected in the drop down field is passed to a short text entry field.  Then the short text entry field is used for any conditions that would have been performed using the drop down (If short text entry field contains key word do x).  If the key word isn't present in the drop down field, it wouldn't be possible to use conditions associated with the key word.

  • sjakubik
    Replied on October 9, 2018 at 12:43 PM
    Because I don’t trust people with short text entry. They are purchasing an ad on another form and then uploading it on this one. They need to select the ad that they purchased (which is something I put in the dropdown) based on how much money they spent. I don’t want them to be able to say they purchased a larger ad than they actually did.
    Susanna S. Jakubik
    Ridge Point High School Journalism
    theAthlon yearbook sponsor
    RPHS Journalism Website
    Request an announcement by clicking here!
    Click here to watch ProwlerTV
    susanna.jakubik@fortbendisd.com
    ...
  • David JotForm Support
    Replied on October 9, 2018 at 12:51 PM

    The users wouldn't be using the short text entry field.  They would make their selection in the drop down field which would then populate the short text entry field automatically.  You could even hide the short text entry field so the users do not even see it.  It is just easier to base conditions off a short text entry field than it is a drop down.

  • sjakubik
    Replied on October 9, 2018 at 6:39 PM

     I see - I was looking at your responses via email and the video was not coming through. How can I control your video (pause, stop, etc.)? 

  • sjakubik
    Replied on October 9, 2018 at 6:43 PM
    I guess I don’t see the Contains statement at all. Help?
    Susanna S. Jakubik
    Ridge Point High School Journalism
    theAthlon yearbook sponsor
    RPHS Journalism Website
    Request an announcement by clicking here!
    Click here to watch ProwlerTV
    susanna.jakubik@fortbendisd.com
    ...
  • Jed_C
    Replied on October 9, 2018 at 8:10 PM

    First, you'll need to add a short text entry field. Then second, you'll need to apply the show and hide conditional rule https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer.

    The "Contains" condition won't appear for Dropdown, so you will need to select the short text entry field.

    ex.

    1539130203The Easiest Online Form Builde Screenshot 10

    Let us know if you have any questions or if you need further assistance. 

  • sjakubik
    Replied on October 22, 2018 at 10:58 AM

    I'm almost there! I have the field to autofill with the value in the drop-down and have set up two conditions to show multiple fields based on what's in the "ad to be hidden" field, but it's not working. I know I've done something wrong - help is appreciated. Thanks!

    The form is here: https://form.jotform.com/82723727764163

  • David JotForm Support
    Replied on October 22, 2018 at 12:12 PM

    In your conditions, the value that it is looking for is "Shoutout", but in your field value, the text is "shoutout" with a lowercase s.  Try changing shoutout to a lower case s so the text in the field matches the text in your conditions. 

  • sjakubik
    Replied on October 22, 2018 at 12:22 PM

    I tried that, but the "Full Page" header and fields are still visible. Did I do something else incorrectly? 


  • David JotForm Support
    Replied on October 22, 2018 at 1:30 PM

    Those fields will be shown any time other than when the field contains "shoutout", including when the field is empty:

    1540229194Capture Screenshot 10

    Once the field contains "shoutout", those fields will be hidden and the other set shown:

    1540229230Capture1 Screenshot 21

    If you want the all the field to be hidden until a selection is made, set up a condition to hide both sets of fields when "Ad to be hidden:" is empty.