Check if File Field is Blank

[IamBlossom]

I would like to have a formula field that will check if the File Field is blank or not. Below is the formula. It validates, however, it does not work as expected.

CASE WHEN [@field:Images] IS NULL THEN 'No image attached' ELSE 'Image available' END

I used this format in other field like Text(255) and I am getting the expected output. I am wondering why it does not work in File DataType. 

Can you please help me? 

 

Thanks in advance!

 

 

[cheonsa]

Hi @IamBlossom, 

For File DataTypes, you need to use SQL's "DATALENGTH" to measure if the field has content or not. It is a behavior that NOT NULL or IS NULL will not work for File Datatype.

Use this instead:

CASE WHEN DATALENGTH([@field:Images]) = 0 THEN 'No image attached' ELSE 'Image available' END

 

Hope this helps!

[NailDyanC]

Hi, just to add to the previous comment above, you may also consider to try this formula:
CASE
WHEN CAST([@field:Photo] as NVARCHAR(max)) = '' THEN
'No Photo'
ELSE
[@field:Photo]
END

[Barbie]

Hi guys,

You may want to check this article as well: https://howto.caspio.com/function-reference/

It provides  example and explanation in some of the formulas.

- Barbie

[RuisiHansamu]

This should also help you out with understanding the feature: 

 

[IamNatoyThatLovesYou]

Hello Everyone, I tried a IS NULL and it worked on my end as well.
CASE WHEN [@field:Picture] IS NULL THEN 'Image Unavailable' ELSE 'Image available' END

[ianGPT]

Hi,

Just want to share that this formula also works.

 

CASE
WHEN Len([@field:Filetypes]) = 0 THEN 'No'
ELSE 'Yes'
END

Hope this helps!

[cheonsa]

Hi all, 

Just wanted to share with you this formula that checks if the file field contains a value or not.

CASE WHEN LEN(CAST([@field:File_] AS NVARCHAR(125))) = 0 OR [@field:File_] IS NULL
THEN 'No Photo'
ELSE [@field:File_]
END

Hope this helps.