Creating a record on Airtable from Jotform

  • Profile Image
    javierchan
    Asked on November 12, 2021 at 01: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_

    This is what I see on the Airtable integration tool:

    1636743001_618eb75914346_

    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

  • Profile Image
    Harvey_N
    Answered on November 12, 2021 at 03: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_

    I hope this helps.

    Let us know if you have any questions.

  • Profile Image
    javierchan
    Answered on November 12, 2021 at 03: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_

  • Profile Image
    Cecile_A
    Answered on November 12, 2021 at 06: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.png

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

    1636757278_618eef1eae0df_5.png

    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.