Document Type Columns Bug

[JMPeterson]

I’ve noticed recently that in several different apps the [file], [image] and [url] type columns will save with a BLANK value (“ “), rather than an actual NULL. It messes with ISNOTBLANK()/ISBLANK() functions as well as some others.

Snapshot from the DB below.

Anyone else experiencing this?

[Shourya_Tomar]

Hello @JMPeterson,

You should replace your existing ISBLANK([Column]) or ISNOTBLANK([Column]) checks with a compound expression.

• Fix for ISBLANK() Logic

To check if a column is truly empty (either NULL or a blank string ""), use the OR operator:
OR(ISBLANK([Your File/Image/URL Column]), [Your File/Image/URL Column] = “”)

• Fix for ISNOTBLANK() Logic

To check if a column actually holds a value, use the AND operator:
AND(ISNOTBLANK([Your File/Image/URL Column]), [Your File/Image/URL Column] <> “”)

Thank you. I hope it helps!

[Steve]

It’s a bug and should be reported to Support.

[JMPeterson]

Thanks for the formula! I definitely understand there are workarounds, but the values being written to the database should be NULL, not BLANKS. Expanding the check to include ‘‘ values is great, but it doesn’t solve the root issue.