Expand all | Collapse all

Color Coding Timeline

  • 1.  Color Coding Timeline

    Posted 06-26-2019 12:50
    I would like to add some color coding to the timeline but do not see an option in the timeline builder to do it.  Is there a way?

    We have a master Gantt chart prepopulated with tasks for the entire project.  I have a task status as Future, In Progress, Complete.  I want the future tasks to be gray in font color so they are present but not in your phase.  Anything overdue I want to color code as red.  

    If I cant do this I might need to switch to a table report, but I would prefer a Gantt chart.  Just helps visualize the impact of future tasks with delays for my team.

  • 2.  RE: Color Coding Timeline

    Posted 07-16-2019 17:01
    Hi Ivan, I haven't found a way to change the color of the font or the bars in a Timeline report. On my Task Timeline report, I used a Status Icon field to show a visual indication of the status of the Task. My Status Icon field is called S (so it takes up very little column space) and is a Rich Text field that displays a 16x16 image based on the Status and the due date. I'll post the code and a screenshot in a bit.

  • 3.  RE: Color Coding Timeline

    Posted 07-16-2019 21:32

  • 4.  RE: Color Coding Timeline

    Posted 07-16-2019 21:43
    In case you like this idea, here's the code of the Rich Text formula field called S.

    //This field takes the info in the Status, Overdue, and Needed fields and uses it to display a status bubble. The images are stored in the Images table of this Quick Base app. Red Square = Overdue, Yellow Square = Due Today, Gray Square = Due Later, Blue Circle = In Progress, Explosion = Issue, Gray X = Canceled, Blue Checkmark = Complete
    var text status=[Status];
    var text due=[Overdue];
    var bool needed=[Needed];

    If($needed=true and $status="Not Started" and $due="Overdue", "<img src=\"theURLofTheImageIsHere/due.png\">";,
    If($needed=true and $status="Not Started" and $due="Due Today", "<img src=\"theURLofTheImageIsHere/duetod.png\">";,
    If($needed=true and $status="In Progress", "<img src=\"theURLofTheImageIsHere/doing2.png\">";,
    If($needed=true and $status="Issue", "<img src=\"theURLofTheImageIsHere/issue1.png\">";,
    If($needed=true and $status="Not Started", "<img src=\"theURLofTheImageIsHere/needed.png\">";,
    If($status="Complete", "<img src=\"theURLofTheImageIsHere/done.png\">";,
    If($status="Canceled", "<img src=\"theURLofTheImageIsHere/x.png\">";,

    Also, I hear that several Quick Base Solution Providers offer an add on that allows you to customize gantt charts.

  • 5.  RE: Color Coding Timeline

    Posted 07-19-2019 01:21
    Awesome idea, thanks so much for posting the code!

  • 6.  RE: Color Coding Timeline

    Posted 07-19-2019 22:37
    You're welcome... Quick Base Junkie.com has it fully documented in case you need more info...

    YouTube link: https://www.youtube.com/watch?v=bcDYn64J4bQ
    Blog link: https://www.quickbasejunkie.com/blog/how-to-icons