Help

Upload Multiple files in Airtable

Topic Labels: Automations Sync
Solved
Jump to Solution
423 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