Hyperlinks in data table?Hello all,
Is there a way to put web URLs into a table such that they are clickable (i.e. act as hyperlinks)?
We have data tables that are extracts of data from a web-based system. The users would like to be able to click on a row of data in JMP and bring up the page in the web-based system for the "case" that they clicked on.
I know what the URL is supposed to be for each row, and I can simply call web(url) to bring up the page. But, I want the users to have an easy (=transparent) way of drilling down on a particular case.
I think I can do something clever using the approach used by Ian Cox in his neat example from the file exchange called actionOnRowSelect.jrn. The problem is that sometimes the users create distributions from the data and they could click on a distribution bar that represents thousands of rows of data. I don't want to bring up a thousand pages at once - just one.
Thanks,
PeterRe: Hyperlinks in data table?Hyperlink usage in column text is a new feature in JMP 14.0.
You can find more information about here in the JMP 14 Help about Hyperlinks to Text Columns.
Re: Hyperlinks in data table?I think that the principles of Ian's code would be the starting point. The script that is launched could check the number of selected rows, and contain logic to do nothing unless the row launching the script was the first in the list of selected rowsRe: Hyperlinks in data table?OK I'm getting closer. I have a table with a column containing the following formula:
If(Selected(Row State(Row())), Eval(Parse(Web(:Script))))
The Script column contains the URL for each row.
To avoid opening up too many Internet Explorer windows, I'd like to check the number of selected rows and just open up the URL for the first one. The code for that would be something like:
The problem is that I can think of several scenarios where the current data table is not the one containing the web links. For example if you create a summary table that will be linked back to the original table.
How can a formula for a given table determine the number of selected rows it contains?
Thanks,
Peter
