Fill color on same dates?

[nedbguy]

I am not sure if this is where I should post this question but....

I have a script that finds the current events in a db (FM 8.5). Current meaning active events that haven't happened yet. The layout I view these events is in list form and I would like to be able to quickly spot the events that share the same date by having their displayed fields ( Artist, Venue, Start date, End date, and Engineer status) backgrounds change from white to a color.

If anyone here has any ideas on how to do this I'd appreciate it.

Chris

[K1200]

Here's a quick summary of one method:

Define a container field in some system parameter table to hold a swatch of your highlight color (e.g., System::Highlight).

Create a calculated (unstored) container field in your data table to display the field highlight color (or none).

Base its calculation on some indicator that you've set in each record -- something like Case (Indicator = 1 ; System::Highlight ; "" ) -- which will set or clear the color.

On your layout, place the container field (not editable) behind each field you want to highlight. Be sure to set the fill color of the data fields to None so the highlight shows through.

This has been discussed in various ways on these forums so you might want to search for an example file.