Discussions

Expand all | Collapse all

Sort by Color Coding

  • 1.  Sort by Color Coding

    Bronze
    Contributor
    Posted 05-03-2019 18:24
    I have an embedded report which is set up where if key fields are empty, they will have a red background... I then have JS code which will pop up an alert if red background is present on the page... this works great...

    What I'm being asked by users is if there's a way to have these red background rows automatically at the top of the report.

    From what I can see, QB doesn't have a "Filter/Sort by color" function, like in MS Excel... 

    Any help would be greatly appreciated, and thanks in advance.


  • 2.  RE: Sort by Color Coding

    Bronze
    Contributor
    Posted 05-03-2019 19:58
    Is there anything special about the embedded report beyond your JS code to alert them? Assuming you're just using a standard report link / embedded report - you should be able to sort the report by your key field in order such that those missing will appear on top. 

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base


  • 3.  RE: Sort by Color Coding

    Bronze
    Contributor
    Posted 05-06-2019 12:55
    That would work, except that the color coding searches for more than one column... So I can't just set the default sort to that column.


  • 4.  RE: Sort by Color Coding

    Bronze
    Contributor
    Posted 05-06-2019 13:01
    My recommendation would be to make a new formula that mimics the logic in your color coding - and then use that as the sort for your report. So if your report has 3 colors lets say - make this formula field calculate 1, 2, 3 etc, and sort by that.

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base


  • 5.  RE: Sort by Color Coding

    Bronze
    Contributor
    Posted 05-06-2019 13:06
    I'll give that a shot... sort of a round about way of doing it... but if it works... then it works.