Using current row field data in List Hyperlink row action

Confluence User - 11 Sep, 2024

I have a List and a hyperlink action in each row. I need to append in the URL of the hyperlink the content of the current record column. Or alternatively to use the "Hyperlink Parameters" feature using the desire column but with the ability to append a predefined string. Can this be done using hash variable?

datalists

7


12 Sep, 2024
confluenceUser
confluenceUser

That's right. By using the "hyperlink parameter". Can't use hash variable because the context is the entire list, and not individual row.

12 Sep, 2024
confluenceUser
confluenceUser

So there is no way to get the value of a cell of the current row. But the problem is that I need the URL to be dynamic adding each time the value of a desired column in a predefined URL like:

mailto:email1@example.com

mailto:email2@example.com

mailto:email3@example.com

Using the "hyperlink parameter" is not an option to produce this pattern. The result will be:

 mailto:?email=email1@example.com

12 Sep, 2024
confluenceUser
confluenceUser

Another example:

http://www.example.com/#section1

http://www.example.com/#section2

http://www.example.com/#section3

In this case the base URL is the http://www.example.com/#. And the value of the "section" column will be added in the base URL.

12 Sep, 2024
confluenceUser
confluenceUser

Another example (in a situation that you have registered the tel: scheme-protocol to a phone application to make calls through web page as click to call):

tel:#0987654321

tel:#1234567890

tel:#2345678901


"tel:#" will be put in the hyperlink target and the data of the phone column will be added.

12 Sep, 2024
confluenceUser
confluenceUser

I am curious if I can create a calculated list column instead of using hyperlink action. 

13 Sep, 2024
confluenceUser
confluenceUser

I tried to use database query as List's datasource to have the ability to create an extra calculated column (SELECT *, CONCAT('<a "href=base URI",columnName' FROM formtable)) in which I build the link. But if you use some protocol other than http or mailto as the base URI the joget removes all the href when the page is displayed!!!

13 Sep, 2024
confluenceUser
confluenceUser

For those interested. The solution is simple and is to use this: {column_id}

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print