I am creating a scenario in MAKE to add a new record to my student database once a student is marked as enrolled in my admission database. Everything works well, but I am facing one issue. I am able to use the HTTP Module and “Upload to Google Drive” Module to add the student photo correctly to the student database. However, I have two other file fields in the admission database that need to be synced, and they contain multiple files. How can I ensure all those files are added without missing any to the student’s database?
Solved
Upload Multiple files in Airtable
+12Best answer by ScottWorld
I’m not sure I understand your question, but I give a training on how to work with Airtable attachment fields in Make in this Airtable podcast episode:
https://www.youtube.com/watch?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1&v=sKPyG0HZCYY
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+28May I know what issues you faced using an Iterator for that? I think I may not understand what you're trying to do though!
+12TheTimeSavingCo wrote:
May I know what issues you faced using an Iterator for that? I think I may not understand what you're trying to do though!
Great, you gave me a first element of answer, I was selecting in the Iterator module the URL when I needed to select the complete field Attachment. So nopw the iterator works well I am able to uplaod the x number of files to my google drive.
So for the second step:
When I have one and only one attachment, the process is this one (below for the student photo, only one photo is attached)
This trick allows me to avoid issues with the Google Drive quota. So now I am able to create a string. So Now I am ablae to process and get a string that looks like this as an output before updating Airtable :
In this case, I have two pictures in the field attachments.
In Airtable it does this:
The field remains empty.
when I am testing the airtable update module with two images hosted on imgur with png and jpeg extension:
https://i.imgur.com/kJmYoqJ.png,https://i.imgur.com/H5D2iMj.jpeg
It only keeps the first image listed. How can I ensure that the two files are pushed to Airtable 2?
Perhaps I need to use a completely different strategy, or maybe there is a simple trick.
+33I’m not sure I understand your question, but I give a training on how to work with Airtable attachment fields in Make in this Airtable podcast episode:
https://www.youtube.com/watch?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1&v=sKPyG0HZCYY
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+12ScottWorld wrote:
I’m not sure I understand your question, but I give a training on how to work with Airtable attachment fields in Make in this Airtable podcast episode:
https://www.youtube.com/watch?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1&v=sKPyG0HZCYY
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
This has been very helpful, I was finally able to add multiple files thanks to your video.
1 person likes this
+28Pascal_Vallet wrote:
Great, you gave me a first element of answer, I was selecting in the Iterator module the URL when I needed to select the complete field Attachment. So nopw the iterator works well I am able to uplaod the x number of files to my google drive.
So for the second step:
When I have one and only one attachment, the process is this one (below for the student photo, only one photo is attached)
This trick allows me to avoid issues with the Google Drive quota. So now I am able to create a string. So Now I am ablae to process and get a string that looks like this as an output before updating Airtable :
In this case, I have two pictures in the field attachments.
In Airtable it does this:
The field remains empty.
when I am testing the airtable update module with two images hosted on imgur with png and jpeg extension:
https://i.imgur.com/kJmYoqJ.png,https://i.imgur.com/H5D2iMj.jpeg
It only keeps the first image listed. How can I ensure that the two files are pushed to Airtable 2?
Perhaps I need to use a completely different strategy, or maybe there is a simple trick.
Interesting! Could you teach me about that trick for the Google Drive quota thing? I don't understand how that works and would love to know more!
---
For adding multiple files to the same field, I think I'd tackle it like this too:
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.