Is there a way to fill color a field like this:
Each record has a field which defined the color like RGB(12;35;50)
And based on that fields it's value the fill color of the field changes?
Sounds like you will want to check out Conditional Formatting.
Thanks, but that allows you only to formulate way it shows the choose color but does not allow you with the formula to choose its color.
Here is the problem I want to solve.
I have next to each other many different portals and the are all related to each other.
If I can define the fill color by calculation on the field I can create an visual link between the different portals.
If that would work I would create just one field in the background of the others and that field would change its colors.
You might want to consider text color instead of fill color. You could use a calculated version of the field (or an auto-entry calc, if it's okay to color it everywhere to use the TextColor function with RGB. Backgrounds, though, have to be selected from the color picker, unfortunately.
One method is to use a calculated container field that points back to a number of graphic objects with the desired colors in them.
However, this is fairly hefty from the standpoint of bandwidth, so you're likely better off using text color as Chris suggested.
Yes that is a way but then will show every time like that when ever I show the record. That's why I wanted to have one field that has a color.
Yes I was thinking about that to. I'm not so considered about the band width as the color item can be 1 x 1 px and the maximis it on the inspector. But what is tedious is that I have to add for each color an Item.
Is there any way how I can define the color of an object by formula and then display that object. Or create a color jpg which automatically fills the container field with that color object?
Being able to specify the color in conditional formatting through a formula - RGB(r, g, b, t) - instead of choosing a color manually like 30 years ago in MacPaint is something that has been asked for many times.
Or create a color jpg which automatically fills the container field with that color object?
Yes, that is what you do. Put the various colors into a single-record table, populate them as globals using a startup script, and then use the result in the calculation. (This is a calculation field that has a result type of "container".)
What I would do is the following:
Make a table for the colors
Insert records with the name of the color, and the color itself in a container (you might get a long list from the internet)
Make a relationship between your table and the colors table
In your main table, use calculations to set your container to change its color based on a calculation, or even on a lookup
Dear, this is what Mike said and looks like that is what I have to do.
thanks the input on the color table from the web is a good idea.
What is common between me an Mike is doing a table for colors.
Mike then suggested generating globals using a startup script
And this won't be easy if you have many colors, like 50 or more
I was previously using this technique untill I decided to increase my colors number
I suggested using relationship
Here no globals are needed
you could use calculations
Or even easier you good use lookup like I do
Steves advice is the right one. The solution with jpeg's is not practical, although possible.
Conditional formatting is the way to go!
This is true, assuming you have 50 colors. The flip side is a table requires a relationship between where you're displaying the color and the "colors" table, which may or may not be practical, depending on how many places you want to use this technique.