i just started working with Validations..
when i have gone through the syntax of IF then stattement,
But i am struggling to implement it after i see some examples in Complete reference 7.1 like IF(F1, F2)
F1 is true ->f2
f1 is false ->NULL
Can anyone explain with a practical real time condition
Thanks in Advance.
According to this Expression it tells when there is null value for field NAME then returns TRUE which mean Success but you didn't tell what should be done if this field NAME has value, that's why you are getting Success for Every record.
In other words, if you give expression as IF(IS_NULL(NAME),FALSE), it will gives always FALSE as you havent tell what should be happen if it has value.
So you need to tell bth TRUE and FALSE in your Expression to accurately make use of Validations.
Here, it gives TRUE (Success) for 3 rd record only,
And other 3 records which have values in them should be FALSE as you given in Exprssion if it has no value return TRUE(Success) and if it has Value Return FALSE
Hope you got my point !!