I have a constraint on an Integer field where it must be 0 if another field is No and > 0 if Yes.
if(${FlowPresent}="No",${ThalwegDepthCM} = 0,${ThalwegDepthCM} > 0)
(note I had to write out the field name since .>0 did not work)
If I pick No then enter a value that is not 0 then the constraint fires and stops me. But if I leave the field totally blank then it lets it go through.
Is this a bug?
I also tried testing string length and that lets it go also.
if(${FlowPresent}="No",${ThalwegDepthCM} = 0 and string-length(${ThalwegDepthCM}) != 0,${ThalwegDepthCM} > 0)
and tried string-length(${ThalwegDepthCM}) > 0
How can I fix this? Note I cannot use relevant since the users sometimes do not do the form in order.
Thanks