Jump to content
  • 0

Check if File Field is Blank


IamBlossom

Question

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!

 

 

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 1

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...