Skip to main content
Solved

Script to create and attach .ics file?

DisraeliGears01
Forum|alt.badge.img+17

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. 

Best answer by TheTimeSavingCo

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

View original
Did this topic help you find an answer to your question?

4 replies

TheTimeSavingCo
Forum|alt.badge.img+28

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

Adam, Consultant @ thetimesaving.company
DisraeliGears01
1 person likes this
  • DisraeliGears01
    DisraeliGears01
DisraeliGears01
Forum|alt.badge.img+17
TheTimeSavingCo wrote:

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?

DisraeliGears01
Forum|alt.badge.img+17
DisraeliGears01 wrote:

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 

1 Attachments
TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo
TheTimeSavingCo
Forum|alt.badge.img+28
DisraeliGears01 wrote:

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!

Adam, Consultant @ thetimesaving.company

Reply


Most helpful members this week

Terms & Conditions