Submitting Different Values for Multi Select Field

  • musickids
    Asked on August 21, 2019 at 4:42 PM

    Is there a way to use different values for the form submission for multi select fields than the options displayed on the form? We have options that are more lengthy than what we want to pass through the form to our Airtable integration fields.

  • KrisLei Jotform Support
    Replied on August 21, 2019 at 7:07 PM

    Hi,

    I apologize for the confusion. Are you trying to use the Multiple Selection widget and let you display more options? Can you elaborate more on your requirements for us to further assist you?

    We will wait for your response.


  • musickids
    Replied on August 22, 2019 at 12:35 PM

    We’re using a regular field multi select not widget. We are trying to display certain text on the form side client viewable text options but use a different set of shorter length text options internally as the values that get submitted through the form that then pushed through the form integration to our Airtable base. For example:

     
     
    What you see on the form for the checkbox options:
     
    3:00-3:30PM
    4:00-4:30PM
    4:30-5:00PM
     
    The form values that correspond to these that are passed to Airtable:
     
    3:00
    4:00
    4:30
  • musickids
    Replied on August 23, 2019 at 11:27 AM

    Urgently looking for an answer here. Thanks!

  • KrisLei Jotform Support
    Replied on August 23, 2019 at 1:41 PM

    Hi,

    I apologize for the late response. I made a demo form, unfortunately, it seems that multiple selections of options at a time seem impossible with a corresponding value. 

    I used a Multiple Choice Widget and create conditional logic to match the "Select here" field's value with the "Corresponding Value" field.

    For your reference: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic


    1566581761MultipleSelectwidget Screenshot 10

    Here's the link for the demo form: https://form.jotform.com/92327210127952

    So, I think the "Corresponding Value" field will be passed on your Airtable. Also, try to use a Single Choice Widget to avoid confusion with your users, and not to let them select multiple options. 

    I hope this helps. 

  • KrisLei Jotform Support
    Replied on August 23, 2019 at 2:24 PM

    I received input from one of my colleagues, Joana suggests that it can be done through CSS codes too, which is the easiest way and you can select multiple options. The corresponding values will be sent to your submissions.

    She injected these following codes:

    label#label_input_3_0:after {

        content : "-3:30PM";

    }


    label#label_input_3_1:after {

        content : "-4:30PM";

    }


    label#label_input_3_2:after {

        content : "-5:00PM";

    }

    Here's Joana's demo form: https://form.jotform.com/92344934855972

    For your reference: https://www.jotform.com/help/117-How-to-Inject-Custom-CSS-Codes