cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-575924%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%89%B5%E5%BB%BA%E5%B8%B6%E6%9C%89%E8%B6%85%E9%8F%88%E6%8E%A5%E7%9A%84%20HTML%20%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575924%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%EF%BC%8C%3C%2FP%3E%3CP%3E%E6%88%91%E6%9C%89%E4%B8%80%E5%80%8B%E6%95%B8%E6%93%9A%E8%A1%A8%EF%BC%8C%E5%85%B6%E4%B8%AD%E4%B8%80%E5%88%97%E5%80%BC%E5%85%B7%E6%9C%89%E5%B8%B6%E8%B6%85%E9%8F%88%E6%8E%A5%E7%9A%84%E5%80%BC%EF%BC%8C%E6%88%91%E4%BD%BF%E7%94%A8%E2%80%9C%E4%BA%8B%E4%BB%B6%E8%99%95%E7%90%86%E7%A8%8B%E5%BA%8F%E2%80%9D%E4%BE%86%E5%89%B5%E5%BB%BA%E5%AE%83%E3%80%82%3CBR%20%2F%3E%E6%88%91%E6%AD%A3%E5%9C%A8%E5%98%97%E8%A9%A6%E5%B0%87%E5%85%B6%E5%B0%8E%E5%87%BA%E5%88%B0%E4%BA%A4%E4%BA%92%E5%BC%8F%20HTML%20%E5%A0%B1%E5%91%8A%EF%BC%8C%E4%BD%86%E7%95%B6%E6%88%91%E9%80%99%E6%A8%A3%E5%81%9A%E6%99%82%EF%BC%8C%E6%88%91%E5%A4%B1%E5%8E%BB%E4%BA%86%E8%B6%85%E9%8F%88%E6%8E%A5%E4%B8%A6%E5%83%85%E7%8D%B2%E5%BE%97%E4%BA%86%E5%80%BC%E3%80%82%3C%2FP%3E%3CP%3E%E6%9C%89%E4%BB%80%E9%BA%BC%E6%96%B9%E6%B3%95%E5%8F%AF%E4%BB%A5%E7%8D%B2%E5%8F%96%E5%B8%B6%E6%9C%89%E6%9C%89%E6%95%88%E8%B6%85%E9%8F%88%E6%8E%A5%E7%9A%84%20HTML%20%E5%97%8E%EF%BC%9F%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ejrnl%3Ddt%26lt%3B%3CJOURNAL%3E%3C%2FJOURNAL%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-575924%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E5%A4%A7%E8%A6%8F%E6%A8%A1%E5%AE%9A%E5%88%B6%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-575960%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%89%B5%E5%BB%BA%E5%B8%B6%E6%9C%89%E8%B6%85%E9%8F%88%E6%8E%A5%E7%9A%84%20HTML%20%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575960%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%AC%9D%E8%AC%9D%E3%80%82%20%E4%BC%BC%E4%B9%8E%E5%9C%A8%20JMP14%20%E4%B8%8A%E4%B8%8D%E8%B5%B7%E4%BD%9C%E7%94%A8%EF%BC%8C%E6%88%91%E6%98%8E%E5%A4%A9%E5%9C%A8%20JMP16%20%E4%B8%8A%E5%98%97%E8%A9%A6%E4%B8%80%E4%B8%8B%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-575935%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%89%B5%E5%BB%BA%E5%B8%B6%E6%9C%89%E8%B6%85%E9%8F%88%E6%8E%A5%E7%9A%84%20HTML%20%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-575935%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%B9%9F%E8%A8%B1%E6%97%A5%E8%AA%8C%E6%9C%83%E7%A0%B4%E5%A3%9E%E5%AE%83%E5%80%91%EF%BC%8C%E5%9B%A0%E7%82%BA%E9%80%99%E4%BC%BC%E4%B9%8E%E6%9C%89%E6%95%88%EF%BC%88%E4%BD%BF%E7%94%A8%20JMP16%EF%BC%89%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%2F%2FMaking%20a%20clickable%20link%20show%20up%20in%20a%20formula%20column%0Adt%20%3D%20New%20Table(%22Example%22%2C%0A%20Add%20Rows(2)%2C%0A%20New%20Column(%22URL%22%2C%0A%20%20%22Character%22%2C%0A%20%20%22Nominal%22%2C%0A%20%20Formula(%22https%3A%2F%2Fwww.jmp.com%2F%22%20%7C%7C%20%3APage)%2C%0A%20%20Set%20Property(%0A%20%20%20%22Event%20Handler%22%2C%0A%20%20%20Event%20Handler(Click(JSL%20Quote(%20Function(%20%7Bdt%2C%20col%2C%20row%7D%2C%20Web(%20dt%3Acol%5Brow%5D%20)%20)%20)))%0A%20%20)%0A%20)%2C%0A%20New%20Column(%22Page%22%2C%0A%20%20%22Character%22%2C%0A%20%20%22Nominal%22%2C%0A%20%20Set%20Values(%7B%22support%2Fknowledge_base.shtml%22%2C%20%22en_us%2Fabout.html%22%7D)%0A%20)%0A)%3B%0A%0A(dt%20%26lt%3B%26lt%3B%20get%20as%20report)%20%26lt%3B%26lt%3B%20Save%20Interactive%20HTML(%22%24DOWNLOADS%2Ftest.html%22)%3B%0AWeb(%22%24DOWNLOADS%2Ftest.html%22)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E5%85%B6%E4%BB%96%E5%8F%AF%E8%83%BD%E4%B8%8D%E5%86%8D%E9%9C%80%E8%A6%81%E7%9A%84%E6%96%B9%E6%B3%95%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FInsert-Hyperlink-in-Text-in-the-cells%2Fm-p%2F402346%23U402346%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-forum-thread%20lia-fa-icon%20lia-fa-forum%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%E5%9C%A8%E5%96%AE%E5%85%83%E6%A0%BC%E7%9A%84%E6%96%87%E6%9C%AC%E4%B8%AD%E6%8F%92%E5%85%A5%E8%B6%85%E9%8F%88%E6%8E%A5%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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. 

Recommended Articles