kirkie4567
Forms Fledgling

Required field validation

Jump to solution

Hi everyone

I am trying to set a field (Budget) as required when there is data in another field (Description) in the form. The field that I want to set as required is an integer field, and the other field in the form is a short text field. If there is no data in Description, then Budget must not be required, but if there is data in Description, then Budget needs to be required.

I tried this formula in the Required field properties of Budget, but it didn't work:

not(IsEmptyorNull(Description))

 

Could someone point me in the right direction?

 

Thanks

 

Kirk

Labels: (1)
0 Kudos
Reply
3 Replies
johns
Design Dabbler

Re: Required field validation

Jump to solution

Is it not isNullOrEmpty rather than IsEmptyorNull?

0 Kudos
Reply
kirkie4567
Forms Fledgling

Re: Required field validation

Jump to solution
No, it is not(NullorEmpty)(Description)
0 Kudos
Reply
kchaluvadi
Design Canvas Artiste

Re: Required field validation

Jump to solution

Use "Validation" type rule for this and the formula is --  not(isNullOrEmpty(controlname))

I see you are using IsEmptyorNull.  

View solution in original post

0 Kudos
Reply