Help

How to check if attachement field is empty or not

Topic Labels: Formulas
Solved
Jump to Solution
5372 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!