Help with a view 1

[jmarty]

Hi,

I've inherited an old app running on Domino 4.61 and have been asked to create a view based on an existing one. The existing view selects documents created with different forms. I would then like to create a column that categorizes the data by selecting the field and setting the option in the column options. However two documents contain the same field name, not a shared field, and obviously the view is categorizing using the field in the wrong document. Is there any way to describe a field more completely like myform.myfield and inserting this as a formula?

Any help much appreciated.

 

[erehnke]

you can create a column and use a column formula instead of a field name in the following fashion:

say, for example that for the NAME forms you want to use the LASTNAME field while for the ADDRESS forms you want to use the FULLNAME field. create a categorized view column and plug in the formula:

@If(Form="NAME";LASTNAME;
Form="ADDRESS";FULLNAME;
"INVALID FORM"

get the idea? the "INVALID FORM" just traps out instances where none of the IF clauses is true.....

eric rehnke