Milestone Summary
This may be something solved with non-native solutions or it could be my Friday brain, but I can't figure this one out. I have a Projects table that has four different duration fields (PDR, DDR, CDR,...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou will need to use a table report type and based on formulas calculate the appearance of the circles and what colour they are.
For the columns (fields) you will need to have a set up fields labels such as
[CM] (meaning Current Month)
[CM+1] (meaning Current Month plus 1 (ie Next Month)
[CM+2] (meaning Current Month plus 2 ie Next Next month)
If you go that route and want the month names to be more user friendly, ou can use a Pipiline set to un each o nth to rename the fields using an API.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
For the columns (fields) you will need to have a set up fields labels such as
[CM] (meaning Current Month)
[CM+1] (meaning Current Month plus 1 (ie Next Month)
[CM+2] (meaning Current Month plus 2 ie Next Next month)
If you go that route and want the month names to be more user friendly, ou can use a Pipiline set to un each o nth to rename the fields using an API.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------