Airtable Integration Dynamic Dropdown Workaround

  • Profile Image
    agualandri
    Asked on August 13, 2019 at 03:04 PM

    I discovered that the new Airtable integration doesn't allow us to use the dynamic dropdown field type. Is there a workaround for this? I only really need the output of the field to be the thing selected on the last level of the dropdown options (eg violin, piano, guitar) single value.

  • Profile Image
    Nik_C
    Answered on August 13, 2019 at 03:30 PM

    Unfortunately, Airtable integration accepts only these fields:

    1565724572Screen Shot 2019-08-13 at 9.29

    And I believe that's a limitation from Airtable.

    Let us know if you have any further questions.

    Thank you!

  • Profile Image
    agualandri
    Answered on August 13, 2019 at 03:57 PM

    Right, what I was wanting to know is whether there's a way on the Jotform side to convert the field values from the dynamic dropdown into a single text field I can then use to map to Airtable. Any way to do this using calculated fields or something else?

  • Profile Image
    Nik_C
    Answered on August 13, 2019 at 04:07 PM

    You can try using Short text field and conditional logic:

    1565726677Screen Shot 2019-08-13 at 10.0

    Conditional logic:

    1565726710Screen Shot 2019-08-13 at 10.0

    You can check how it works here:

    https://form.jotform.com/92245850945969

    And that short text field you can integrate with Airtable.

    Hope it helps.

    Thank you!