Not relevant fields are still getting values in 3.12

dougbrowning

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}, "xyz") 

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

The field that is getting this value also has a relevant contains(${TopCanopy}, "xyz").  With a calc of if(${UseDefaults}='Yes' and ${UnknownCodeTopDefault} != '',${UnknownCodeTopDefault},if(contains(${TopCanopy}, "xyz"),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

ZacharySutherby

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