Field Validation by calculation

[Oyseka]

Hi All,

I want to validate a field to be not empty and contain a specific number of digits if the text in another field meets specified criteria.

I have a field called Account_type, if the choice in that field is "Account" then I want to force the inclusion of a ten digit account number in the Account_Number field but only if the text "Account" is specified. I know this should be an easy If or Case statement but I am not getting it right.

[Vaughan]

Case(

account_type = "Account" ;

not isempty( account_number) and length( account_number ) = 10 ;

1

)

[comment]

Try =

Account_Type ≠ "Account"

or

Length ( Account_Number ) = 10

[Oyseka]

Case( account_type = "Account" ; not isempty( account_number) and length( account_number ) = 10 ; 1 )

Thank you Vaughan, that works. Would you explain the 1 as the second part of the Case statement please.

[Oyseka]

Try =

Account_Type ≠ "Account"

or

Length ( Account_Number ) = 10

Thank you Comment, this also works. Is there a functional difference between this and Vaughan's method

[comment]

There is no logical difference between them.