Skip to main content

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

Hi @LEROY_Frederic - try this:


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



JB


Hi @LEROY_Frederic - try this:


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



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 ?


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’)

Sorry for the late answer…

Same message when pasting.

I have an idea, using airtable APP on Macintosh or Web App



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


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!!


Hi All,


This formula works fine applied to a checkbox field


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


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


IF({Attachments}=1,“ 📌 ”)


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 All,


This formula works fine applied to a checkbox field


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


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


IF({Attachments}=1,“ 📌 ”)


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')



Marvelous! Thank you, Jonathan!


Reply