Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Script to create and attach .ics file?

Solved
Jump to Solution
579 1
cancel
Showing results for 
Search instead for 
Did you mean: 
DisraeliGears01
6 - Interface Innovator
6 - Interface Innovator

Wonder if anyone has something that works for this... I'm creating discrete events in a base, and I want to automate the process of turning the data points into a .ics file and attaching it to the record in an attachment field. It's a bit like this walkthrough  but instead of using Make to attach the .ics into an email, I want to return the file to the Airtable record's attachment field. Then anyone who has access to the record can download and save the calendar entry to their own calendar. 

Per that walkthrough I was trying to get Make.com to do this but I keep running into Bundle Validation Errors, and I'm wondering if there's a way for Airtable to handle this inside the base via scripting. 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm that'd require you to be able to create a file via scripting, which I'm sure is possible but off the top of my head I can't think of how I'd do it.  After that you'd need to upload it somewhere else as Airtable attachment fields require a URL to upload files, we can't upload files directly

With reference to the guide you linked, I'd try:
1. Use the send email step to create the .ics file
2. Have another automation that triggers when it receives an email (like the mailhook)
3. Upload the file into Google Drive, get a shareable link, and then upload it in to Airtable

I'm sure there's a more streamlined way to do it but the above should work

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm that'd require you to be able to create a file via scripting, which I'm sure is possible but off the top of my head I can't think of how I'd do it.  After that you'd need to upload it somewhere else as Airtable attachment fields require a URL to upload files, we can't upload files directly

With reference to the guide you linked, I'd try:
1. Use the send email step to create the .ics file
2. Have another automation that triggers when it receives an email (like the mailhook)
3. Upload the file into Google Drive, get a shareable link, and then upload it in to Airtable

I'm sure there's a more streamlined way to do it but the above should work

Thanks for the advice, I didn't realize attachment fields need a URL for upload.

Cutting out the email middle man, I can use Make to directly save the file to GDrive, and then conceivably Make tells GDrive to attach the file using GDrive's URL, but I'm running into two more problems. One is GDrive wants to save the file as XYZ.ics.txt, appending the .txt on the end of my specified format.

The other problem is that even though Make says everything is successful, file attachments aren't populating in my base. Make is affecting the record (I enabled a change in a select field to show that changes are being pushed) but nothing shows up in the attachement field, even though Make says it does... I wonder if it's a handoff problem between GDrive and AT?

Problems solved!

I can append .ics at the importation to Airtable renaming the XYZ.txt file XYZ.txt.ics and it functions as a calendar file. Meanwhile my attachment issue was that the Gdrive folder I was using to hold the files wasn't set to share publicly. I still have some tweaking to do on the text side (my timezones are wrong) but everything now works in principal.   

Should anyone want a similar build, I've attached a screenshot of my make diagram 

Oh woah, that's super cool, I never knew you could just create a file like that

Thanks for sharing!