How to solve the problem of Airtable attachment URLs expiring after 2 hours

:hammer_and_wrench: If you use Airtable to manage images or videos in your app or website, you might have noticed that attachment URLs (from the “Attachments” field) expire after about 2 hours. This behavior was introduced for security reasons and can cause problems with displaying multimedia content in your applications.

:white_check_mark: The solution: use Cloudinary with Zapier or Make

To overcome this limitation, I implemented a workflow that uses Cloudinary together with Zapier (or Make) to obtain permanent and public URLs for images or videos. Here’s how it works:

  1. Trigger: When a record with an attachment is created or updated in Airtable.
  2. File extraction: Zapier retrieves the file via the Airtable URL from the “Attachments” field.
  3. Upload to Cloudinary: The file URL is uploaded to Cloudinary, which provides a public and permanent URL.
  4. Record update: The Airtable record is updated with the new URL provided by Cloudinary.

This process ensures that images and videos are always publicly accessible, without worrying about Airtable URL expiration.

:wrench: How to implement it

You can configure this workflow using Zapier by following these steps:

  1. Trigger: “New Record in Airtable” or “Updated Record in Airtable”.
  2. Action: “Upload File” in Cloudinary.
  3. Action: “Update Record” in Airtable to save the public URL.

Alternatively, you can use Make to achieve the same result with a similar configuration.

:camera_flash: Practical examples

To help you with the setup, I’m attaching some images showing the automation in Zapier and the database structure in Airtable:

  • Screenshot of the workflow in Zapier
  • Example of an Airtable record with the “Attachments” field and the field with the public URL

I hope this solution can help you better manage multimedia content in your app or website developed with Softr and Airtable.

2 Likes

Thank you for sharing !!

@MarckVincix, thanks for sharing! I’ve been using Cloudinary and MinIO on my own server to store images, but I currently feel comfortable using Supabase storage, all managed through N8N. I eagerly await the API for Softr Tables to streamline my app.

1 Like

Yes Supabase is a great solution I also use it in my project in Softr.

Will Softr Table have the ability to insert and store images and videos with permanent url?

1 Like