Form fields are greyed out in the Airtable integration

  • Profile Image
    Thompsonet
    Asked on February 22, 2020 at 10:13 PM

    When trying to map, most fields are greyed out and unelectable after the first few matches.



    This is a re-post of a comment on How to integrate Jotform with Airtable

  • Profile Image
    AshtonP
    Answered on February 23, 2020 at 12:32 AM

    Sorry for this inconvenience!

    Greyed out or Disable fields are those fields that don't match the field type of the target field you're trying to map. 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.

    I hope this clears your question. If not, please share with us the details of the fields that are grayed so that it would be helpful for us to assist you better.

    Also, if possible share us the screenshot of the Airtable fields so that we can investigate it easily.

    Regards.

  • Profile Image
    Thompsonet
    Answered on February 23, 2020 at 05:03 AM

    Thanks Ashton. I apologise, I reworded this question and posted as a new one instead of editing, but couldn't find a way to delete this one.

    It's strange because most fields are not greyed out until I get to match the second field (Surname). The next field (D.O.B.) is greyed out no matter how I format the date. I have matched it to "Date" type in AirTable and tried setting that field to various formats. I have even tried setting it to short text. Still no Joy.

    I notice that the Date picker fields do not grey out in the same way. Is there a way to convert the problematic Date field to a date picker without losing information?

    1582452156Screen Shot 2020-02-23 at 07.2

  • Profile Image
    Welvin
    Answered on February 23, 2020 at 09:14 AM

    Yes, Birth Date Picker widget will not work with Airtable's Date field. You have to use our regular Date Picker field for this work.

    To avoid loss of data, hide the field and add the Date Picker and edit your integration to map the new date field.

    Guide: -How-to-Hide-Form-Fields.