How to color/highlight report rows to display resource overlap?

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
I am building a resource planning tool and I am trying to build a color row if formula for displaying overlap.  For instance, if Resource A is booked date/time that conflicts with another assignment then it would highlight the instances. The below example displays Instructor Name and the overlap would identify for overlaps in Start Date and End Date.  The actual build would be a Date/Time field. 



Any thoughts?
Photo of Kyle Neathery

Kyle Neathery

  • 150 Points 100 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
That particular "class" of problem is very difficult to solve with native Quick Base.  You would probably need a solution involving script.  ie contract for some some development work if the issue is important enough for you to need to solve.
Photo of Kyle Neathery

Kyle Neathery

  • 150 Points 100 badge 2x thumb
Makes sense! What if its not as dramatic as coloring the rows, but a notification or a value change if there is an overlap
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
It is detecting the overlap which is the challenge, and not what you do nonce you detect the overlap.  So  triggering a Notification instead of row colourization does not simplify the issue.

It is possible to prevent duplicates, if that helps, such as the same Instructor for the same Start Date (for a different course).