AnsweredAssumed Answered

Filter to match against two columns

Question asked by tplant on Nov 15, 2017
Latest reply on Nov 21, 2017 by cazza162

Hello everyone,

I'm hoping what I am about to ask is possible in some way.

 

The scenario: there are two lists. The first list is a list of cables that are connected to two rooms.

The building and room columns are lookup fields.   

Cable Name

Building1

Room1

Building2

Room2

Short Cable

North Building

N01

South Building

S01

Medium Cable

South Building

S01

West Building

W01

Long Cable

East Building

E01

North Building

N01

 

 

Which building comes first is arbitrary in each room. I.E. 

Medium Cable

South Building

S01

West Building

W01

 

is logically equivalent to 

 

Medium Cable

West Building

W01

South Building

S01

 

For the second list I want to use a nintex form that can filter a Cable Name drop-down where 

it checks against two columns. If a user selects S01 in the Room drop-down, the cable name drop-down will filter to Short Cable or Medium Cable by checking to see if S01 is in Room1 or Room2.

 

To help explain better here is a diagram:

 

 

Currently I can filter where one column matches but I would to include matches against the second column as well.

Outcomes