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

  • Profile Image
    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>

    Screenshot
  • Profile Image
    Mianala
    Answered on June 23, 2020 at 03: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.png

    3 - Click on Add Field

    1592895760add field.png

    3a - Select the Input Table widget

    1592895775select input table.png

    3b - Select the cell you want to use

    1592895800select cell.png

    3c - Click Done and Save

    1592895425form calculation input table.g

    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.

  • Profile Image
    Skateparktour
    Answered on June 23, 2020 at 01:05 PM

    Thanks so much! It works great :-)