2 Replies Latest reply on Nov 19, 2013 8:10 AM by TomHays

    Text Formatting vs. Conditional Formatting

    deninger

      I am in the process of creating a table that would essentially act as a preferences file for my DB. In the table I have defined fields like

       

      Category (either DRUG or DISEASE) and

      Familly (Depends on the category selected above)

       

      That part is quite easy. Where I am interested in input is the other field:

       

      Color (would be defined as either the color in word form or a html sytle #color)

       

      The idea is to allow the user to define the color a given object has when formatted in the user interface. In other words, If the user wants a file related to DIABETES (a CATEGORY of DISEASE and FAMILY of DIABETES) to have the text colored BLUE, they can define it in the preference. (and so on and so forth)

       

      I don't find any good way to link this type of preference to the Contidional Formatting field options. I can hard-code the conditional formatting based on the preference, but then it comes back to development when they want a color change.

       

      SO...

       

      Is there a way to apply the formatting to a field outside of the conditional formatting

       

      AND...

       

      Is there a way to use a color picker to show the color in a Preferences Layout

       

      Regards,

       

      Mike