cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
ileshem
Level III

Create HTML table with hyperlinks

Hello,

I have a data table, one of the column values has values with hyperlink, I used "event handler" to create it.
I am trying to export it to an Interactive HTML report but when I do, I loose the hyperlink and get only the values.

Is there any way to get HTML with working hyperlinks?

jrnl=dt<<journal;
zippy=current journal();
zippy<<Save Interactive HTML ("\\Temp\Tasks.HTML");

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Create HTML table with hyperlinks

Maybe journal breaks them as this seems to work (using JMP16)

Names Default To Here(1);
//Making a clickable link show up in a formula column
dt = New Table("Example",
	Add Rows(2),
	New Column("URL",
		"Character",
		"Nominal",
		Formula("https://www.jmp.com/" || :Page),
		Set Property(
			"Event Handler",
			Event Handler(Click(JSL Quote( Function( {dt, col, row}, Web( dt:col[row] ) ) )))
		)
	),
	New Column("Page",
		"Character",
		"Nominal",
		Set Values({"support/knowledge_base.shtml", "en_us/about.html"})
	)
);

(dt << get as report) << Save Interactive HTML("$DOWNLOADS/test.html");
Web("$DOWNLOADS/test.html");

other method which might not be necessary anymore Insert Hyperlink in Text in the cells 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: Create HTML table with hyperlinks

Maybe journal breaks them as this seems to work (using JMP16)

Names Default To Here(1);
//Making a clickable link show up in a formula column
dt = New Table("Example",
	Add Rows(2),
	New Column("URL",
		"Character",
		"Nominal",
		Formula("https://www.jmp.com/" || :Page),
		Set Property(
			"Event Handler",
			Event Handler(Click(JSL Quote( Function( {dt, col, row}, Web( dt:col[row] ) ) )))
		)
	),
	New Column("Page",
		"Character",
		"Nominal",
		Set Values({"support/knowledge_base.shtml", "en_us/about.html"})
	)
);

(dt << get as report) << Save Interactive HTML("$DOWNLOADS/test.html");
Web("$DOWNLOADS/test.html");

other method which might not be necessary anymore Insert Hyperlink in Text in the cells 

-Jarmo
ileshem
Level III

Re: Create HTML table with hyperlinks

Thank you. It doesn't seems to work on JMP14, I will try it tomorrow on JMP16.