I have a table where there are potentially multiple images available:
- Two columns linking to other records, then
- One Lookup column for each of those to look up the image attachment, and then finally,
- One more column where I paste a screenshot, used for cases where neither of the other links are present.
So there are potentially 3 columns which could contain an image attachment.
If I were to try to build a sensible gallery or an app, I’d only want one image for many of the views, so I’d like to make a Best Image column.
The rules are more or less:
- Does Source 1 exist?
- If so, use Source 1
- If not, does Source 2 exist?
- If so, use Source 2
- If not, use Screenshot
If I try to do this using a Formula column, I end up with what looks like a URL to the image on dl.airtable.com, instead of it displaying the image. The docs do say that attachments can’t be returned from formulae. The thing it does return may be usable for a webapp still; I haven’t yet tried. At the very least, it isn’t viewable directly in Airtable.
Of course, I could just go through and manually copy-paste the best image from one column to another, and set up some kind of workflow to try and prevent me forgetting to do this after adding new records. I would prefer to automate the process though.
So, is there some other way to do this?