How can I map Input Table field to Airtable?

  • Profile Image
    lojul
    Asked on March 05, 2020 at 12:10 AM

    I have a input table with columns and rows, possible to map into Airtable?

  • Profile Image
    Jed_C
    Answered on March 05, 2020 at 08:11 AM

    There's not input table field type in Airtable so you can't directly create an input table field in your Airtable account.

    What you can do is split the data in Jotform and send those data to a short text entry field then map the short text entry field into your Airtable field.

    ex.

    1583413524pass_answer.gif

    1583413632The Easiest Online Form Builde

    1583413676Jotform Sample_ Table 3 - Airt

    Here's a sample output:

    1583413799airtable_sample.gif

    Here's a sample of the condition I've used to pass the value from input table to short text entry field.

    1583413853The Easiest Online Form Builde

    I hope that helps. Let us know if you have any questions or if you need further assistance. 

  • Profile Image
    lojul
    Answered on March 05, 2020 at 08:18 AM

    thanks. if my input table has multiple columns and rows of text fields, can I separate them or I can only put the array into a long text field?

  • Profile Image
    Kiran
    Answered on March 05, 2020 at 10:51 AM

    It is required to setup a condition to read an individual field value from the input table field. So, in order to send each individual field to an Airtable column, it is required to setup a condition for each individual field in the input table field to a separate field that will map in the integration. 

    If you want to send all the input table data to one long text field, you may setup only one condition and select all the input table fields to pass to long text field.

    Hope this information helps!