Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thanks!
Thanks, it works!
Thanks, it works!
Hi Sunny,
Can you help me to understand why expression ='>='&$(vMinSY)&'<='&$(vMaxSY) is not working for me but for all of you guys. It works with apostrophe around $(vMinSY) and $(vMaxSY) , like ='>='&'$(vMinSY)'&'<='&'$(vMaxSY)'.
Thanks in advance!
Can you share the test file where you are testing this...
Here it is, I was trying trigger with Year field. When I remove apostrophe around $(), it doesn't respond. Checked 2-3 times.
Should work now... your vMinSY variable had an extra space
Thanks! You are great!