Skip to main content
Solved

How can i recreate a link to an external page on a column in a grid?

D
Sidekick
Forum|alt.badge.img+2

Hi,

The idea is the create a link to an external application. Right now this is the table we are using with 2 fields (a lot more, but those are not relevant)

external_invoice_number
external_url

The external_invoice_number is a readonly field
The external_url is a hidden field

I thought of using the Calculation Type: Expression for the external_invoice_number field to create the link, but somehow it is not working (or my code is not correct)


Why is this not working and what is the correct way to create a link? This is the code in the expression

 

​​​​​​​case when t1.external_invoice_number not null and t1.external_url not null then 
        '<a href="' + t1.external_url +'">' + t1.external_invoice_number + '</a>'
     when t1.external_invoice_number not null and t1.external_url is null then
        t1.external_invoice_number
     else
        ''
     end

 

Best answer by Mark Jongeling

Hi Dennis,

I can see you are reusing the text_medium domain. My guess is that the control of the domain is not set to HTML. To use HTML tags such as <a> and showing it nicely as a clickable link, you should use the HTML control. The best is probably to use a new domain with the HTML control

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

5 replies

D
Sidekick
Forum|alt.badge.img+2

Oke i managed to fix it. I forgot the is in the statement. Which is very stupid. But the result is like this:
 


How do i create a good URL? Is there a thinkwise function i should use?

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Mark Jongeling
  • Administrator
  • 3945 replies
  • Answer
  • June 26, 2024

Hi Dennis,

I can see you are reusing the text_medium domain. My guess is that the control of the domain is not set to HTML. To use HTML tags such as <a> and showing it nicely as a clickable link, you should use the HTML control. The best is probably to use a new domain with the HTML control

"Wake me up before you low-code" | On holiday 06-02 till 27-06
D
Sidekick
Forum|alt.badge.img+2

This worked!

P
Captain
Forum|alt.badge.img+3
  • PatrickWCaptain
  • 54 replies
  • June 27, 2024

Why don't you use a domain with the URL control? Then it will automatically create a clickable URL that opens in the browser.

Domains | Thinkwise Documentation (thinkwisesoftware.com)

Edit; I think you want a ‘nice’ looking URL, indeed that won't happen with the URL control because you can't set the value that you want to see (the invoice number in this example)

D
Sidekick
Forum|alt.badge.img+2
PatrickW wrote:

Why don't you use a domain with the URL control? Then it will automatically create a clickable URL that opens in the browser.

Domains | Thinkwise Documentation (thinkwisesoftware.com)

Edit; I think you want a ‘nice’ looking URL, indeed that won't happen with the URL control because you can't set the value that you want to see (the invoice number in this example)

I created a domain called “HTML” with the HTML control indeed. And that turned my code into a clickable nice looking link 

 

 

P
1 person likes this
  • P
    PatrickW
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings