Domino Code Fragment

Code Name* Doclinking Parent to Child A Notes formula for doc-linking a parent to a child in Notes R3/4	Date* 04/29/2024	Source (or email address if you prefer)* Rlatulippe@romac.com IP address:.3.135.216.174
Description* Doclinking Parent to Child A Notes formula for doc-linking a parent to a child in Notes R3/4	Type* LotusScript	Categories* (Misc)

Implementation:	Required Client:	Server:
Limitations:	Comments:

Files/Graphics attachments (if applicable): Code:
---------------------------------------------------------------------------- FILE: Linking a Parent to a Response UPDATED: June 1996 AUTHOR: Eric Koeler mailto:ekoeler@panix.com http://www.panix.com/~ekoeler NOTE: Copyright (C) 1997 by Eric Koeler, this file is protected by the GNU General Public License ----------------------------------------------------------------------------

Since every response document contains a field called $ref with its parent's Doc ID in it, you can set up a hidden view of response documents (No Response Hierarchy) with @Text($ref) as the first sorted column's formula - we'll call this view (ResponseLookupView) and this first sorted column Key. We can use this $ref field as a common unique lookup key. Create a computed text field in the response document, call it myID, with @DocumentUniqueID as the formula. Now create a computed text or a computed for display field in the parent document, we'll call it respLink, with the following formula:

@DbLookup("";"";"(ResponseLookupView)"; @Text(@DocumentUniqueID);"myID")

This respLink field will yield a doclink to the response document.