Airtable Integration: unable to match field, they are grayed out.

  • nseglencoe
    Asked on September 24, 2019 at 11:57 AM

    Hello I sent this request last week and have not gotten a response. 


    I am trying to link Airtable to a jotform and some fields are grayed out so I cannot map some fields. How do I ungray them out?


    Please call me at 312 978 7942 or email franco@northshoreexchange.org. Thanks

    Jotform Thread 1976542 Screenshot
  • David JotForm Support Manager
    Replied on September 24, 2019 at 12:16 PM

    They are grayed out, because that means that they are a different type of field. Please make sure that your Airtable field type is the same as your form field type.

    For example, if you will match a Dropdown form field, the Airtable field must be a Dropdown too, and must contain the same options.

    Let us know if you have more questions, we will be glad to assist you.

  • nseglencoe
    Replied on September 24, 2019 at 12:40 PM

    Thanks for the response. 

    I changed the field type in Airtable to accept 'Single Line of Text'. I then refreshed the connection in Jotform. I am unable to have 'employee name' which is text,be the input. It is still grayed out. 


    I did notice that in another form I have the employee name does populate in single line of text. Not sure why its inconsistent. Thanks. 

  • David JotForm Support Manager
    Replied on September 24, 2019 at 12:56 PM

    Hi, I have cloned your form, and noticed that your Employee Name form field is a Dropdown type:

    1569343788dropdown Screenshot 10

    So, a "Single Line of Text" won't match. Please make sure to change it to a "Dropdown", which in Airtable is called as "Single Select":

    Example: Click on your field, then click on Customize field type.

    1569344112customizetype Screenshot 21

    And also make sure to add the same options(Alyssa Heath, Carol Lind, Barbie Jeppe... Lorene Kilian) too.

    Let us know if you need more help.


  • nseglencoe
    Replied on September 24, 2019 at 1:42 PM

    Great Thanks, works!

  • nseglencoe
    Replied on September 24, 2019 at 4:59 PM

    Hello, for the form 

    https://form.jotform.com/92164999102160

    I want to map the data from field {input 23} to Airtable, its refers to page 3 on the form Item,Brand,Size, Color. I tried selecting 'long text' and 'Single line text' as the field type in Airtable though I am unable to map it from Jotform, still grayed out. Please advise what field type I should select in Airtable. 

    Thanks.  

  • John_Benson
    Replied on September 24, 2019 at 5:35 PM

    I moved your next issue to another thread. Please wait for my reply on this thread: https://www.jotform.com/answers/1977043.