Skip to main content

the circled part is the focus…

 

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

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

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. 

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


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. 

Reply


Terms & Conditions