Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

How to check if attachement field is empty or not

Topic Labels: Formulas
Solved
Jump to Solution
7230 9
cancel
Showing results for 
Search instead for 
Did you mean: 
LEROY_Frederic
4 - Data Explorer
4 - Data Explorer

Hi everybody,

I’d like to check if an attachement field is empty or not. Someone knows how to do this ?

Tanks a lot.

Fred

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Ah, no… sorry, I know what it is — it’s the smart quotes. They got both of us.

Try again - copy-paste this:

IF(Rapport, 'OUI', 'NON')

… I promise you it will work this time

See Solution in Thread

9 Replies 9

Hi @LEROY_Frederic - try this:

IF(Attachments, 'There are attachments for this record', 'No attachments for this record')

Screenshot 2019-08-27 at 15.50.20.png

JB

Hi Jonathan,

Thanks for the answer, but…

Don’t know why, didn’t work with my table :
Rapport is my attachement field
in my test field the formula :
if (Rapport,‘OUI’,‘NON’)

airtable says in red : Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

an idea about ?

Do you have a space between the word “if” and the opening parenthesis?

Try pasting this formula in:

IF(Rapport, ‘OUI’, ‘NON’)
LEROY_Frederic
4 - Data Explorer
4 - Data Explorer

Sorry for the late answer…
Same message when pasting.
I have an idea, using airtable APP on Macintosh or Web App

10

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Ah, no… sorry, I know what it is — it’s the smart quotes. They got both of us.

Try again - copy-paste this:

IF(Rapport, 'OUI', 'NON')

… I promise you it will work this time

Oh yes!!! Thank you very much!!

Heather_Brown
4 - Data Explorer
4 - Data Explorer

Hi All,

This formula works fine applied to a checkbox field

IF({Print copy sent}=1,“ :green_book: ”)

but when I try to apply to an attachment field, it’s not working

IF({Attachments}=1,“ :pushpin: ”)

I tried with and without curly brackets and edited quotes, checked spaces, etc. Any idea what I might be doing wrong?

Thank you!
Heather

Hi @Heather_Brown - “=1” works OK with a checkbox field but not with an attachment field. For an attachment, you need to do:

IF({Attachments},'📌')

Side note: this also works with a checkbox field, so, something like:

IF({Checkbox}, 'checked', 'not checked')

Screenshot 2021-06-21 at 20.18.40

Heather_Brown
4 - Data Explorer
4 - Data Explorer

Marvelous! Thank you, Jonathan!