Does jmp allow the contents of a cell to be a hyperlinkIs it possible in jmp to make the contents of a cell a hyperlink such that when a user clicks on a cell it can open the hyperlink?
Re: Does jmp allow the contents of a cell to be a hyperlinkThank you Craig. I will give that a try. 
Re: Does jmp allow the contents of a cell to be a hyperlinkNot skilled with excel, but https://superuser.com/questions/580387/how-to-turn-plain-text-links-into-hyperlinks-in-excel has a bunch of ideas.
Re: Does jmp allow the contents of a cell to be a hyperlinkAgain thanks for the example. I was able to implement it and get it to work on my data table. However, if I want to export the file to Excel, the links are not kept as part of the cell format. Do you know if there is a way to preserve the links when saving in Excel format?
Thank you!
Re: Does jmp allow the contents of a cell to be a hyperlinkThanks so much for the example. This helps me understand how the event handler works. -Jens
Re: Does jmp allow the contents of a cell to be a hyperlinkThere are a few things that would help illustrate this concept: - I'll add notes to the data table column headers to make it clear what each column demonstrates. - The help topic (https://www.jmp.com/support/help/en/15.0/?os=win&source=application#page/jmp/add-hyperlinks-to-text-columns.shtml) needs to explain Craige's point -- that it's helpful to study the Event Handler script in the UI. Sheila LoringRe: Does jmp allow the contents of a cell to be a hyperlinkAttached is the simple 2 row data table you asked for
Re: Does jmp allow the contents of a cell to be a hyperlinkCheck out this sample table that ships with JMP.
sas offices.jmp in the sample data foldersas offices.jmp in the sample data foldersas offices.jmp in the sample data folder
It might not be obvious, but the pictures have links as well. You can use the red triangle to save the script (perhaps without row data!) to see how you might script it. It is easier to use the GUI to study the Event Handler script. This example has slightly more complicated scripts to drive the google maps. @sheila_loring
Re: Does jmp allow the contents of a cell to be a hyperlinkIs there a example that can demonstrate this in a simpler way? The example in the guide appears very complicated. Can someone provide a simple JSL example of just a column with two rows, where there is a hyperlink in each of the two rows?
Re: Does jmp allow the contents of a cell to be a hyperlinkIt is new in JMP 14. As @Mark_Bailey alludes, it can be done with Expression columns but it's quite a hack and not as useful as what's in JMP 14.
Re: Does jmp allow the contents of a cell to be a hyperlinkThanks so much everybody. Is this a feature only in JMP 14, or can I do it in JMP 13? I am currently using JMP 13.
Re: Does jmp allow the contents of a cell to be a hyperlinkHi @jrphage,
If you are using JMP 14 you can set it with a column property entitled event handler.
Books-->Scripting Guide and search for event handler.
"...You can define a text column as a column of hyperlinks using the Event Handler column property. For example, you can create a column of geographical data as links to a Google map, or you might want to include links to a Wikipedia web pages..."
Re: Does jmp allow the contents of a cell to be a hyperlinkI admit that I saw this feature introduced a long time ago but I have not used it myself since that time. Perhaps another user will help at this point with an example or further explanation.
Re: Does jmp allow the contents of a cell to be a hyperlinkI am sorry. That change is necessary but not sufficient. With the new Expression data type, you also have to add associated Expression Role column property to indicate how the data in this column is to be used. The four roles that are available are Picture, Matrix, Expression, and Picture Expression. There is also the Event Handler column property, which is what I think you need to specify the action associated with a hyperlink. This is what the Using JMP guide has to say about the Event Handler property:
Use the Event Handler column property to define hyperlinks in a text column. The hyperlinks can be used to open web pages and other documents. Add the Event Handler to a column of URLs to open the URLs in a browser. (Hyperlinks to web pages in the text column must include “www”.) You can also modify the placeholder scripts on the column property to open different kinds of resources. For example, in a data table of geographical data, you might edit the Click script to display a Google map when the user clicks the hyperlink in the data table. The SAS Offices.jmp sample data table provides examples.
Re: Does jmp allow the contents of a cell to be a hyperlinkSure. JMP 14 added the Event Handler Column Property.
If your column is the URL you want to open on a Click then just add the Event Handler property and the default Click script will open that URL in your web browser.
Alternatively, if you want to make something else clickable, you can build the URL out of information in your table and use that as the argument to the Web() function in the Click script.
Event handlers can do a lot more than just hyperlinks. I'll try to expand on them in a blog post soon.
Re: Does jmp allow the contents of a cell to be a hyperlinkThanks so much! So if I change the column info as you suggested and then add something like "http://www.jmp.com" to the contents of the cell, it should then treat that cell as a hyperlink? I have tried that and it doesn't seem to be working.
Re: Does jmp allow the contents of a cell to be a hyperlinkSelect the data column. Select Cols menu > Column Info. Change the Data Type attribute to Expression.
