Some field can't be integrated with Airtable

  • Profile Image
    sgtech1207
    Asked on June 15, 2020 at 05:29 AM

    Hi, I'm trying to integrate my jotforms fields to airtable but some can't be linked. Eg. I'm using Get URL widget and this can't linked to airtable although a url field column in airtable already setup.

  • Profile Image
    gerardw
    Answered on June 15, 2020 at 07:24 AM

    Hello,

    The field types should match on Jotform and Airtable. There is no widget field type on Airtable and you will not be able to transfer the widget data.

    What you can do is add a Short text field on the form and hide it. Then pass on the value from Get Form Page URL widget to this Short text field using conditions.

    Example:

    15922200981506_16.png

    Related Guide for reference: How-to-Pass-Field-Value-to-Another-Field 

    On Airtable, you can set up the corresponding field type as Single Line text:

    15922202211506_17.png

    You can then map the fields via the integration app.

    Do try and let us know the update.

  • Profile Image
    sgtech1207
    Answered on June 15, 2020 at 08:28 AM
    Hi,
    Thank you, this is a very helpful solution.
    With regards,
    SANDHY FRILY
    ...
  • Profile Image
    sgtech1207
    Answered on June 16, 2020 at 11:28 AM
    Hi,
    For Product Widget, is there any method to have the content exported to
    airtable?
    ...
  • Profile Image
    Kiran
    Answered on June 16, 2020 at 01:56 PM

    Are you referring to the payment field on your form? If so, unfortunately it is not possible to pass the payment field to another field to map with Airtable. This is due to the payment field is a composite field and the final value can only be passed.

    If you are referring to a different field, please let us know. We will be happy to take a look again. 

  • Profile Image
    sgtech1207
    Answered on June 16, 2020 at 02:28 PM
    Noted.
    I did try to extract some fields from widget, using the previous explained
    method but still failed.
    Eg. IP Address i can't have that extracted to airtable. Same case with my
    order id field & a paragraph field.
    With regards,
    SANDHY FRILY
    ...
  • Profile Image
    VincentJay
    Answered on June 16, 2020 at 06:14 PM

    Unfortunately, only basic fields can be transferred or map to AirTable. You cannot pass the text inside the Paragraph field. 

    As for the IP address - Get Visitor widget, it is passing the complete data of the widget.

    1592345508fsfxf.png

    I recommend using the Basic fields only to pass data to the AirTable.