Forum Discussion

ChinmayDhandhan's avatar
ChinmayDhandhan
Qrew Trainee
8 years ago

Red Amber Green Status based on other fields - Please help

Hi, I have a table called Risk  I want to create 3 Fields - Risk Impact, Risk Probability, and RAG Status as shown below: What should be the field type for Impact and Probability. I...
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    Don't follow the practice of backslash escaping double quotes shown in the help page:

    "<div style=\"background-color:pink;\">"& [Priority] & "</div>"

    Instead save your eyes and use single quotes:

    "<div style='background-color:pink;'>"& [Priority] & "</div>"
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    That was a helpful tip.  I have never understood when to use singe quotes.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    You can also use no quotes if there are no spaces in the attribute value:

    "<div style=background-color:pink;>"& [Priority] & "</div>