Getting items from a list field based on items from another list field

HCL Domino Domino Forum
1

HI

I have 2 list fields on my form. Both fields stand next to each other and allways have the same amount of items. So item 1 from field1 belongs to item 1 of field2, etc.

here is an example of values of those 2 fields.

List field1:

Team1;Team3;Team2;Team1;Team6

List field2:

Approved;Canceled;Approved;Canceled;Canceled

I have a 3rd field in which I want the items of field1 that are approved. How should the formula look like to achieve this?

Regards

2

Subject: Getting items from a list field based on items from another list field

Create a hidden view and build the first column from a concaenation of the 2 fields. When you only select documents that are Approved, you see what you want. When you need to show the data as in the original view, make the first column hidden and add the other columns as in the original view.