Discussions

Expand all | Collapse all

I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

  • 1.  I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

     
    Posted 03-12-2019 19:32


  • 2.  RE: I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

    Posted 03-13-2019 22:04
    There's several options to create  color coding.  Make sure you've selected the formula option in the report settings. From there you can enter a formula base on a field such as:
    Case([Active Month],"April","#7FE2EA", "January","#f69100")
    If you don't see that option, check to see what kind of report your trying to colorize. For instance, you won't have the colorizing option in Summary Reports.
    Jake Rattner | Solutions Architect (847) 927-1427 | jrattner@quandarycg.com
    Quandary Knowledge Base


  • 3.  RE: I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

     
    Posted 03-13-2019 23:04
    Thanks Jake,
    I am using a Table Report and I do click on the formula button but the formula box does not come up, nothing happens.  I have some old table reports that have colorization in them and when I customize the report the formula box is not there.  When I quit the coloring remain even thought I did not see the formula.  However, if I save after entering the customize report the coloring is gone.  Something is inter-fearing with the colorization box displaying.  I have had someone from quickbase look at it and they created a bug ticket to try to resolve it.
    Rob 


  • 4.  RE: I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

    Posted 03-13-2019 23:08
    Hi Rob, 

    Sorry to hear you've encountered a bug.  Sounds frustrating.  Thanks for getting back to me to let me know the cause.  What happens if you rebuild the report from scratch?  I'm wondering if there is something about the old reports that is triggering the bug.  Curious to know if rebuilding resolves the issue.

    Jake Rattner | Solutions Architect
    (847) 927-1427 | jrattner@quandarycg.com
    Quandary Knowledge Base


  • 5.  RE: I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

     
    Posted 03-13-2019 23:26
    Jake,
    Good thought.  Unfortunately, I tried to rebuild the report and am not presented with the formula box when clicking on the radial button.
    Rob


  • 6.  RE: I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

     
    Posted 03-25-2019 18:52
    Does anyone know if there is a resolution to this problem?  Neil Beschle?



  • 7.  RE: I am not presented the formula box when trying to color a row in reports. Does color have to be turned on?

     
    Posted 03-25-2019 18:53
    Does anyone know if there is a resolution to this problem?  Neil Beschle?