Creating a button with an "or" function

[#1]

Sorry all, newbie question here.

I have two seperate fields - 1. Design, 2. Effectiveness

Each field has four options - Red, Amber, Green, N/A

I want to create a button that will select all items that are red or amber for either the Design or Effectivness (i.e. Design - Green, Effectivenss - Amber should show up).

Is this possible?

Really appreciate the help!

[calvindk]

Yes, start by creating the button. Then in ACTION, you click ADD and then add SELECT IN FIELD

In the field you enter Design

In the search string try

='(Red|Amber)'

[#3]

Thanks Anders.

I'd like to take it a step further though.

How do I say if Design = '(Red/Amber)' OR Effectiveness = '(Red/Amber)'

[calvindk]

Well you add an extra action to the button that does it for the other field

[#5]

I tried that but it is now only showing me instances where both the Design and Effectiveness fields are amber/red.  I'd like to switch it to an or...

[calvindk]

if i understand correctly you want anything showing up that has either a amber/green rating in design or a green/amber rating in effectiveness.

This can be done if you have another value to select, such as an id.

Instead of selecting the green/amber then you select the corresponding id's.