Skip to main content
Question

How to get the data from a summary field and populate a formula field

  • July 24, 2018
  • 0 replies
  • 61 views
I have summary fields that need to be color coded.  I am thinking I need to create a formula rich-text field and have the formula read for it to equal whatever value is in the other field, then create a <div> tag to add a background-color:blue tag.  I just am not sure on the equals the other value syntax.  
    This topic has been closed for replies.

    QuickBaseJunkie
    Forum|alt.badge.img+15
    Yep, you'll need a formula rich text field. You then just insert your summary field into the middle of the div as such.

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

    Here are more details https://help.quickbase.com/user-assistance/color_field.html

    If you need it to change dynamically based on the field value here is another example:

    Case([Priority],
    "Urgent", "<div style=\"color:white; background-color:#FF0000;\">[Priority]</div>", 
    "High","<div style=\"background-color:#FF6666;\">[Priority]</div>", 
    "Medium", "<div style=\"background-color:#FF9999;\">[Priority]</div>", 
    "Low","<div style=\"background-color:#FFCCCC;\">[Priority]</div>", "")
    • CasieMasters
    • Author
    • Quickbase Alumni
    • July 25, 2018
    Thank You!  How do I get the formula field to get the value from the summary field to populate though?  Then I can hide the summary field and just have my report populate my colored (formula) fields. 
    Terms & ConditionsAccessibility statement