Data Format - Hypertext link
657094Mar 11 2009 — edited Mar 13 2009Is it possible to format a column as a hypertext link but pull the url from a different column? for example I have a 2 column table, column 1 is the name of an XLS file I have saved on the file system of the server column 2 is a URL link to the spreadsheet. I would rather not render the URL link column in the Answers Report. I would like to be able to render the spreadsheet column that has a hypertext link to the address in column 2. If that is not possible I would like to be able to change column 2 from showing the URL to static text like "Click Here". I tried using the Custom Text Format option using the html that you see(grayed out) when you choose Hypertext Link @[html]"<a href=""@H"">"@"</a>" then changing it to @[html]"<a href=""@H"">"Click Here"</a>" but the link doesn't work. Is there a way to do this either with what I have described or with some other approach?