@Function returns double values to text field

HCL Domino Domino Forum
1

I have a formula that uses the @DBName, @ViewTitle, and @DocumentUniqueID functions.

A combination of using these to develop a URL looks like this:

Link:=“http://”+server+“/”+ database +“/”+view+“/”+doc +“?opendocument”;

Each field (server, database, view, and doc) are separately assigned using the functions mentioned above.

The field “Link” is then sent through a @Mailsend function as the bodyField. (I’ve also tried it using the remarks field in the @Mailsend function.)

This works great EXCEPT that the Link field is represented twice in the email that is sent.

For instance, if the generated URL is “http://myserver/mydatabase/myview/mydocument” it will appear in the email as though it is a multi-value field, twice.

I’ve seen this behavior in creating columns in views using these @Functions. (It drives me crazy.) I am assuming that the system is parsing multiple times, and loses track of what it’s already put into the “Link” field.

What techniques should I use to remove this doubling?

2

Subject: @Function returns double values to text field

No, you should assume that the view has both a name and an alias, and that the formula sees both of them as a list. Try @Subset(@ViewTitle;1).

3

Subject: RE: @Function returns double values to text field

Stan,Thanks for this hint. This worked. I couldn’t find this documented anywhere.