Using the column Constraint

Erike
New Member

Im trying to ask the user to fill a text field if a set of given conditions.

I was nor working properly for me, so I reduced the complexity of the expression to a very simple one to isolate the issue.

I have defined it as follows:

IF(
ISBLANK([_THIS]),

false,
true)

3X_e_4_e494537806b5b53f75b2e6568a924d50e06f49ea.png

When clicked on Save, the expected behaviour is:

if the field is empty the message must be displayed and not saved.
if not, the record must be saved

Well, it saves allways the record.

Seems that ISBLANK is providing an unexpected result. So, for a second column, I calculated it based on the value of the first column.

IF(
ISBLANK([recepcionNotaTransportes]),
true,
false)
3X_f_9_f99a3f18a3b152f2a52666b01705b821f1a37e55.png

What I see is that the second column provides a true or false value if the first column was empty or not.

But the first column was not displaying the error message if it was empty

What am I missing?

Solved Solved
0 11 549
1 ACCEPTED SOLUTION

No. The Valid If expression isnโ€™t even evaluated if the column value is blank.

View solution in original post

11 REPLIES 11
Top Labels in this Space