Hyperlink

[John_Henry_Jose]

I have produced the below Training report where a Certificate is included as a document/field. But I want to make a hyperlink of that Certificate with the "Course Name".

How can I achieve this please?

@Aleksi @Steve @Phil 

Thanks in Advance.

John

[John_Henry_Jose]

I used the below expression but system says "Bad request".

<<IFS
(
ISNOTBLANK
(
[Certificate]
),
HYPERLINK
(
CONCATENATE
(
“https://www.appsheet.com/template/gettablefileurl?appName=",ENCODEURL("TalentManagementSystemv1-575724”),"&tableName=",ENCODEURL(“Tbl_Training”),"&fileName=",ENCODEURL([Certificate])),“Certificate”)
)>>

@Aleksi @Steve @Phil 

[John_Henry_Jose]

@Aleksi Can you please help me out with the hyperlink expression please!!

Thanks.

John

[TeeSee1]

---

@John_Henry_Jose wrote:

ENCODEURL([Certificate])),“Certificate”

---

([Certificate)) <- could this extra ) be the problem?

[John_Henry_Jose]

Thank you so much.

[Aleksi · Accepted solution]

That extra ")" belongs to CONCATENATE. Change this option as OFF and then test it again.. 

[John_Henry_Jose]

Thank you so much Mr. Aleksi.

[Aleksi]

You're welcome!