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 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.