Single vs doule quotes in RIch Text Formulas
Is there an easy explanation for how/when to use double quotes vs single quotes in Formula Rich Text fields? Or are there too many possibilities and it is something I will need to find an entire w...
Forum Discussion
Double quotes are used with you start and stop a 'literal'. Essentially, when you're telling the formula to use this piece of information exactly. Single quotes are used when you need to insert certain parts of code within that literal. For example, you want to setup a link to some website. The URL is www.my-website.com.
In a RT Formula, you would do this:
"<a href='www.my-website.com'>Click ME</a>"
Another example. You want to write a message in Comic Sans font that includes the status of a record. For this, you would do something like this:
"<span style='font-family:Comic_Sans'>Status: " & [Status] & "</span"
Normally, you would write it as:
<span style="font-family:Comic_Sans">
But, since the formula requires the use of double quotes to use code, the interior double quotes get changed to single quotes.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
In a RT Formula, you would do this:
"<a href='www.my-website.com'>Click ME</a>"
Another example. You want to write a message in Comic Sans font that includes the status of a record. For this, you would do something like this:
"<span style='font-family:Comic_Sans'>Status: " & [Status] & "</span"
Normally, you would write it as:
<span style="font-family:Comic_Sans">
But, since the formula requires the use of double quotes to use code, the interior double quotes get changed to single quotes.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- Good explanation, thanks!
------------------------------
Mike Tamoush
------------------------------ - Hello, I am trying to use rowspan into my HTML table created using Rich Text - Formula field. Kindly guide as to how I could use it in Quickbase for data to not repeat in the cells below.
Here is the code i have used to collect data in a table format,
And further more to repeat it one after the other.
------------------------------
Amedha Surve
------------------------------
------------------------------
Rasika Bhosle
------------------------------- This really isn't related to the original question and I would suggest posting this as a new topic so that your question will be seen by more users.
------------------------------
Blake Harrison
bharrison@datablender.io
/
------------------------------
