How can I change the dropdown field value based on conditions?

  • bellevuefineart
    Asked on August 5, 2020 at 1:29 PM

    I've used the conditional statement a lot, but I can't figure this out, or if it's achievable. 

    What I want to do is this. If the dropdown menu of paper types = Canvas Matte, or Canvas metallic, then the field margin = 2". In other words, if canvas is chosen, I want to force the dropdown field for margin to = 2". 

    Can that be done?


    Jotform Thread 2493636 Screenshot
  • Basil JotForm Support
    Replied on August 5, 2020 at 4:27 PM

    Hi,

    You can use the "Update/Calculate Field" option and add the following condition:

    1596659189JH9hlmp0nD Screenshot 10

    I have tested it on a clone of your form and it is working.

    Please let us know if you require any further assistance.

  • bellevuefineart
    Replied on August 6, 2020 at 1:42 PM

    Brilliant! Thank you. That worked great. 

  • bellevuefineart
    Replied on August 6, 2020 at 8:05 PM

    OK, this worked brilliantly, but it has an unintended side effect. When you choose anything other than CANVAS - STANDARD MATTE from the dropdown menu, the "margin" drop down menu resets itself to be blank. 

    Is there something I can add to this condition to stop that from happening. 

    Now with this brilliant fix, I select size, and margin, then paper type, and the margin gets reset. 

    I'm so close...... 


    Scott

  • Vanessa_T
    Replied on August 6, 2020 at 10:43 PM

    Yes, that is the intended behavior, if the condition is not met, it clears the value.

    I suggest you add the Margin field after the Paper type so if it's not Canvas, nothing will then be cleared on the Margin field.

  • bellevuefineart
    Replied on August 6, 2020 at 11:45 PM

    That's what I ended up doing. Thanks Vanessa. I'm surprised at how much logic is in this form now! 

    thanks for the answers.