I have a simple view that shows documents at 4 different steps in a process wether 4 different fields are filled or not.One column shows an icon with this formula :
@If(AP_ClosLe=“”; @If(Resolu=“”;@If(EnCours=“”;115; 116); 117); 114)
I would like to be able from 4 action buttons to select only 1 of these groups of documents.
Is it possible to dynamically change the SELECT formula ?
Where should I put the code ? What code ?
Thanks a lot for your help.
Jean-Pierre Bloch
Grenoble - France
Subject: No
There is no efficient way to select only one type of document from a user point of view or to change the selection formula later. However:
Your code @If(AP_ClosLe=“”; @If(Resolu=“”;@If(EnCours=“”;115; 116); 117); 114)
Looks simpler (easier to read) if writthen like this (which is supported since Notes 3 about 15 years ago)
@If(AP_ClosLe=“”; 114; Resolu=“”; 117; EnCours=“”; 116 ; 115)
You might want to embedd the view in a form or page an look at the single
You might want to make this colum sortable (second tab in proberties) - which would group documents of the same time together
You could simply do 4 views
You could select via agent
If you have the option to do the data in nsfdb2 and to access via sql, that view could have a dialog to select this (have never doen this but seen demo, and the installation is quite something).
Subject: Thanks for help
It’s a long time since I did some programing in Lotus Notes, although one day I was certified…, so I was not too sur of what was possible nowadays.
Your suggestions are straight to the point.
It gives me a large panel of solutions.
I will probably go for 4 different views which is, I guess, the smartest solution for users.
Thanks again.
Jean-Pierre