AnsweredAssumed Answered

IsEmpty not working?

Question asked by newbiedonut on Dec 21, 2016
Latest reply on Dec 22, 2016 by erolst

Hi, I am trying to check for a field compliance, basically if the targeted field is empty, the compliance field will return "Non-Compliant" and if it's not empty (any text/number in edit box or certain option under in a value list), it will return "Compliant". I've tried setting the compliance field into a calculation field as such, If ( IsEmpty(Table::TargetedField) ; "Non-Compliant" ; "Compliant" ). However, the compliance field returns with "Non-Compliant" even if the field is not empty. Appreciate if anyone could help, thanks!!

Outcomes