How to show one text in drop down option and another text in submission email?

  • xentive
    Asked on September 9, 2014 at 6:00 AM

    Dear

     

    Is it possible to hide some text in a drop down ?

     

    For example, I want that my customer see this in the drop down :

    - solution 1

    - solution 2

    - solution 3

     

    But in fact, we have :

    - A1. solution 1

    - A2. solution 2

    - A3. solution 3

     

    And in the send email at the end, I can see the "A1. solution x"

     

    Thank you for your answer.

     

    Best regards

    Isabelle

  • Ashwin JotForm Support
    Replied on September 9, 2014 at 9:55 AM

    Hello Isabelle,

    Unfortunately it is not possible to show one text in the drop down option but send another text in submission emails.

    But with a little workaround it is possible to achieve your requirement. Here are the steps you should follow:

    1. Add a drop down field in your form and add the options which you want to display to your users.

    2. Click on the gear icon of the dropdown field and then click on "Show Properties".

    3. In the "Calculation Values" property, add the values for every dropdown options including the balnk option which you want to show in submission emails. Please check the screenshot below:

    How to show one text in drop down option and another text in submission email? Image 1 Screenshot 40

    4. Add a "Form Calculation" widget in your form and add the formula to read the value of dropdown. You can also hide this widget if you do not want it to be displayed on form. Please check the screenshot below:

    How to show one text in drop down option and another text in submission email? Image 2 Screenshot 51

     

    Now when the drop down option is selected, it will display the corresponding value in the form calculation widget.

    Now you need to remove the "Dropdown" field name form the submission email template and add the form calculation value instead of that. Please check the screenshot below:

    How to show one text in drop down option and another text in submission email? Image 3 Screenshot 62

     

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • xentive
    Replied on September 12, 2014 at 4:50 AM

    Dear,

     

    Thank you very much, it is a very good workaround.

     

    Unfortunately, I can't use it like that because :

    - I have 4 drop dows : the main first, and the other

    - According to the 3 values of the first drop down, the other are hiding or showing

    - in the calculation field, so, I have put the value of the 2nd, 3rd and 4th drop down ; and like the user can select only the value of the 2nd, 3rd or 4th drop down (because only one of them is showing at the same time), it works.

     

    I have no problem to do that, in the calculation field, like I have put the value of the 3 drop down. But if the user select a value on the 2nd drop down, and after, he select another value in the main drop down, and select a value of the 3rd drop down, I have the two values in my calculation field, and it is false because I have to have only the value of the 3rd dropdown.

     

    I don't find a workaround about that, I don't know if you have an idea.

     

    Regards

     

    Isabelle

  • Ashwin JotForm Support
    Replied on September 12, 2014 at 7:37 AM

    Hello Isabelle,

    I did test it and I was able to replicate the exact same behavior. But it is still possible to achieve your requirement. Here are the steps you need to follow:

    1. Step #1, #2 and #3 needs to be followed as mentioned in my earlier answer.

    2. You need to discard the step number 4 and follow from here. Add a "Form Calculation" widget for every conditional drop down field you have and you can hide all of them.

    3. Add one "Text box" field in your form. Please check the screenshot below:

    How to show one text in drop down option and another text in submission email? Image 1 Screenshot 50

     

    4. In the form calculation widget, set the formula to just read the value of the respective dropdown value. Please check the screenshot below:

    How to show one text in drop down option and another text in submission email? Image 2 Screenshot 61

    5. For every option of the main drop down field, add one condition to read the value of respective "Form Calculation" widget and update the form field value of the text box field. The following guide should help you on how to update a form field value :  https://www.jotform.com/help/286-How-to-Populate-Field-with-a-Value-from-another-Field  Please check the screenshot below on how to add this condition:

    How to show one text in drop down option and another text in submission email? Image 3 Screenshot 72

    The form should behalf normally and it should only display the value of selected drop down. Please check the screenshot of a demo how the form should work:  

    How to show one text in drop down option and another text in submission email? Image 4 Screenshot 83

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • xentive
    Replied on September 12, 2014 at 9:13 AM

    Yes, it seems working !!!!

     

    It is a little bit complex, but it works ! Thank you very much for your rapidity, for the explanations and print screens !!!

     

    Have a nice week end.

     

    Regards

     

    Isabelle

  • Carina
    Replied on September 12, 2014 at 10:41 AM

    On behalf of my colleague you are most welcome.

    If you need further support please let us know, as we are here to help.