Forum Discussion
BlakeHarrison
5 years agoQrew Captain
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/
------------------------------
- MichaelTamoush5 years agoQrew CaptainGood explanation, thanks!
------------------------------
Mike Tamoush
------------------------------ - RasikaBhosle4 years agoQrew MemberHello, 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
------------------------------- BlakeHarrison4 years agoQrew CaptainThis 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
/
------------------------------