Hi, all, I am confused of using IsNull here when I use IsNull() to check whether there value from a fieldName is selected or not.
I can understand that if no selection of fieldName, then IsNull(fieldName) is true, but when I select more than one value from the fieldName, the result is also true, which I expect be false.
If that is the case, then how can I identify there is no selection of a field? I need to use the result as a condition to show other object.
Thank you very much~
isNull(FieldName) will evaluate to True and is working as designed.
Reason being is that for one row (or in a textbox) FieldName will have multiple values (if you select more than one value). Since FieldName is not deterministic (it can have more than one value) it returns null() or '-'. IsNull() of null() is true.
If you wish to identify if there are no selections in a field, use GetSelectedCount(Fieldname)=0 as Aurelien suggested.