Locations and show if expressions

Andrea2 · 12-09-2019 12:34 AM

Hi There. I am trying to create a show if expression for a column with an address. The address column should only show in the form if the location is not picked up automatically in the location column. I have used this [Location]=0.000000, 0.000000 but it is not working. This is what shows in the location column when location has not been picked up. What am I doing wrong?

Kirk_Masden

Personally, I haven’t dealt with a situation exactly like yours so I’m not sure but I wonder if ISBLANK([Location]) might not work.

Andrea2

Thanks Kirk, I tried that already. Didn’t work.

Kirk_Masden

I see. Sorry I couldn’t help. Good luck!

Steve

Try:

([Location]="0.000000, 0.000000")

Andrea2

Thank you Steve, I got it to work.