topic Re: Not relevant fields are still getting values in 3.12 in ArcGIS Survey123 Questions

Not relevant fields are still getting values in 3.12

DougBrowning — Wed, 10 Mar 2021 19:10:56 GMT

I have a field that inherits from another field. Both have relevants on them. The form is hiding the relevant field from display but it is still getting a value. This puts the value in my second field. But it should be "".

Field is not relevant from display

But it is getting a value somehow

Field is text and read only. This is the relevant and the calc that still fires.

contains(${TopCanopyDefault}, "XXXX")

concat(substr(${TopCanopyDefault},0,string-length(${TopCanopyDefault})-4), "_", ${CollectionNumberTopDefault})

The field that is getting this value also has a relevant contains(${TopCanopy}, "XXXX"). With a calc of if(${UseDefaults}='Yes' and ${UnknownCodeTopDefault} != '',${UnknownCodeTopDefault},if(contains(${TopCanopy}, "XXXX"),concat(substr(${TopCanopy},0,string-length(${TopCanopy})-4), "_", ${CollectionNumberTop}),''))

Note i even have a != "" in there and still gets a value.

So somehow a non relevant field is still calculating and it is adding its value into a second field that is also not relevant. Then join picks it up. Weird.

This does not seem to happen in our other forms that are published under 3.11.

Anyone seen this? Sorry it is hard to explain

thanks

Re: Not relevant fields are still getting values in 3.12

DougBrowning — Thu, 11 Mar 2021 22:30:19 GMT

Created a simple form today that shows this as well. If you inherit a value from a non relevant field that also has a calc to a relevant field it seems to get the value passed through. A non relevant field should be "" always right? It seems to follow the chain all the way to the original field.

See this form and how a non relevant field is somehow passing through to a relevant field. I thought it was due to a repeat but it happens outside as well.

Thanks

Re: Not relevant fields are still getting values in 3.12

ZacharySutherby — Tue, 16 Mar 2021 23:06:55 GMT

Hello @DougBrowning,

Thank you for reporting this! I've gone ahead and logged an issue in our database for the behavior. From my testing the behavior seemed specific to Note question types. If I switched the relevant note question to a calculate question the behavior was no longer reproducible.

Another workaround would be to double up on the relevant statement in the calculation. For example if(selected(${s1}, 'yes'), 1,0), this will also prevent the calculation from returning a value.

Thank you,

Zach