Maarten Witberg Posted April 10, 2005 Share Posted April 10, 2005 posted in answer to this it shows how to make text or text background change color in a pre-7 situation. kjoe sample in post #6! Link to comment Share on other sites More sharing options...
CobaltSky Posted April 23, 2005 Share Posted April 23, 2005 Hi kjoe, Seems to me that it would make sense to post a comment on the original thread with a pointer to here, for the benefit of those who may be searching the archives? Cheers, Link to comment Share on other sites More sharing options...
Maarten Witberg Posted April 27, 2005 Author Share Posted April 27, 2005 Did too, Ray! kjoe Link to comment Share on other sites More sharing options...
Leoff Posted July 18, 2005 Share Posted July 18, 2005 ...will this work as well in FM7? Or, do you have other suggestions? I KNOW we have easier choices for text coloring in 7... Link to comment Share on other sites More sharing options...
Robert Schaub Posted July 18, 2005 Share Posted July 18, 2005 7 has it own commands to change text colors Link to comment Share on other sites More sharing options...
Maarten Witberg Posted July 24, 2005 Author Share Posted July 24, 2005 [ QUOTE ] 7 has it own commands to change text colors [/quote ] but not, afaik, to change background colors. kjoe edit: here's the sample again (got lost after site upgrade) Link to comment Share on other sites More sharing options...
cir1842eal Posted January 25, 2007 Share Posted January 25, 2007 For V7 and up, you can use the text color command to change the background by creating a text field and superimposing it on the field that you are putting the data into. Then, define the text field as:the following calculation: TextColor(TextFont("gg"; "Webdings");RGB(R;G;B)) where R,G,and B are the RBG numbers (decimal) for the color you want. Then, set up a table (or an if statement in each of the R,G,B fields) that sets the numbers where you want them for the appropriate response. For example, if the response was "Behind Schedule" and you want it marked in red, then R=255, G=0, B=0. You could set up a table that is related to your main table based on the response and store the RGB values there. The text field can be set to any text on the layout (the calculation overrides it). You can set the font size to whatever you want (300 gives a nice BIG box) Link to comment Share on other sites More sharing options...
cir1842eal Posted January 25, 2007 Share Posted January 25, 2007 Oh, and if the field is not wide enough for you, just add more g's in the "gg" part of the calculation. Link to comment Share on other sites More sharing options...
HexxaBubba Posted February 16, 2007 Share Posted February 16, 2007 I am trying to find demo file for 5 & 6 that shows you how to change colors for certain field values. Can anyone please send to me. Link to comment Share on other sites More sharing options...
Maarten Witberg Posted February 16, 2007 Author Share Posted February 16, 2007 it's in post #6. You have to upgrade your membership to download. Link to comment Share on other sites More sharing options...
aaa Posted February 16, 2007 Share Posted February 16, 2007 Sorry, friends! I little edited this example for background color choosing. This works on PC, i dont know for MAC. Link to comment Share on other sites More sharing options...
HexxaBubba Posted February 16, 2007 Share Posted February 16, 2007 I thought I knew something about FMP until I started working with color. I have a simple call sheet (viewed as list) with Date, Time, Name, Number, etc. I want to create band of colors depending on stus of call. I have a call status field which has a value list of "To Call", "Left Word", "Connect", "To Schedule", and "follow up". I simply would like to have entire background of record green when staus="to call", red when status="Left Word", blue when status="connect", gray when staus="to schedule", yellow when status="follow up" this may seem simple to others but this is killing me..any butt simple instructions or samples would be appreciated. I have paid for subscription to this site; but it doesn't allow me to download files yet. i have contacted TS and am waiting for them to fix my subscription. Link to comment Share on other sites More sharing options...
Maarten Witberg Posted February 16, 2007 Author Share Posted February 16, 2007 I have paid for subscription to this site; you're still registered as a guest member. In the moderator control panel, you also show up as such. I am afraid something has gone amiss. Are you sure payment has come through? i have contacted TS who's TS? After you respond, I'll contact the admin Link to comment Share on other sites More sharing options...
HexxaBubba Posted February 16, 2007 Share Posted February 16, 2007 i did upgrade (paid); and i still can't download. Link to comment Share on other sites More sharing options...
Maarten Witberg Posted February 16, 2007 Author Share Posted February 16, 2007 The issue should be resolved now. thank you for joining. Link to comment Share on other sites More sharing options...
Rigel Posted February 26, 2007 Share Posted February 26, 2007 I thought I knew something about FMP until I started working with color. I have a simple call sheet (viewed as list) with Date, Time, Name, Number, etc. I want to create band of colors depending on stus of call. I have a call status field which has a value list of "To Call", "Left Word", "Connect", "To Schedule", and "follow up". I simply would like to have entire background of record green when staus="to call", red when status="Left Word", blue when status="connect", gray when staus="to schedule", yellow when status="follow up" . Anyway, can someone solve this? I’m in a same situation. I need to change a color in an automatic way and I cant figure it out. Hope someone can give us a hand. Plzzzz Cheers Link to comment Share on other sites More sharing options...
J Wenmeekers Posted February 26, 2007 Share Posted February 26, 2007 Basically you need somewhere in a table a global repeat containerfield with all the needed colors. In the table where you want the colorband, create a calculationfield, result container with a Case() statement refering to your requirements. Something like : Case( yourField = "To Call";yourTable::globalrepeatcontainerfield;1 ) If you're in version lower 7, use GetRepetitioin(yourTable::globalrepeatcontainerfield;1) This will give you the color from the first repeat in the global repeat containerfield. Extend the Case() with the other requirements. Put the containerfield on the layout as background band for one or several fields. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.