How to set value to each item in the Dropdown list

  • Breathable
    Asked on April 22, 2017 at 6:22 AM

    I also have a dropdown that I want to set VALUE/TEXT for each item in this dropdown... Is there a way to import around 70 items like that?

    This means that if the users selected item37 (that's the text in the dropdown), I'd like to submit the VALUE of this text to the backend... Appreciate your prompt feedback on this.

  • jonathan
    Replied on April 22, 2017 at 6:26 AM

    The Dropdown list field have option for Calculation value.

    Check the user guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    If I understand correctly the value in the Surveying option is the value that you need to get pass on to the backend system.

    Let us know if there's more we can help you with.

    Thanks.

     

  • Breathable
    Replied on April 22, 2017 at 2:34 PM

    Hi Jonathan,

    I already tried this but it's not working... I have a dropdown with 3 items:

    Text1, Text2, Text3

    and their corresponding values (that I put in the Surveying options as you mentioned above)

    Val1, Val2, Val3

     

    I'm expecting to get Val1 or Val2 or Val3, but I'm getting one of the Text#s instead :(

    My integration is with Salesforce.

  • jonathan
    Replied on April 22, 2017 at 4:18 PM

    I think you were missing a part in the assigning of calculation value process.

    You cannot capture the calculation value if you will only use the Dropdown list only. You need to assign first the value to a separate container (field)

    Example, you can use the Textbox field to capture Value1, Value2, Value3 from the Dropdown when using the condition logic Insert/Update Field value.

    See images below for guide:

    How to set value to each item in the Dropdown list Image 1 Screenshot 40

     

    Assign value condition...

    How to set value to each item in the Dropdown list Image 2 Screenshot 51

    How to set value to each item in the Dropdown list Image 3 Screenshot 62

    You can hide the Textbox field container so that it will not be seen on the form.

    And in your Salesforce field mapping option, you can use the Textbox field value instead of the Dropdown text.

    I hope this help. Let us know if you are still not able to make it work.

     

     

  • Breathable
    Replied on April 25, 2017 at 10:59 AM

    Nice Jonathan, thanks a lot! Looks like it's working :) I'll get back to you if I stumble again.