coloured records

[pmusaev]

greetings,

is it possible to (based on a script) colour certain records in a portal. ie. if name = "Pall" make this record print out blue and if name = "Jim" print this record in red. cheers!

[Vaughan]

No need for a script. Make a calculation field in the related file that uses a Case function to select the desired background colour. The background colours themselves need to be coloured images in container fields (one of the few instances where repeating fields are very useful).

[ESpringer]

pmusaev,

There are lots of ideas here about this and related things. You might be able to search for some of them...

I started typing, and Vaught beat me ; ) but I'd say if you have various people that you're color-coding, set up (if you don't already have) a file with one record for each person. Add a container field to hold a swatch of each person's color. You should paste the smallest possible swatch so as not to waste memory and processing time, since FileMaker can auto-stretch a graphic.

Then set up a relation between each main record and the record corresponding to the person in question. Now you can put the field with the color swatch into any records that tap this relationship. To use the swatch behind a portal row, you'll actually want to use a calc field in the file that's shown in the portal. So, if your portal shows visits by these various people, have each visit record use the relationship to fill a calc field (container type) with the color swatch.

To fill the row with the color swatch, make sure to stretch the container field to fill the whole area, use the Format>Graphic menu to tell the field to reduce/enlarge to fill available area, without maintaining original proportions, and send the field to the back layer.

[John Caballero]

Have a look at this thread: http://www.fmforums.com/threads/showflat.php?Cat=&Number=87078&page=&view=&sb=5&o=&fpart=all&vc=1

As for printing in color...make sure you have a color printer!