Hyperlink in a Rich Text Formula

Question

Hi,I am trying to create a rich text field that based on certain data either returns a plain text message or a hyperlink that is grabbed from another URL field on the same table. Below is what I have so far, but the Hyperlink though displaying correctly in the output is getting an error message when I click on it. I can confirm that the URL is correct though as it works when I click on it in the URL field.&nbsp;&nbsp;var text URLWords=ToText([URL Field])var text URL="&lt;a href="&amp;[URL Field]&amp;"&gt;"&amp;$URLWords&amp;"&lt;/a&gt;";If([FileAttached]=true, "File Attached",$URL)Below is a pic of the error message I am receiving. Any help would be appreciated!&nbsp;

chayceduncan2 · Answer

Try wrapping your href in single quotes&nbsp;HTML elements and their components need to be in quotes so the browser knows the difference.So:var text URL="&lt;a href='"&amp;[URL Field]&amp;"'&gt;"&amp;$URLWords&amp;"&lt;/a&gt;";for spacing so you can see where the single quotes are - dont use the belowvar text URL="&lt;a href=' "&amp;[URL Field]&amp;" '&gt;"&amp;$URLWords&amp;"&lt;/a&gt;"; Chayce Duncan | Director of Strategic Solutions (720) 739-1406 | chayceduncan@quandarycg.com Quandary Knowledge Base

coleenschmitt1 · Answer

No luck, still returning the same result. Could it be something with needing to the http:// in the rich text formula?

using google.com as an example the URL field is returning http://www.google.com, but the rich text field is only returning www.google.com

chayceduncan2 · Answer

I tested it per your comment - looks like you do need the https:// in front in order for Quick Base to not interpret it as a link to itself. Maybe add something like

var text urlH = if( not contains([URL Field]),"https://" & [URL Field],[URL Field]);

Then use that $urlH in place of [URL field] in your <a> tag. Depending on your workflow - you might always consider throwing a target='_blank' in your <a> - this way it opens this link in a new tab instead of the same window - unless that is the intent.

So: <a href='url' target='_blank'>Link Text</a>

Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

coleenschmitt1 · Answer

Even when I use a var text to add the http:// before the URL i'm still getting same error (QB does not recognize the link) which is frustrating because the link is the exact same to what is showing in the URL field (as seen in screenshot below).

The only way that seems to actually be working is when i type the exact URL into the a=href formula (ie. var text URL="<a href=' "www.google.com"'&"; '>"&$URLWords&"</a>"; Unfortunately that wont work for me since the URL is always going to be different.

any other ideas? If not i have appreciated your help and speedy responses regardless!

adamkeever1 · Answer

Do you need to use ToText() for your URL field so that is interpreted in the rich text field?

Forum Discussion

Hyperlink in a Rich Text Formula

Related Content

Rich-text formula button on dashboard

Hyperlink in Rich text formula

Adding an email hyperlink to body of formula-url

Rich Text Button with rounded edge

Formula Rich Text Button: Report Link