Solved

Required field validation

  • 10 June 2021
  • 3 replies
  • 59 views

Badge +3

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

icon

Best answer by kchaluvadi 10 June 2021, 22:29

View original

3 replies

Badge +2

Is it not isNullOrEmpty rather than IsEmptyorNull?

Userlevel 3
Badge +12

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


I see you are using IsEmptyorNull.  

Badge +3
No, it is not(NullorEmpty)(Description)

Reply