It's possible use TextColor ( text ; RGB ( red ; green ; blue ) ) within SetField in script.
The possibility to have FillColor ( text ; RGB ( red ; green ; blue ) ) within SetField in script would be very much appreciated.
Here are some Product Idea threads that discuss possible improvements to layout_object formatting... Use styles and/or full inspector for conditional formattinghttps://community.filemaker.com/ideas/1124 Conditional Formatting move to Inspector and add stateshttps://community.filemaker.com/ideas/1230 Conditional formatting with formatting formulas instead of fixed formattingshttps://community.filemaker.com/ideas/1553 Lots of choices to consider. Tony White
My problem is, that these solutions always work with hard coded fill colors.
I want the customer to be able to set the colors he wants for a certain group.
The color is saved in 3 integer values (R, G and B value).
Afaik it isn't possible to have a variable color setting in Conditional Formatting.
See the discussion Scripts: Why is it still not possible to set fill color?, that I started a few weeks ago.
All (nice) workarounds, but coloring the background of a field by using field values (still) isn't possible.
paulsondervan you should vote up your own idea.
I do not see this as something I would like my users to be able to do in my solutions. That would change my design so that colors might interfere with what is most important on each layout.
It has nothing to do with the change of a design.
There are certain groups and the customer wants to label these groups with a color.
Each color stands for a certain group.
When they see the color, they immediately know to what group it belongs.
I would like to make it possible for the customer to define the color for each group the way he wants it to be.
Only a small field on the screen will have that color the rest of the design is the same design as used in all other screens.
Since you ask your users to enter a RGB number, they need to know what that means. If I needed that kind of solution I would give users a Value List of Colors and then have a System table with the different values as containers. Then I can have a Calculated field on the records show the container depending on what was chosen in the Value List
Nope, the customer selects a color by using a color picker and I store the chosen color as RGB in the corresponding record.
Then I would suggest you did like I wrote above with containers in your System table and Calculated fields on your records
This would be fantastic. I am in the exact same situation as paulsondervan. I need to dynamically set fill colors for specific groups. I would personally prefer hexadecimal over RGB, but either would work.
I don't believe this would interfere with design in the slightest. Sure, designers could make poor decisions that would than lead to bad designs, but if applied appropriately, it would ultimately make solutions much more powerful and user friendly.
Retrieving data ...