Picklist Query

HCL Domino Domino Forum
1

Hi,grateful as ever for any kind advice.

Currently I’m using a button to populate a field on a form by using this Formula.

choice:=@PickList( [Custom] ; “” ; “NO” ; “Transfer Incident Report” ; “Please select the Nominated Officer who is responsible for this incident” ; 2 );

@True;

@SetField(“NomCN”;choice);

@SetField(“ROff”;choice);

@PostedCommand([FileSave]);

@PostedCommand([FileCloseWindow])

This works fine by taking the value from column 2 of the View “NO” and inserting it into my 2 fields called NomCN and ROff.

I would now also like to take the values of the 3rd column from the NO view and insert these into another 2 fields on the form.

Therefore when a selection is made from the picklist the values from the 2nd column of view “No” go into NoMCN and ROff and the values of the 3rd column go into “DepCN” and “DOff”.

Is is possible to do this by using @Picklist or can I only pull the contents of one column.

Really grateful for any advice.

many thanks

Charley

2

Subject: picklist

Not directly but there are a couple of ways of doing this

If you want to continue to use picklist you’ll need to redesign the view and concatenate the data into one column. This can then be pulled down into a field and your other two fields take their value from this field (using a delimiter between the two items).

Otherwise use lotusscript and picklistcollection. It’s pretty similar and probably more convenient. You can prompt for documents and selected notesdocuments are returned and you can do what you like with the data from them, ignoring the format of the view altogether

3

Subject: If you can use LotusScript

you can use PickListCollection where you get a collection of selected documents. Once you have the documents you can easily get whatever field values you want from them.