topic Re: Blank record in calculated field in App Development

Blank record in calculated field

Anonymous — Sat, 25 Aug 2018 01:56:06 GMT

Here is my calculated field formula

IF(WildMatch([State],'* *',[Title],'*Mr*'),'Unknown',)

If the field State is blank with no data and the field Title is ‘Mr’ then I want the calculated field to display ‘Unknown’ for that record. I don’t think I have the correct syntax for the blank field with no data, can you help?

Re: Blank record in calculated field

andrey_krylov — Sun, 26 Aug 2018 12:10:13 GMT

Hi, Boon, you have to use wildmatch() for every field. So, it would be

If(WildMatch([State], '* *') and WildMatch([Title], '*Mr*'), 'Unknown')

But as for blank values, i'd do it differently

If(len([State]) = 0 and WildMatch([Title], '*Mr*'), 'Unknown')