Newbies stasker Posted March 27, 2002 Newbies Posted March 27, 2002 Can you create a script to change the format of a field...ie background color/pattern? I want to be able to check a box and if its checked certain fields will become a different color. thanks!
goldraven Posted March 27, 2002 Posted March 27, 2002 Unfortunately there is no "built-in" way to do this in FMP. The common way to handle this is to import a one-pixel image of the color you desire into a global field. Then, create a calculated container field that, if your criteria are met, is equal to that global field. Place that calculated field behind the main field in question and make the main field in question transparent.
Kurt Knippel Posted March 27, 2002 Posted March 27, 2002 A slightly more powerful version of the above suggestion involves a repeating container field (either global or normal placed in a Preferences DB) which contains swatches of various colors and/or other graphics. It then uses calculated "Background" fields to display a particular swatch based on the value in some other field. For example: cBackground = If ( Value1 = "Yes", GetRepetition ( gColorSwatches, 1 ), "" ) This will cause the background field to use the swatch in repetition one. You could then have either a case statement in the cBackground field or use seperate background field for different criteria.
stuj1026 Posted March 28, 2002 Posted March 28, 2002 I tried the second method posted by Goldraven.. It does not seem to work! when the criteria is met I get a one pixel image in the calculated container field as opposed to the color filling the enitre container field.. What am i doing wrong.. Stu
elvis_impersonating_penguin Posted March 28, 2002 Posted March 28, 2002 what you need to do is right click on the container field, choose graphic format. then in the little drop down box, coose Enlarge image to fit frame. That should do it.
Recommended Posts
This topic is 8262 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now