Hyperlink in a Rich Text Formula
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 h...
Forum Discussion
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
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