Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Using a field as link.

Posted on 2004-11-24
Medium Priority
Last Modified: 2013-12-18
I have R6 and Notes.
I have a computed when composed field that I'd like to use as a link is this possible?
Question by:cyle
  • 4
  • 3
  • 2
LVL 31

Expert Comment

ID: 12669580
Yes.  Just select the field, create->hotspot URL, then change the link type to URL.  YOu may need to add some temporary dummy text aruond the field while selecting it, in order to create the hotspot, but you can delete the extra text once the hotspot is created.

If you want the link to be fixed, you just fill in the URL in the properties box.  If you want the URL to come form the vaue of a field (e.g., your computed field), then click the "@" button, and type the name of the field, or a formula based on the field.

Author Comment

ID: 12669662
   Increased the points for a follow-up. Your suggestion worked well but the value of the field that I used as a link is a document number which I need to search and open. I am not so familiar with using formulas to achieve this. Can you please help?
LVL 24

Expert Comment

ID: 12675907
How is this doc link obtained ?

If you pass raw document id to a computed field.. it will be displayed as document link. Some cases the response holds the $Ref object refering to the parent doc.. when placed in a computed field will create a link to the parent doc. Is this what you are looking for.

More details could help give you some soln

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 31

Expert Comment

ID: 12692695
By doucmnet number, do you mean one of the Notes internally generated numbers, or a key value that you set?

Notes-generated .NotesID / @NoteID value -- I would suggest getting away from this, as it is not suported in R6.  If you must use it, you can use it exactly as in the next paragraph, because either will work the same way.

Notes-generated UniversalID / @DocumentUniqueID -- also known as UNID and document replica ID.  If this is in teh same database, then following formula should work:
dbFile := @Subset(@DbName;-1);
dbURL := "/" + @ReplaceSubstring(dbFile; "\\" : " "; "/" : "+");
docURL + "?OpenDocument"

If it is your own key value, then a very similar formula will work.  First, you need to build a view, which I will call LOOKUP_DOC_KEY.  The view should only contain the documents you wish to allow the links to, and it should have a single column, sorted, and that column should be the field in the document that contains the key (i.e., not the field in the document that contains the link, but the field in the document being liked to).  The formula is the same as the previous one (notice how I cleverly used that view name above -- Domino ignores the view name in the URL if using a Notes-internal ID, but uses the view name to lookup the document if using any value that does not seem to be an internal ID).

Author Comment

ID: 12697168
I tried your suggestion and I cannot seem to make it work. This is waht I did.

BAseqnum is a generated number not UNID

docURL := dbURL + "/BAnumLookup/" + @Text(BAseqnum);

This is the URL that it created


Error "Cannot find server"

LVL 31

Expert Comment

ID: 12702618
I just tried it, and it seems to work.  

Please do the following:

1) Paste here the code of the link formula exactly as is

2) Open one of those documents in teh Notes client, and hover over the link.  What EXACTLY does it display in the status bar?

3) What version of Domino server?  WHat version fo client?  What version of Designer?  (I know yu say R6, but they could all be different versions)

4) Are you expecting users to click on the link in the Notes client or on the web?  Please confirm that this is all on the web.  If using Notes client for any of this, the procedure is COMPLETELY different.

Author Comment

ID: 12709414
I have all R6 and Notes Client.
LVL 24

Expert Comment

ID: 12710286
Do you have server called Additional Databases ?

Secondly did you enable http task on this server..

Better can't you use Notes protocol rather than http  ?
LVL 31

Accepted Solution

qwaletee earned 2000 total points
ID: 12711136
OK, what I just described was for a web link.  Here's the equivalent code for a Notes client.  Make it an action link.

@Command([OpenView]; "LOOKUP_DOC_KEY"; ""; "1");

That will allow the Notes client to open another document in teh Notes client, using the specified view and the key field to find the document within the view.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question