Creating a record on Airtable from Jotform

  • javierchan
    Asked on November 12, 2021 at 1:52 PM

    Hi!

    I created a form in Jotform and I it to create a record on Airtable when submitted.

    As of now that form has 3 Short Text fields, 1 Multiple Choice field and 3 drop downs (from On2Air).

    When I fill and submit the form, only the 3 Short Text fields get send to Airtable.

    This is what I get on my email when I submit the form:

    1636742938 618eb71a8552b  Screenshot 10

    This is what I see on the Airtable integration tool:

    1636743001 618eb75914346  Screenshot 21

    As you can see, I cannot match the Activity Format (Multiple Choice) nor the Subject, Domain and Skill (all are Single Line Text).

    How can I fix this?

    Thanks,

    Javier

  • Harvey JotForm Support
    Replied on November 12, 2021 at 3:24 PM

    Hi there,

    You would need to change the format of each table that you have set on your Airfield. For example, for the Activity format, you would need to change the field type to 'Mutiple Select'. This should enable you to be able to match the tables from your form.

    1636748290 618ecc0270a9e  Screenshot 10

    I hope this helps.

    Let us know if you have any questions.

  • javierchan
    Replied on November 12, 2021 at 3:58 PM

    Thanks for your reply.

    The format for that particular field already is "Multiple select". What else could be happening that is not allowing me to match it?

    Additionally, what about the other 3 fields: Subject, Domain and Skill? What type should those be?

    The is how they look on the Jotform table:

    1636750719 618ed57fafad0  Screenshot 10

  • Cecile JotForm Support
    Replied on November 12, 2021 at 6:05 PM

    Hello Javier,

    I cloned your form to test. As you can see in my table, the Activity Format is set as Multiple Select.

    1636757277 618eef1dc52e7 6 Screenshot 10

    Upon testing, it seems to have worked on my end.

    1636757278 618eef1eae0df 5 Screenshot 21

    I have cleared your form caches. Can you please try to reintegrate your form with Airtable?

    As for your second query, let me address it via the ticket below.

    https://www.jotform.com/answers/3507849

    Looking forward to your reply.