Skip to main content

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

Is it not isNullOrEmpty rather than IsEmptyorNull?


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



I see you are using IsEmptyorNull.  


No, it is not(NullorEmpty)(Description)

Reply