- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Create HTML table with hyperlinks
Thank you. It doesn't seems to work on JMP14, I will try it tomorrow on JMP16.