topic Re: Does jmp allow the contents of a cell to be a hyperlink in Discussions

Does jmp allow the contents of a cell to be a hyperlink

jrphage — Thu, 10 May 2018 17:39:47 GMT

Is 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 hyperlink

Mark_Bailey — Thu, 10 May 2018 17:44:37 GMT

Select the data column. Select Cols menu > Column Info. Change the Data Type attribute to Expression.

Re: Does jmp allow the contents of a cell to be a hyperlink

jrphage — Thu, 10 May 2018 17:51:01 GMT

Thanks 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 hyperlink

Jeff_Perkinson — Thu, 10 May 2018 18:07:37 GMT

Sure. 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 hyperlink

Mark_Bailey — Thu, 10 May 2018 18:11:53 GMT

I 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 hyperlink

Mark_Bailey — Thu, 10 May 2018 18:09:43 GMT

I 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 hyperlink

stan_koprowski — Thu, 10 May 2018 18:13:53 GMT

Hi @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 hyperlink

jrphage — Thu, 10 May 2018 18:16:29 GMT

Thanks 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 hyperlink

Jeff_Perkinson — Thu, 10 May 2018 18:18:40 GMT

It 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 hyperlink

JensRiege — Tue, 12 Nov 2019 23:25:24 GMT

Is 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 hyperlink

Craige_Hales — Wed, 13 Nov 2019 02:01:40 GMT

Check out this sample table that ships with JMP.

sas 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 hyperlink

txnelson — Wed, 13 Nov 2019 03:15:26 GMT

Attached is the simple 2 row data table you asked for

Re: Does jmp allow the contents of a cell to be a hyperlink

sheila_loring — Wed, 13 Nov 2019 23:39:34 GMT

There 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 Loring

Re: Does jmp allow the contents of a cell to be a hyperlink

JensRiege — Tue, 08 Dec 2020 20:42:09 GMT

Thanks 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 hyperlink

JensRiege — Tue, 08 Dec 2020 21:17:56 GMT

Again 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 hyperlink

Craige_Hales — Tue, 08 Dec 2020 22:40:21 GMT

Not 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 hyperlink

JensRiege — Thu, 17 Dec 2020 21:04:50 GMT

Thank you Craig. I will give that a try. :)