Implementing conditional dropdown selections on calculation form

  • dbizzle
    Asked on August 17, 2016 at 1:22 PM

    Getting close to Form perfection.  Working thru last few tweaks.

    I have drop down Powerplant field with several engine selections.  Each selection has an associated cost.

    The next drop down field is Transmission.  Paddle shifter kit is an available option.

    My issue is that a Paddle shift kit cost different amounts for the Powerplant options 1-3 than it does for options 4-8.  Is there some logic that can be applied to change the Paddle shifter kit amount based on the previous Dropdown selection?

     

    We can have 2 Paddle Shifter dropdowns (one for VQE and one for GM powerplant options) if that helps.

     

    Appreciate the help.

     

  • Mike
    Replied on August 17, 2016 at 3:46 PM

    You might consider the following workaround.

    - Add a Form Calculation field and hide it.

    Implementing conditional dropdown selections on calculation form Image 1 Screenshot 60

    Implementing conditional dropdown selections on calculation form Image 2 Screenshot 71

    - Setup a calculation condition.

    Implementing conditional dropdown selections on calculation form Image 3 Screenshot 82

    If the Powerplant is equal to one of the GM options, populate an extra/deduct fee to created above field.

    Implementing conditional dropdown selections on calculation form Image 4 Screenshot 93

    - Include that field to your total calculation.

    Implementing conditional dropdown selections on calculation form Image 5 Screenshot 104

    If you need any further assistance, please let us know.

  • dbizzle
    Replied on August 17, 2016 at 4:23 PM

    Here is the challenge... the Paddle Shift is NOT mandatory to go with the engine.  So I can't automatically add the paddle shift kit to the engine.

    I understand I may not be able to do it, but what I want if if they select a VQE motor in the Powerplant dropdown, and then the Paddle Shift option in the Transmission dropdown, then the Total price goes up $1200.  If they select a GM motor in the Powerplant dropdown, and then the Paddle Shift option in the Transmission dropdown, then the Total price goes up $2200.  

     

  • Mike
    Replied on August 17, 2016 at 6:27 PM

    The 'Paddle Shift GM' value from above example will be 0 if condition does not match. You can try using 1200 calculation value as a standard one for selected Paddle Shift option.

    Implementing conditional dropdown selections on calculation form Image 1 Screenshot 30

    And add +1000 if condition match (Powerplant is set to one of the GM options).

    Implementing conditional dropdown selections on calculation form Image 2 Screenshot 41

    If I am missing something, please let me know.

  • dbizzle
    Replied on August 19, 2016 at 1:51 PM

    Got it working!  Had to use individual logic for each of the GM motors instead because they had to also select that they wanted the Paddle Shifter option as well as one of those motors.  But again, it's working.

    Implementing conditional dropdown selections on calculation form Image 1 Screenshot 20

     

    Appreciate the help.

  • Mike
    Replied on August 19, 2016 at 2:37 PM

    We are glad to hear that solution has been found.

    Thank you for using our service.