I have input box, which has 2 inputs vMinSY and vMaxSY for user to enter a value and I have triggers set on these variables to select in field "X" and have the expression ='>='&$(vMinSY)&'<='&$(vMaxSY) in Search String. If I input something like vMinSY = 20 and vMaxSY= 30, I get the values in field "X" which are >= 20 and <=30, but if I enter vMinSY=30 and vMaxSY=20, I get values of field "X" less than or equal to 20, but I don't want the field "X" to return anything, if vMinSY > vMaxSY.
Solved! Go to Solution.
I tried this, but if vMaxSY < vMinSY, I still get all values from field X. I tried giving a Null() in the else part of the if condition too.
So you are saying when the statement is false, you don't want to select anything, but it is still selecting? Would you be able to share an example where this is taking place?
I have't tested but I think it should work.
Try adding some symbols like,
='>='& If(vMinSY < vMaxSY, $(vMinSY)&'<='&$(vMaxSY),'~')