Forum Discussion

Re: Single vs doule quotes in RIch Text Formulas

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/
------------------------------

3 Replies

  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    Good explanation, thanks!

    ------------------------------
    Mike Tamoush
    ------------------------------
  • RasikaBhosle's avatar
    RasikaBhosle
    Qrew Member
    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
    ------------------------------
    • BlakeHarrison's avatar
      BlakeHarrison
      Qrew Captain
      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
      /
      ------------------------------