Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having trouble figuring out how to make a field less than an entered textbox value on a button press.
I have a field called Sales and a textbox where the user can enter a number. What i'm trying to do is after the user enters a number and presses the button, the page will only show sales less than that number.
So in the action dialog under "Select in Field" and i the "Search String" box i've been trying to set a field Sales to <MAX(EnteredNumber).
This isn't working though. Any ideas? Thanks!
Hi, with this sintax in the search string worked for me
= '< $(=InputValue)'
Hi, with this sintax in the search string worked for me
= '< $(=InputValue)'
Thanks Hector works Great. I wasn't really sure what was acceptable in "search string". Seems like a funny name for that field but oh well, it works!
Hetor, if you dont mind i would also be interested in knowing how to do this for 2 values. So that sales is between two entered fields.
= '< $(=InputValue1) AND > $(=InputValue2) doesn't work
Thanks.
'
Hi
the problem is the "AND" word, try with
= '> $(=InputValue1) < $(=InputValue2)'
Remember when you are filtering in the field, you don't use the "AND" word, you just use >5<=10
Rgds