Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Upload Multiple files in Airtable

Topic Labels: Automations Sync
Solved
Jump to Solution
509 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Pascal_Vallet
7 - App Architect
7 - App Architect

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?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

@Pascal_Vallet 

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

See Solution in Thread

airtable #on2air #builtonair 11/7/2023 - BuiltOnAir Live Podcast Full Show - S16-E06 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel
6 Replies 6

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!

Screenshot 2025-01-27 at 8.46.01 PM.png

Screenshot 2025-01-27 at 8.45.54 PM.png

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)

 

CleanShot 2025-01-27 at 08.54.58@2x.png

 

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 :

https://hook.us1.make.com/7b86at5v7xhn7asg8ndxbl4rs6cdb5o3?id=1TnINayV4jA8DkJSRx081r6B-RcxEJfIn,http...

In this case, I have two pictures in the field attachments.

CleanShot 2025-01-27 at 09.25.05@2x.png

In Airtable it does this:


 CleanShot 2025-01-27 at 09.24.12.png

The field remains empty.

when I am testing the airtable update module with two images hosted on imgur with png and jpeg extension:

CleanShot 2025-01-27 at 09.28.00@2x.png

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.

ScottWorld
18 - Pluto
18 - Pluto

@Pascal_Vallet 

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

airtable #on2air #builtonair 11/7/2023 - BuiltOnAir Live Podcast Full Show - S16-E06 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel

This has been very helpful, I was finally able to add multiple files thanks to your video.

@Pascal_Vallet That's great to hear! Glad I could help! 🙂 

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:
Screenshot 2025-01-28 at 11.05.37 AM.png

Screenshot 2025-01-28 at 11.05.54 AM.png

Screenshot 2025-01-28 at 11.08.16 AM.png