AnsweredAssumed Answered

validation by calculation

Question asked by malachydevlin on Feb 14, 2016
Latest reply on Feb 14, 2016 by malachydevlin

What should be simple is escaping me.. Getting old.

I have a company name field (in a customers table) and i want to validate it that its not empty (But only when another field is of a certain value..).

 

So I want the customer name to be mandatory when the customer type is set as "company"

 

for some reason this doesn't work in "validation by calculation"

 

If(customertype=company; length(company)>0;"")

Outcomes