Forum Discussion
I think you might love this. The idea is to create a mirror field for one of you fields on the report even if the words are called "Preview". Then if you hover the mouse, the user gets a preview and can click to open the record or right click to open in a new tab or the hyperlink could be changed to always open in a new tab.
// first start with a totally normal hyperlink
var text Words = "Preview";
var text URL = URLRoot() & "db/" & [_DBID_ORDERS___SHIPMENTS] & "?a=q&qid=24&nv=1&v0=" & [Mstyle];
var text Hyperlink = "<a href=" & $URL & ">" & $Words & "</a>";
// then define the hover text
// Note!!, the hover text must be enclosed in a single ' character as the first space will stop the text.
// no html allowed in the hover text
// Use \n for line feed
var text HoverWords = "'" &
List("\n",
List(" ", [Customer Name], ToText([Acct #])),
List(" ", [Mstyle], [Cust SKU #]), [Description],
"Qty Ord: " & [Ord Qty],
[Strt Ship (text format)])
& "'";
// this will be Standard from the above
"<div>" & "<span title=" & $HoverWords & ">" & $Hyperlink & "</b></span>" & "<div>"