Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Embed Formula Link or attachment

1942 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sched_kode
5 - Automation Enthusiast
5 - Automation Enthusiast

the circled part is the focus…airtable.PNG

 

let take for instance

  1. If the "display attachment field" is not empty and the "cloud hosted field" is empty, a formula to display the display attachment field and not the cloud link field
  2. If the "display attachment field" is not empty and the "cloud hosted field" is not empty, a formula to display one of the field
4 Replies 4

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

That's actually true, the script for displaying one of them if both aren't empty will be needed. 

Have checked the formula field reference didn't see much that could be added to the script formula though 

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.