Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 03, 2023 07:26 PM
the circled part is the focus…
let take for instance
Mar 03, 2023 07:45 PM
Try something like:
IF(
AND({display attachment field}, {cloud hosted field} = ""),
{display attachment field},
IF(
AND({display attachment field}, {cloud hosted field}),
{cloud hosted field}
)
)
I don't know how you're determining which field to display if both fields aren't empty so I just picked the cloud hosted field. I would also recommend you check out the formula field reference
Mar 03, 2023 07:49 PM
That's actually true, the script for displaying one of them if both aren't empty will be needed.
Mar 03, 2023 07:50 PM
Have checked the formula field reference didn't see much that could be added to the script formula though
Mar 04, 2023 08:23 PM
Formula fields cannot display attachments. At best a formula field can display the file name and url of an attachment field. However, even though the url for the attachment might work for now, Airtable has stated that the URLs for attachments that are displayed in formula fields will become invalid. I would not count on them continuing to work.