3 Replies Latest reply on Sep 12, 2013 1:12 PM by philmodjunk

    Conditional formatting

    groenlykke

      Title

      Conditional formatting

      Post

           I have a ordinary text field that I want to make a bolean value. So that I can write a text and have my note tab colored. 

           How do I do that.

            

           Rasmus

      Sk%C3%A6rmbillede_2013-09-12_kl._21.55.45.png

        • 1. Re: Conditional formatting
          philmodjunk

               Create two conditional format expressions one for each color. Specify the desired fill color that you want when that specfic expression is true.

               So maybe your field, LayoutTableOccurrence::Color should cause the tab panel to be Red when the text "red" is entered into the color field. If so, use this expression:

               LayoutTableOccurrence::Color = "red"

               and specify a red fill color.

               Then you could create a second conditional format with this expression:

               LayoutTableOccurrence::Color = "blue"

               And specify a blue color for the tab panel's fill color.

          • 2. Re: Conditional formatting
            groenlykke

                 The thing is that I need to convert text in my two text fields to a boolean value so conditional formating understand that there is a value in my two text fields. How?

            • 3. Re: Conditional formatting
              philmodjunk

                   You do not need to do any such thing.

                   My examples did not do any such conversion. They just compared the contents of the text field to text in quotes. I used "Red" and "blue" as my quoted text simply as an example. I could have set the conditional formats to change the color for any text that works for what I am trying to do with that text field.