The entry number of the document

HCL Domino Domino Forum
1

When i want to use @Dblookup to get some field,i get nothing.Field value =

@Dblookup(“”;Server_Name:Db_Name;View_name;key;5).

And the “key” is the value of other field ,the “5” is @Docnumber.

I am sure that i get the doc bacause replaceing 5 to 4 or 3 etc. is correct.

I need the entry number of the document to do something.So how could i do?

Thanks for your help.

2

Subject: Unfortunatley you can not retrieve or manipulate a column w/ @DocNumber. Been that way since V3

3

Subject: the entry number of the document

You have your syntax wrong. 5 is telling the formula to retrieve the value of the 5th column of the document found by the key.

Try this:

Add a first column, sorted in your view with the following formula: @DocNumber( “” ). Assuming a non categorized view, this will give you the document number.

Change your @DBLookup to:

tmpKey=5;

tmpFieldValue:=@Dblookup(“”;Server_Name:Db_Name;View_name;tmpKey;FieldName);

tmpFieldValue

(and yes I know I left error checking off of this:-)

Let me know if this does the trick as it is untested other than the fact I can get the do number displayed in the view.