Hi all, I've been searching but can't find any tips on this.

I want to do a file for booking conferencerooms, and my idea is to have a matrix where the rows are each room and the columns are dates. The matrix should consist of the rooms and, say, 7 days including the start date.

When I want to check the availability I should enter a date in a search field and the "availability-matrix" will be filled in with info about each conferenceroom.

Heres the snag; I want the corresponding field to be green if the conferenceroom is available and red if it is not available, all depending on if there is a reservation done in the "reservations"-table.

Is there a way to change the background color of a field in a script?

Regards

/U

Like this? See attachment.

Color.zip

Exactly like that, thanks a million!

Think about the hours that I've been trying to find a solution when I could have got the answer on this forum within an hour.

/Ulf

Only thing thoug is that it isn't particular network friendly, globals are stored locally and the data in the base is located at serverside ...the fact that it's a graphical objects doesn't help either. The same thing could be said about graduations (eyecandy) in your layouts ...you could be tempted to do it in Photoshop or similar. But to filemaker is it much faster to recieve the message over network "draw a line from here to there" eventhough the candy perhaps is build up by lots of lines.

This tip might not seem faster to render, but is much more network savy:

Use the char "g" or rather a sting of "g"'s and make a mergefield to show it inside the frame of the field.

Why do I choose this particular char, because it's in the font webding makes a solid bar sans kerning out of a string of the char.

Under FM7 would I use the Textformatting functions, but in previous versions would I have made a unbroken string of calcfields, where each part in the mergefield sequence recieves a different colour.

Now a tip about mergefields is that only the type/style/textcolour from the first "<" char of each merge field is needed ...this is important when moving around with webdings ...to avoid to get confused by sequences of pictograms.

--sd