Mapping the Matrix Dynamique widget to Airtable integration

  • Profile Image
    nseglencoe
    Asked on September 24, 2019 at 05:34 PM

    Hello, for the form 

    https://form.jotform.com/92164999102160

    I want to map the data from field {input 23} to Airtable, its refers to page 3 on the form Item,Brand,Size, Color. I tried selecting 'long text' and 'Single line text' as the field type in Airtable though I am unable to map it from Jotform, still grayed out. Please advise what field type I should select in Airtable. 

    Thanks.  

  • Profile Image
    John_Benson
    Answered on September 24, 2019 at 08:39 PM

    Unfortunately, it is not possible to map the widget directly to Airtable.

    However, you can use the Update/Calculate Field condition to pass the value of the Matrix Dynamique widget to a Long Text Entry field or to Short Text Entry field.

    Here's how it looks like:

    1569371148passwidgeval.gif

    After this, try mapping the Long Text Entry or Short Text Entry to Airtable integration.

    Here's a demo form: https://form.jotform.com/92667959330975

    Here's a guide on How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic.

    If you have any questions, let us know.

  • Profile Image
    Carol Mason
    Answered on October 08, 2019 at 07:36 PM

    I have a similar issue - trying to map a PayPal widget choice into an AirTable field. 

    E.g. the user chooses 'deposit' as their payment option. 

    I have it set up as above to update a hidden text field with the PayPal choice (e.g. 'Deposit') but my AirTable field is a single choice field. I can't map the JF text field to the AT single select field.

    There doesn't seem to be a way to have the hidden field in JF be a single choice field that can be updated based on the PayPal widget selection.  

    Is there any way to do this?

  • Profile Image
    Kevin_G
    Answered on October 08, 2019 at 08:14 PM

    In order to assist you better I have moved your question to another thread, we will assist you as soon as possible here: https://www.jotform.com/answers/1993962 

    Thanks.