asked on

URL link in a view column which has response docs only to open the parent document

Hi all

1) I have a view that stores response docs only.
2) view has 2 columns,
3) column1 has the description field which is found on response doc
4) column 2, i want to include a text "Click here" where when clicked it will open the associated parent document to this response doc
5) I have place the following behind column 2 to open the document, but it seems to take me back to the response doc instead of the parent

"<td align='left'><a href='test?opendocument&ParentUNID="+@Text(@DocumentUniqueID)+"'>Click Here </a></td>")

That's not working

http://servername/dbname/viewname/documentuniversalid?OpenDocument

Also not working

Your ideas on how to fix this is much appreciated

Varvoura

SOLUTION

madheeswar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Bill-Hanson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

varvoura

ASKER

Bill,

I needed to add the square brackets to your formula and then it worked perfect.

viewName := "Parents";
"[<a href=\"/"+ @WebDbName + "/" + viewName + "/"+@Text($REF)+"?OpenDocument\">Click Here</a>]"

Maddy,

Many thanks for trying to help, I am sure I'll be able to use your formula in various other scenarios

Varvoura