Color Coding Fields: Duration
I want to color code a field within a report, but the field is a Duration Type. Currently I am color coding within the report instead of just the field, but it's too much color and doesn't convey wha...
Forum Discussion
Thanks Mark! This is really helpful. I am now receiving an error due to the <div> expecting a different type, but if I remove the ToText to keep the type expectancy, then I get a different error:
Error: Expecting duration but found text.
Error: Expecting text but found datetime
------------------------------
Elizabeth Schlagel
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThe field type needs ot be Rich Text, not Duration.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
That worked! Now how do I get it to still do the original formula I needed it to do to should # of days between the timestamp and today. Now that I switched it to this formula, the color coding works, but it shows me the timestamp and not the number of days.
------------------------------
Elizabeth Schlagel
------------------------------This is what the report looks like now:
------------------------------
Elizabeth Schlagel
------------------------------- MarkShnier__You
You will need to have two separate fields. One field will be the actual duration field. The other field will be the rich text representation of that field which is a formula.
Unlike Excel where you can use cell colorization rules in QuickBase you actually need to have a completely separate field which just looks like your numeric or duration field but is in fact a Rich Text text field.
So far any calculations or totals you need your original field but on certain reports you can use the colorized text field. Of course the colorized text field won't support any totals or anything like that.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Awesome!! You are helping me learn so much. So now that's working, but it's in the wrong format since it flipped it to text format. Can I multiply/divide the result to get it back to 'days'?
------------------------------
Elizabeth Schlagel
------------------------------