How to convert @DocNumber to a num?

HCL Domino Domino Forum
1

Hi, I hava a problem with converting @DocNumber to a umber in a view.

I need use the @DocNumber/3 to put on the other column,

and I also want to know which formula can instead of the LotusScript FRACTION , INT function?

thanks.

Linda

2

Subject: How to convert @DocNumber to a num?

From Notes Help:

docNum

Special text. The value that represents the document number of the document or category in the view. You cannot convert special text to a number.

3

Subject: How to convert @DocNumber to a num?

From the help

Return value

docNum

Special text. The value that represents the document number of the document or category in the view. You cannot convert special text to a number.

The only way would be to walk the viewentrycollection with a script agent and collect the numbers there

4

Subject: RE: How to convert @DocNumber to a num?

Thanks for your help.

In my case, the @docNumber is integer,such as 1,2,…766.

I try to tmp:=@text(@DocNumber);

       tmp:=@texttoNumber(tmp);

       I don't know in formula which function can instead of Fraction function in the loutsScript?



if it will work, I don't need to use lotusScript.

thanks.

Linda

5

Subject: RE: How to convert @DocNumber to a num?

You just can’t get it as a number, integer or not.

6

Subject: How to convert @DocNumber to a num?

There’s a reason you cannot get this to work … those numbers are not known when you need them.

Look at it this way … The Notes server builds a view index, which includes all of the column values for your view - this is when you would need to know the value of DocNumber.

Now I, as a user, open the view. As some of the documents have reader fields, I only see a subset. Once Notes has that subset, it only then calculates the Docnumber based on the documents I see.

That’s why “SpecialText” fields are “Special” they are build on the fly way after the view’s column values have been calculated, and so are unknown to column formulas.