Airtable Integration Dynamic Dropdown Workaround

  • agualandri
    Asked on August 13, 2019 at 3: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.

  • Nik_C
    Replied on August 13, 2019 at 3:30 PM

    Unfortunately, Airtable integration accepts only these fields:

    1565724572Screen Shot 2019 08 13 at 9 Screenshot 10

    And I believe that's a limitation from Airtable.

    Let us know if you have any further questions.

    Thank you!

  • agualandri
    Replied on August 13, 2019 at 3: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?

  • Nik_C
    Replied on August 13, 2019 at 4:07 PM

    You can try using Short text field and conditional logic:

    1565726677Screen Shot 2019 08 13 at 10 Screenshot 10

    Conditional logic:

    1565726710Screen Shot 2019 08 13 at 10 Screenshot 21

    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!