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?
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!
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.
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
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.
@Pascal_Vallet That's great to hear! Glad I could help! 🙂
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.