To explain my project, I have two tables :
- A "Movies" table that stores a list of movies, one of the fields in this table is an Attachment field that contains the movie poster image.
- A "Catalogs" table that has a link to the "Movies" table.
The goal of my project is to create catalogs by selecting the movies I want to include using the link to field, and then, by clicking a button, launch a Make scenario that retrieves the selected movie list and generates a catalog in PDF format using Eledo. The data insertion into Eledo is done in JSON format (example: {"title":"Movie1","description":"Description1","img":"URL1"},{"title":"Movie2","description":"Description2","img":"URL2"}).
Before the Airtable changes, this project was easily working because I could simply retrieve the movie image URL using a formula for the "URL" value. However, since the changes, this is no longer possible.
I do have a solution, which involves manually replacing the JSON for each movie in the Make scenario and setting the "URL" value to the functional URL "https://v5.airtableusercontent.com" that remains valid for 2 hours (which is more than enough time to launch the scenario). The issue is that this would consume a large number of Make operations, so I would like to know if there is a better solution.
Is there any way to obtain the "https://v5.airtableusercontent.com" URL of an Airtable attachment using a formula or any other method?