Color Coding Based on Date
Hi, I'm fairly new to using Quickbase and have limited programming knowledge. I'm trying to color code lines in a report by date. I have two fields, "Days Till Closing", and "Est Closing Date". Es...
Forum Discussion
Hi Jared,
If your Days till closing field is the one you want to have control the color coding on your report, and if that field is a Duration field, you probably want a formula like
You would go into the settings for the report you want this colorization to show up on and find the header for Color Coding and select the by formula option, then you can drop your formula into the formula box that will appear. You can also change the number of days by adjusting the number inside the parenthesis after days and you can change the color to any hex code color by changing the number that appears. There are a lot of colors to choose from using hex codes so you can customize to fit your needs but this is just a very basic example colorization formula. You may also need to change the field name to match the actual name of our field.
------------------------------
Evan Martinez
------------------------------
If your Days till closing field is the one you want to have control the color coding on your report, and if that field is a Duration field, you probably want a formula like
If([Days till closing]>=Days(3), "#3cc151",[Days till closing<=Days(2), "#f54400", "")You would go into the settings for the report you want this colorization to show up on and find the header for Color Coding and select the by formula option, then you can drop your formula into the formula box that will appear. You can also change the number of days by adjusting the number inside the parenthesis after days and you can change the color to any hex code color by changing the number that appears. There are a lot of colors to choose from using hex codes so you can customize to fit your needs but this is just a very basic example colorization formula. You may also need to change the field name to match the actual name of our field.
------------------------------
Evan Martinez
------------------------------
