Airtable Integration: Need to be able to map Input Table fields to Airtable

  • Skateparktour
    Asked on June 23, 2020 at 12:54 AM

    This feature is really important, how soon can I expect to be able to map Input Table fields to Airtable fields? I've selected "number fields" in my table format, so they are the same type, I just need to map R1,C1 to <Airtable fieldname>

    Jotform Thread 2405558 Screenshot
  • Mianala Jotform Support
    Replied on June 23, 2020 at 3:08 AM

    Hello @Skateparktour,

    You can already do this with conditions or with the Form Calculation widget:

    1 - Add the Input Table

    2 - Add the Form Calculation field

    1592895736form calculation Screenshot 10

    3 - Click on Add Field

    1592895760add field Screenshot 21

    3a - Select the Input Table widget

    1592895775select input table Screenshot 32

    3b - Select the cell you want to use

    1592895800select cell Screenshot 43

    3c - Click Done and Save

    1592895425form calculation input table Screenshot 54

    You can set the field to hidden.

    4 - Use the Form calculation field in the Airtable integration.


    Related guide:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    https://www.jotform.com/help/561-How-to-integrate-JotForm-with-Airtable

    Let us know if you need further assistance. We will be glad to help.

  • Skateparktour
    Replied on June 23, 2020 at 1:05 PM

    Thanks so much! It works great :-)