Discussions

 View Only
  • 1.  How do you highlight a field based on text value?

    Posted 10-12-2017 14:44
    I have a table with requests for an Audit. I have a column with QB Status as the title and the field either says Open, In Progress, or Closed. 

    I want Open to be highlighted in a light green, In Progress to be highlighted in a light yellow, and Closed to be highlighted in a light red. I have tried some formulas but I am very new to QB so I have not had much experience with syntax errors. 

    Here is an example of a formula I tried:

    If([QB Status]="Open", "<div style=\"background-color:green;\"> Open</div>", [QB Status] )

    Can someone please help me with a formula? Thanks!


  • 2.  RE: How do you highlight a field based on text value?

    Posted 10-12-2017 14:55

    See if you like this a little better:

    If([qb status]="Open", "<div style=\"width:70px;padding:3px;background-color:green;color:white\"> Open</div>", [qb status] )




  • 3.  RE: How do you highlight a field based on text value?

    Posted 10-12-2017 15:00
    I'm still not seeing any change, but I didn't get any syntax errors. 

    I am currently in my Report Settings and I clicked Highlight Records based on criteria and inputted that formula.

    Should I be doing this on a different page? 


  • 4.  RE: How do you highlight a field based on text value?

    Posted 10-12-2017 15:02
    OOHH, I made a formula field. I had assumed you were on a form.


  • 5.  RE: How do you highlight a field based on text value?

    Posted 10-12-2017 15:04

    In the report settings, use this syntax for highlighting a row:

    if ([Priority] = "High", "pink", "")
    You can use hex code for color if you want to, "#cc66cc", etc.



  • 6.  RE: How do you highlight a field based on text value?

    Posted 10-12-2017 15:05
    Looks like I am in the wrong, then. I want to only highlight the "QB Status" field in the report, not the entire row. Where do I input a formula in the form settings?


  • 7.  RE: How do you highlight a field based on text value?

    Posted 10-12-2017 15:08

    So click on the table tab where you want to create a new field. Then click "Settings" at the far left underneath the table name.

    On the next page, select "Fields".

    On the Fields page, click the green button, "+New Fields"

    You want to create a formula text field.

    Paste in the code provided, check box the option to allow HTML.

    Click SAVE.

    Insert your new field into the report.

    HTML will not export to csv.