big Airtable fan here, we are managing a lot of processes for a concert venue with this awesome tool.
Now we’re stuck with the following problem:
- People send data (some text fields, some attachments) via a form. This information is written into it’s own table (let’s call it “updates”). It can happen, that several people send different data to the same fields, for each submitted form a record is created.
- From “updates” this data is transferred into our “main table” via Automation UPDATE RECORD on trigger WHEN RECORD IS CREATED. We’ve also built a way to always keep the existing submitted informations if more is submitted to the same field by another form submission. So far so good.
- Uploaded Attachments can be JPG / PDF or similar, those shall be saved to the “main table” as well in the equivalent field. Now it’s getting tricky.
As far as i have read it’s not possible to move the attachments from one table to another with an automation, so instead we are working with URLs. I found a formular, that creates the attachment URLs, the syntax will be something like “https://dl.airtable.com/.attachments/xxxxxxxxxx”.
When i try to send these values to our main table (UPDATE RECORD), airtable changes them to links with the following syntax: “https://cdn.filestackcontent.com/xxxxxxxxxxxxxxxx” - and these just don’t work. We always get a “file cannot be found” error.
The same applies, if we use the “URL” value of an attachment field in Automations. In Preview it shows a (working) “dl.airtable.com” link, after running you’ll find a “cdn.filestackcontent” link (not working).
Does anybody know, why these links are converted, if it can be prevented or if there are any other ways, that we get URLs or (even better) Files in Attachment fields unconverted to our main table without having to do something manually? This is really frustrating and i wouldn’t be writing here if i hadn’t tried anything, that came to my mind.
One idea was to not have the links in “updates” be interpreted as links, but as plain text - but i couldn’t manage that either.
Thanks in advance for any ideas or hints!