Skip to main content
Question

Sort by Color Coding

  • May 3, 2019
  • 0 replies
  • 70 views

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.

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