Help with Clickable Link in PDF Template

[Quality_Assuran]

From the expression assistant

HYPERLINK(CONCATENATE("https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-3102900&group=%5B%5D&page=detail&row=",ENCODEURL([MinutesID]),”&sort=%5B%5D&table=”,ENCODEURL("Minutes"),”&view=”,ENCODEURL(”Minutes_Detail”)),”CLICK LINK HERE”)

In the PDF

HYPERLINK(CONCATENATE("https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-3102900&group=%5B%5D&page=detail&row=",ENCODEURL([MinutesID]),”&sort=%5B%5D&table=”,ENCODEURL("Minutes"),”&view=”,ENCODEURL(”Minutes_Detail”)),”CLICK LINK HERE”)

In the PDF

<<HYPERLINK(CONCATENATE("https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-3102900&group=%5B%5D&page=detail&row=",ENCODEURL([MinutesID]),”&sort=%5B%5D&table=”,ENCODEURL("Minutes"),”&view=”,ENCODEURL(”Minutes_Detail”)),”CLICK LINK HERE”)>>

Where I am trying to go

https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-3102900&group=%5B%5D&page=detail&row=2ee0a4ee&sort=%5B%5D&table=Minutes&view=Minutes_Detail

Hi, I am trying to create a "Click Here" link in my PDF template as per a post I saw @Steve create, which I can't find now, because I didn't bookmark it.

I posted it into the Expression assistant to check that it was working, which it says it is but when I click the link in the PDF I get a 404 Page not found

From the expression assistant

HYPERLINK(CONCATENATE("https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-31029...detail&row=",ENCODEURL([MinutesID]),”&sort=%5B%5D&table=”,ENCODEURL("Minutes"),”&view=”,ENCODEURL(”Minutes_Detail”)),”CLICK LINK HERE”)

In the PDF

HYPERLINK(CONCATENATE("https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-31029...detail&row=",ENCODEURL([MinutesID]),”&sort=%5B%5D&table=”,ENCODEURL("Minutes"),”&view=”,ENCODEURL(”Minutes_Detail”)),”CLICK LINK HERE”)

In the PDF

<<HYPERLINK(CONCATENATE("https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-31029...detail&row=",ENCODEURL([MinutesID]),”&sort=%5B%5D&table=”,ENCODEURL("Minutes"),”&view=”,ENCODEURL(”Minutes_Detail”)),”CLICK LINK HERE”)>>

Where I am trying to go

https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450#appName=OperationalMinutes-31029...

I cannot see my error, can anyone else?

Apologies, I see it is trying to make hyperlinks in my post, not sure how to overcome this so you can see this as normal text?

[SkrOYC]

---

@Quality_Assuran wrote:

Apologies, I see it is trying to make hyperlinks in my post, not sure how to overcome this so you can see this as normal text?

---

[Quality_Assuran]

Thanks @SkrOYC.

[SkrOYC · Accepted solution]

Try this one:

HYPERLINK(
 CONCATENATE(
  "https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450",
  LINKTOROW(
   [MinutesID],
   "Minutes_Detail"
  )
 ),
 "Click here"
)

[Quality_Assuran]

Awesome! Thank you!

[Quality_Assuran]

Hello @SkrOYC I hope you are doing well.

I am still trying to wrap my head around this so I would like to find out,

<<HYPERLINK(CONCATENATE("https://www.appsheet.com/start/5a6050f0-254b-4ab7-a6e5-93ee700c2050",LINKTOROW([Personal_ID],"Personnel_Detail")),"Click here")>>

I utilised this in another app, but this time not in the template, but in the email body.

And while it returns the correct link, it doesn't show "Click Here"

https://www.appsheet.com/start/5a6050f0-254b-4ab7-a6e5-93ee700c2050#control=Personnel_Detail&row=f1569d70 

is what it returns.

Why is that?

[SkrOYC]

Should work the same way because the AppSheet backend makes sure that the hyperlink is created and inserted.

You are using the same expression, right?

[Jared12345]

It's not the identical one you first shared because I want to point it to a different place, but it's the one I shared above. 

It created a link but doesn't show "Click here".

Shows the link. 

I tried to delete all the spaces in case that was the problem but didn't make a difference