Skip to main content

Good afternoon,

I am using Make.com to pull information from Airtable, generate a letter/timesheet, save this to One Drive then I need to import it back to Airtable as an attachment. 

The Make.com syntax is fine (and has been checked by the Make.com support team), and when I run it, there is a fleeting icon of a file appearing in the attachment field on Airtable, but then it disappears and the attachment is not in Airtable. 

If I run this through Cloud Convert to create a PDF, it works, but there is a 10 second delay in creating then uploading the document, which then means further iterations fail. What I need is for the document to pull in as a PDF directly from One Drive to the attachment field in Airtable. 

Any help gratefully received. It works fine when I use Google Drive, but I’m trying to avoid this as the company would like me to keep it all on the Microsoft subscription.

Thank you, Jane

Hey ​@namaste374,

Would you mind expanding the details of your airtable record, taking a screenshot of the Revision History for such specific record, and sharing those screenshots here?

That would be super helpful to further debug.

Mike, Consultant @ Automatic Nation 
YouTube Channel 

Hi ​@namaste374,

When sending the URL of the file to Airtable, you’ll need to make sure that the URL is publicly-accessible by anybody on the web, and that the URL is a direct link to the PDF file itself.

If you’ve already got all of that taken care of with CloudConvert, but you just need to wait 10 seconds for the PDF to finish being created, then you can use Make’s Sleep Module to pause for 10 seconds before continuing your automation.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

 

I think ​@ScottWorld has probably IDed your issues, either it’s a visibility issue in OneDrive or a timing issue. Since the company wants you to keep it all on MS, perhaps there are enterprise sharing controls enacted?

My one other comment is that it can always be instructive to step back and see if re-ordering fixes or provides alternative solutions. So right now you’re loading the file into OneDrive and then attaching it to an AT record, is there a way to generate and attach it in AT and then send that to OneDrive? Just sometimes I get fixated on an order of operations that closes down other possibilities 🤷‍♂️

Terms & Conditions