Changing Object Colors

[Nathaniel Brockmann]

I'm VERY new to FileMaker scripting so I may say ignorant things. If I do, I'm sorry in advance...

I'm trying to work on a scheduling database for our office where our order clerks insert orders into the database throughout the day (in one FM view) and then (in another FM list view) as the projects progress from waiting to working to complete the background color of the database entry changes from red to yellow to green...

Basically if I have 10 orders showing I want to be able to click the 'waiting" button on 5 of them so that they will show red, the "working" button on 3 of them so that they will show yellow, and the complete button on 2 of them so that they will show green. Kind of like an Airport flight status board.

Does anyone have any ideas for a new person.

Thanks if you do, Nathaniel.

[Fenton]

You want a global field, type container, with a few repetitions. Draw a colored rectangle, line none, in Layout mode. Copy it. Switch to Browse mode. Paste into repetition 1. Switch to Layout mode. Change the rectangle color. Repeat for each repetition needed.

Do this on a "Graphics" layout (leave the colored rectangles next to the reps, so you can quickly replace after Cloning wipes them out; or put all graphics in a "one-record" Constant-related file.).

Field with status (waiting, working, etc.) is Status.

Global field is named _gRowback.

Calculation field is named _cgRowback =

Case ( Status = "waiting", _gRowback,

Status = "working", Get Repetition (_gRowback, 2),

Status = "waiting", Get Repetition (_gRowback, 3),

Status = "completed", Get Repetition (_gRowback, 4),

"")

_cgRowback is non-enterable on the layout, at the back. Its fill is transparent, with borders set to all, but line none (allows fill to completely fill its space). Graphic options are Reduce or Expand, no proportions.