Pop up window from table home to preview record

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>"

Thank you for a quick reply Mark...couple of follow up questions:

1 - you state that this would be a mirror of a current field, not sure what that means or how to create (other than duplicating the field), but;

2 - you state to start with a "totally normal hyperlink", but if the field I chose to mirror isn't a link field do I then convert it to one?

3 - assuming I need to change the "24" in the provided sample to the number of the popup report I created (a=q&qid=24).

4 - assuming that " & [Mstyle]" refers to ID of the record in my table.

5 - assuming that all fields in the "List" portion would need to be updated to reflect fields in my table.

Other than #1, I created a new url field using the following code:

var text Words = "Preview";
var text URL = URLRoot() & "db/" & [_DBID_ASSETS] & "?a=q&qid=3&nv=1&v0=" & [Record ID#];
var text Hyperlink = "<a href=" & $URL & ">" & $Words &  "</a>";

var text HoverWords = "Preview" &  
List("\n",
List(" ", [Asset Type], ToText([Record ID#])),
List(" ", [Model], [Serial Number]), [Manufacturer])
& "'";

"<div>" & "<span title=" & $HoverWords & ">" & $Hyperlink & "</b></span>" & "<div>"

I indicated the field should display as a button and open as a popup. Added the field to my report, when clicked, I do get a popup but it is blank.

So making these changes, the link now works, but it doesn't open as a popup it goes directly to the record view (same experience if I would have clicked on the "eye" icon).

You can force a new Tab with this change to the hyperlink

var text Hyperlink = "<a href=" & $URL & " target=_blank" & ">" & $Words &  "</a>";

I was thinking that you don't need a small popup as the user has a Preview.

There is probably extra syntax for that which I don't have handy.

I'm not following, the user does not have a Preview...that is what I am trying to build. For each record in my Assets table, I'd like to have a button or link that when clicked or hovered over (I don't care which) would display only a few of the records details fields (Type, Model, Year). What I do care about is that this information be presented in a small popup window. I do not want it to open in a separate tab or even full screen.

If possible, I'd also like that popup window to have a link or button that would then open the full detail for that record.

My first attempt resulted in creating the popup window, but it was blank.

The second attempt resulted with the link opening record in view form (not the summary I was seeking).

This syntax worked for me for a popup.  The user would use the native browser options, for example on Chrome the green circle icon to make the pop up full size.

var text Words = "Preview";
var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
var text Hyperlink = "<a class='OpenAsPopup' data-height=400 data-width=400 href='" & $URL & "'>" & $Words & "</a>";

var text HoverWords = "Preview" &  

List(" ", "hello", ToText([Record ID#]))

& "'";

"<div>" & "<span title=" & $HoverWords & ">" & $Hyperlink & "</b></span>" & "<div>"