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

  • Profile Image
    bellevuefineart
    Asked on August 05, 2020 at 01: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?


  • Profile Image
    Basil_A
    Answered on August 05, 2020 at 04:27 PM

    Hi,

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

    1596659189JH9hlmp0nD.png

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

    Please let us know if you require any further assistance.

  • Profile Image
    bellevuefineart
    Answered on August 06, 2020 at 01:42 PM

    Brilliant! Thank you. That worked great. 

  • Profile Image
    bellevuefineart
    Answered on August 06, 2020 at 08: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

  • Profile Image
    Vanessa_T
    Answered on August 06, 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.

  • Profile Image
    bellevuefineart
    Answered on August 06, 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.