Using HMTL to modify text fields
Hi there I'm trying to get creative with some text fields. But, my HTML syntax is not right, because it's not working. It's applying the first item in my span style tag but ignoring the rest. This ...
Forum Discussion
Hi Jemma,
Is this your formula pulled directly out of your rich text formula field? If so there is some syntax that helps you get your formatting for a rich text formula to work in Quickbase. You want to wrap your style tags in quotation marks and then you need to connect your text together for the formula using Ampersands(&). Then you want to make sure you escape any extra quotation marks that appear in your styling so for example you could set your formula out like this:
This identifies the various parts of your formula as what is for the Quickbase formula to read and what should be read by the user, etc.
------------------------------
Evan Martinez
------------------------------
Is this your formula pulled directly out of your rich text formula field? If so there is some syntax that helps you get your formatting for a rich text formula to work in Quickbase. You want to wrap your style tags in quotation marks and then you need to connect your text together for the formula using Ampersands(&). Then you want to make sure you escape any extra quotation marks that appear in your styling so for example you could set your formula out like this:
"<span style=\"color:#FBFBFB;background-color:#563D82;font-size=20px\">" & "Quoted" & "</span>"This identifies the various parts of your formula as what is for the Quickbase formula to read and what should be read by the user, etc.
------------------------------
Evan Martinez
------------------------------
Perfect, thanks Evan Martinez
------------------------------
Jemma
Data Analyst & Visualisation
United Kingdom
------------------------------
------------------------------
Jemma
Data Analyst & Visualisation
United Kingdom
------------------------------
