Hi Team,
Could you please give me some ideas on how make my url clickable.
I have on my report from google docs set like this
And my output is like this:
It appears as text. This happened after I set the ifblank function, and although I set the Linktext still is not working.
The data type is set as URL.
Solved! Go to Solution.
Oh, okay. Please try,
<<IFS(ISBLANK ([URL]), "SIN ADJUNTO" )>>
<<IFS(ISNOTBLANK ([URL]), HYPERLI K([URL], "VER ADJUNTO" ))>>
Please insert both the above expressions in place of existing single expression under the heading ADJUNTOS
See if you have a Format Rule applied to that column
There is not format rule, in the sheet doc they are display as url indeed.
I have also tried using HYPERLINK like this:
<<IF(ISBLANK([URL]), “SIN ADJUNTO”, (HYPERLINK(“VER ADJUNTO”, [URL])))>><<End>>
But still is not showing the text as a clickable link
Por favor comparte una captura de la configuración de la columna [URL]
I have nothing configured in the column, my config is in the template doc.
Here is the config
Here is my template:
The idea is that when I add an URL, in my report there is a clickable link, but if I do not have an URL, the word "SIN ADJUNTOS" may be shown.
Here is my output, the IF and ISBLANK is working fine, but the clickable link isn't working.
From the various screenshots shared by you, it sounds that your HYPELINK() expression needs revision. You have placed the link text " VER ADJUNTO" first before the [URL], the HYPELINK() function's syntax needs the text after the URL
Thanks for your reply. Yes, yesterday I also realized of that, and although I change the order, still having the same output.
Oh, okay. Please try,
<<IFS(ISBLANK ([URL]), "SIN ADJUNTO" )>>
<<IFS(ISNOTBLANK ([URL]), HYPERLI K([URL], "VER ADJUNTO" ))>>
Please insert both the above expressions in place of existing single expression under the heading ADJUNTOS
Thank you! It worked!
You are welcome. Nice to know it works as per requirement. If I may mention, with IF() statement, the hyperlink was getting converted to a text value because the first result of IF () was a text. Hence suggested to use IFS(), thereby separating the results of two different types- text and URL.
Understood!
Also, for reference:
I think template IF are the best tool for the job when it comes to templates.
Considering @Suvrutt_Gurjar's reply, something like:
<<IF:ISBLANK([URL])>>SIN ADJUNTO<<EndIf>>
<<IF:ISNOTBLANK([URL])>><<HYPERLINK([URL], "VER ADJUNTO"))>><<EndIf>>
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |