View selection formula

HCL Domino Domino Forum
1

Hi

I have to do a view with selection formula based on richtext field. I want to select document with richtext field not empty. How I can do this ?

Thanks

2

Subject: View selection formula

You can’t. Rich Text fields are not summary data, and are not accessible to view selection or column formulas. You’d need to create a second (computed text) field that stores an abstracted version of the rich text. It only needs to hold a few characters of the rich text to do what you want. Look at @Abstract in Designer Help.

3

Subject: View selection formula

create a hidden field (RTFlag) at the bottom of your document, make it a computed field and place a formula such as:

@if(richtextfield != “”; “X”; “”)

In your view selection, select only those documents where RTFlag = “X”

Taht should work easily

4

Subject: RE: View selection formula

actually a better formula to user in the hidden computed field would be:

@Left(rtfield; 5)

and then in the select statement just:

if rtflag != “”…

(this is since sometimes a rt field does not show that its empty - when it is)