Airtable Zapier integration not uploading multiple files

  • Profile Image
    Speakizi
    Asked on May 28, 2017 at 09:39 AM

    Hi,

    I've connected Jotform to Airtable using Zapier. Everything works great, the only problem is that I'm using the File Upload element with Multiple Files turned on, and only one file is uploaded to Airtable (even if there are multiple files uploaded). Any ideas?

  • Profile Image
    Kiran
    Answered on May 28, 2017 at 11:25 AM

    UPDATE (April 5, 2019): Direct integration with Airtable is available now. 

    1. Open the Form Builder.

    2. Find the Airtable integration under the Settings.

    1554465247Screen Shot 2019-04-05 at 10.3

    3. Paste your API Key and click on the "Authenticate" button. (To generate API Key, you should open this page and click on the "Generate API Key" button)

    1554465237Screen Shot 2019-04-05 at 10.4

    4. Select which of your bases you would like to connect to, then select one of the tables within the base.

    1554465227Screen Shot 2019-04-05 at 10.4

    5. Map the fields on the table with form fields and click on the "Save" button. 

    1554465218Screen Shot 2019-04-05 at 10.4

    6. You can create multiple connections to various Airtable bases and tables with the same integration.

    1554465204Screen Shot 2019-04-05 at 10.4

    The submissions will be sent to Airtable every time your form is submitted.

    Additionally, you can look at this guide to learn how to integrate JotForm with Airtable: https://www.jotform.com/help/561-How-to-integrate-JotForm-with-Airtable

     

    Could you provide us with the screenshot of the field mapping in the Zapier for the upload fields so that we can take a look? This will help us in replicating the issue at our end and provide you with necessary assistance

    We will wait for your response. Thank you! 

  • Profile Image
    Kiran
    Answered on May 28, 2017 at 03:35 PM

    I have tried creating a trail account with Airtable and see that there are different bases available to choose. Please let us know which base you are trying to configure with Zapier to check it.

    Thanks!

  • Profile Image
    Speakizi
    Answered on May 29, 2017 at 08:58 AM

    Hi,

    I'm using a base I created in Airtable, not one of the default ones. I added an attachment column to the base, and I map that column to the Image Upload field in Jotform.

     

  • Profile Image
    Helen
    Answered on May 29, 2017 at 10:24 AM

    Hello,

    Thank you for contacting us.

    I have created a test form and tried to replicate the issue on my side. I have made an integration with Airtable via Zapier. 

    I could replicate the same issue with you. I have uploaded multiple attachments but only one file is shown on the Airtable. As you can see below:

    I have escalated this issue to our developers. They will research the problem and if we have any update, we will inform you as soon as possible.

    This issue may relate with Zapier. Maybe, Zapier could not send to data to Airtable. 

    Also, you can contact to Zapier support via this link: https://zapier.com/app/contact-us

    I hope it helps. If you have any other questions or issue, please do not hesitate to contact us.

  • Profile Image
    Speakizi
    Answered on May 29, 2017 at 10:29 AM

    Thanks, I appreciate your help!

  • Profile Image
    NeilVicente
    Answered on June 02, 2017 at 01:34 PM

    Hi there,

    We send all file URLs to Zapier for every submission; it is up to Zapier to process this information and relay it to AirTable.

    It is possible that the format of the URLs that we send to Zapier might not match their preferred format, so we have sent an email to Zapier to have it clarified.

    We will let you know if and when Zapier responds and we find a solution to this issue.

    In the meantime, the workaround is to add more columns for files on your AirTable collection and map them to multiple single upload fields separately. 

    Cheers!

  • Profile Image
    Speakizi
    Answered on June 04, 2017 at 08:57 AM

    Neil - thanks for your reply! I'm not sure I understand how to implement your workaround - let's say I add another column for photo #2, how can I map the 2nd photo URL specifically (instead of having the first photo appear twice)?

  • Profile Image
    NeilVicente
    Answered on June 04, 2017 at 10:08 AM

    Hi there,

    Sorry for not making it clear.

    The workaround I proposed requires the exiting upload field on your form to be converted to a 'single' upload field and adding more 'single' upload fields and mapping them to your AirTable columns.

    Hope this helps.

  • Profile Image
    NeilVicente
    Answered on June 05, 2017 at 04:36 PM

    Hi again,

    We have received a response from Zapier. 

    The solution to this problem is to add an intermediary action for your Zap called Formatter which will change the new line characters to a comma.

    Refer to the screenshot below for guidance.

     

     

    Then, map this formatted value to the Attachments column on your AirTable.

     

     

    Hope this helps.

  • Profile Image
    Speakizi
    Answered on June 06, 2017 at 08:16 AM

    Thank you so much! I'll try it, looks like it should work :)

  • Profile Image
    nelly
    Answered on April 05, 2019 at 07:56 AM

    UPDATE: Direct integration with Airtable is available now. 

    1. Open the Form Builder.

    2. Find the Airtable integration under the Settings.

    1554465374Screen Shot 2019-04-05 at 10.3

    3. Paste your API Key and click on the "Authenticate" button. (To generate API Key, you should open this page and click on the "Generate API Key" button)

    1554465361Screen Shot 2019-04-05 at 10.4

    4. Select which of your bases you would like to connect to, then select one of the tables within the base.

    1554465344Screen Shot 2019-04-05 at 10.4

    5. Map the fields on the table with form fields and click on the "Save" button. 

    1554465334Screen Shot 2019-04-05 at 10.4

    6. You can create multiple connections to various Airtable bases and tables with the same integration.

    1554465323Screen Shot 2019-04-05 at 10.4

    The submissions will be sent to Airtable every time your form is submitted.

    Additionally, you can look at this guide to learn how to integrate JotForm with Airtable: https://www.jotform.com/help/561-How-to-integrate-JotForm-with-Airtable