- SpeakiziAsked on May 28, 2017 at 09:39 AM
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?
- JotForm SupportKiranAnswered on May 28, 2017 at 11:25 AM
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!
- JotForm SupportKiranAnswered 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.
- SpeakiziAnswered on May 29, 2017 at 08:58 AM
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.
- JotForm DeveloperHelenAnswered on May 29, 2017 at 10:24 AM
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.
- SpeakiziAnswered on May 29, 2017 at 10:29 AM
Thanks, I appreciate your help!
- JotForm SupportNeilVicenteAnswered on June 02, 2017 at 01:34 PM
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.
- SpeakiziAnswered 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)?
- JotForm SupportNeilVicenteAnswered on June 04, 2017 at 10:08 AM
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.
- JotForm SupportNeilVicenteAnswered on June 05, 2017 at 04:36 PM
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.
- SpeakiziAnswered on June 06, 2017 at 08:16 AM
Thank you so much! I'll try it, looks like it should work :)