Search String for multiple Fields

[#1]

Hi,

I have a slider that assigns the value to a variable vEndNetwr. If vEndNetwr changes, i want to select in two Fields, but with an OR Operator. Means when I change the slider, it should return me records where field 1 is larger than vEndNetwr OR field 2 is greater than vEndNetwr.

So far ive done it for one field, where I define an action "Select in Field" with Field 1 and a search string "='>=' & vEndNetwr  ".

For one field it is pretty easy, but how do I do this for 2 fields with OR Operator?

Thanks!

[ahaahaaha]

Hi,

May be like as at attached file?

Regards,

Andrey

[#3]

Hi Andrey,

Thank you for your reply.

For example you have a table called Table 1:

ID     value1                         value2

1       10                               40    

2        25                              10

3        30                              30    

4         5                               15

I have a slider which shows value from 0 to 100. If i change the slider to value = 20 it should return me all

rows where value1 is greater than 20 OR value2 is greater than 20. How can i do this?

ID     value1                         value2

1       10                               40    

2        25                              10

3        30                              30    

Thanks!

[sasiparupudi1 · Accepted solution]

May be like attached?

[#5]

Hi,

can you tell me what actions and variables I need, since I unfortunately work on a desktop version without a license.

Thank You