0
votes

Today I've received an answer which helped me at this topic : Lotus Notes 7 - Categorized column issue .

For this topic, the scenario is quite similarly: there are 2 forms: "fmA" and "fmB", "fmB" may be connected with "fmA" by its UNID or may be not.

The "fmB" has a field - checkbox with Yes or NO as options. This field doesn't exist on "fmA". What I want to display is smth like this:

1st doc from fmA

  YES

      1st doc from fmB ( that depends on 1st doc from fmA) with checkbox = YES

      2nd doc from fmB -----------||--------------------   with checkbox = YES  

  NO
      1st doc from fmB ( that depends on 1st doc from fmA) with checkbox = NO

      2nd doc from fmB -----------||--------------------   with checkbox = NO

YES

1st doc from fmB ( which doesn't depends on any fmA) with checkbox = YES

2nd doc from fmB ( which doesn't depends on any fmA) with checkbox = YES

NO

1st doc from fmB ( which doesn't depends on any fmA) with checkbox = NO

My first column is hided and ascending having a formula :

@If(Form="fmA";txt_UNID;txt_UNIDB)

and the second one have the following formula:

@If(Form="fmA";@Return("");checkbox="Yes";"YES";checkbox="No";"NO";"")

But the docs are displayed strangely and not together ( where it is the case ).

I appreciate any help! Thanks

1

1 Answers

0
votes

Just switch the two columns...

View Selection formula: SELECT Form = "fmB" (no need to show fmA- docs)

First Column, Categorized: @If( checkbox="Yes";"YES";checkbox="No";"NO";"") or easier: @Uppercase( checkbox )

Second column, categorized flat (or sorted only): txt_UNIDB