BBCode [URL used with formula

Support
1

Can you constuct a BBCode [URL using a formula?
I want the link text to be Clcik Here but then the href like should be a value made using a formula.

I want this listed as a column in a list of records people can click on so an action button where you need to be inside the record.

Thanks

2

Hi,

Not quite sure that you mean but it’s supported to use string formulas to construct a BBCode. For example:
%E5%9C%96%E7%89%87
Note: A4 would the field that contains the link.

If this is not what you’re looking for, please share an actual example for us to refer to.

3

Thanks I tried that but it does not seem to work.
"[url=https://www.test.com/search/results/all/?keywords="+A3+"&origin=GLOBAL_SEARCH_HEADER]Click[/url]"

Thanks

4

I found the problem, if A3 has spaces in it then the link will not work you have to use SUBSTITUTE(A3,' ', '%20')

Hope that helps someone else.