Submitting Different Values for Multi Select Field

  • Profile Image
    mkprogram
    Asked on August 21, 2019 at 04: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.

  • Profile Image
    KrisLei
    Answered on August 21, 2019 at 07: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.


  • Profile Image
    mkprogram
    Answered 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
  • Profile Image
    mkprogram
    Answered on August 23, 2019 at 11:27 AM

    Urgently looking for an answer here. Thanks!

  • Profile Image
    KrisLei
    Answered on August 23, 2019 at 01: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.gif

    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. 

  • Profile Image
    KrisLei
    Answered on August 23, 2019 at 02: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