AnsweredAssumed Answered

IsNullOrEmpty not working in a calculated field

Question asked by baltner on Jul 21, 2016
Latest reply on Aug 2, 2016 by baltner

Greetings:

 

I am performing a database lookup into a drop down list when the form loads. Because nothing has been selected yet the value of that control is null or empty, which I have confirmed with a calculated field that has this formula (it shows 'Empty'): 

 

If(IsNullOrEmpty(manager),'Empty','Not Empty')

 

However, when I use the same IsNullOrEmpty fuction in another calculated control in which the following calculation is done on the FALSE condition:

If(isNullOrEmpty(manager),'Not Available',

toTitleCase(parseLookup(manager,false).split('.')[0])

+ ' ' +

toTitleCase(parseLookup(manager,false).split('.')[1])

)

I get this error:  "Unable to get property 'split' of undefined or null reference.  Am I doing something wrong in this formula? I know that manager is null or empty when the form loads, which means that the split function should not be called until I actually select something.  Yet is seems to be executing, or trying to, even though I'm stipulating that it not be run unless the manager control is neither null nor empty.

 

Thanks, in advance,

Bruce

Outcomes