ContributionsMost RecentMost LikesSolutionsRe: color coding - multiple types of fieldsThanks! Works perfectly! ------------------------------ Ashley Gwozdz ------------------------------ Re: color coding - multiple types of fieldsI read somewhere that the topmost color should take precedence, and they are listed in order of importance. This is how it was working for me before (when all four fields were checkboxes). I was using this code before: Case(true, [Checkbox Field 1],"#f0f0f0", [Checkbox Field 2],"#dbfffd", [Checkbox Field 3],"#ffebbf", [Checkbox Field 4], "#ffffbf" ) ------------------------------ Ashley Gwozdz ------------------------------ color coding - multiple types of fieldsCan anyone help with the following color-coding formula? I couldn't find an example in the help guide of different types of fields in one formula. The first field is multiple choice and I only want to color code one of the three choices, otherwise, no color. The next three fields are checkboxes and I want to color code if true, otherwise, no color. I am getting an error only on the closing parentheses that says "expecting text but found bool". We would prefer to color code the entire record row for easy identification, which is why I am trying to do this from the Default report settings, but if there is another way, I would be glad to know it. Thanks! Case( [Multiple Choice Field], "Option2", "#f0f0f0", [Checkbox Field 1], "true", "#dbfffd", [Checkbox Field 2], "true", "#ffebbf", [Checkbox Field 3], "true", "#ffffbf", ) ------------------------------ Ashley Gwozdz ------------------------------ Re: Color coding single fieldthanks for pointing me to this help file. I was able to get just what I wanted! ------------------------------ Ashley Gwozdz ------------------------------ Color coding single fieldI am curious if there is a way to color code a single field instead of an entire row in a report with the color-coding formula, or if there is a way to do it via the field itself. The field is a multiple choice type currently, so each choice would be a different color. Thank you ------------------------------ Ashley Gwozdz ------------------------------ Re: Sorting by date with empty datesOh, I've got it working now. Thanks Mark!! ------------------------------ Ashley Gwozdz ------------------------------ Re: Sorting by date with empty datesThanks so much Mark! I am getting an error on this code. Is there something missing? "Expecting text but found date" ------------------------------ Ashley Gwozdz ------------------------------ Sorting by date with empty dates The current sort for my report is by date, newest to oldest, and grouped by day. The default seems to be that if the date field is empty, this record shows at the very bottom of the report. Is there a way to get the records with empty dates to show at the top of the report instead? ------------------------------ Ashley Gwozdz ------------------------------ Re: Multi Select Date & TextThank you so much - this sounds very good. I'll follow up once I've got it all set up. ------------------------------ Ashley Gwozdz ------------------------------ Re: Multi Select Date & TextThe user wants to record the announcement date associated with the parent record, but states that sometimes there are multiple announcements for that record, along with notes for each announcement date and would like to record each time that occurs. Is a child table the best way to do this? ------------------------------ Ashley Gwozdz ------------------------------