topic Re: string-length expression on decimal value returns 0 in ArcGIS Survey123 Questions

string-length expression on decimal value returns 0

Anne-MarieDubois — Tue, 05 Apr 2022 15:14:18 GMT

Hello,

I'm trying to use an expression to evaluate if a decimal field is empty or not in Survey123. I have found this option :

(string-length(${latitude}))>0

Unfortunately, this returns the "string-length(${latitude})" portion of this expression returns a value of 0 whenever I try to enter a decimal value.

Example: decimal not working

example: integer works

I have tried these altenatives without sucess:

Can anyone help me finding a way to identify empty decimal fields ?

Kind regards,

Anne-Marie

DougBrowning — Tue, 05 Apr 2022 15:30:46 GMT

Checking on numbers can get tricky. Have you tried ${latitude} != '' yet? Any empty field is usually empty string, even numbers.

Anne-MarieDubois — Tue, 05 Apr 2022 15:49:46 GMT

Yes I tried that already and it does not work.

DougBrowning — Tue, 05 Apr 2022 15:56:09 GMT

What about = 0 or != 0 that sometimes works for me.

Anne-MarieDubois — Tue, 05 Apr 2022 16:06:36 GMT

That doesn't work either. The thing is is that the available expressions don't seem to make a diffrence between an empty field OR a decimal field.

DeonLengton — Wed, 06 Apr 2022 07:42:43 GMT

Try first converting it to a string and then checking it's length:

string-length(string(${latitude}))=0

Anne-MarieDubois — Thu, 05 May 2022 19:33:56 GMT

Still same issue. It only works for integers.