1 Reply Latest reply on Nov 10, 2013 7:56 PM by davidanders

    Add colors to a report

    JessicaThompson

      Title

      Add colors to a report

      Post

           I'm creating a report that will organize our merchant accounts by their status. I'll have a button with a script that will run the report. What I want to do, is also add colors to the report and this I cannot figure out how to do, although I know it'll be through a script.

           So our merchants will be "submitted," "accepted," "pended," etc., and in the report, I want all of the "submitted" section to look blue, for example, all of the "accepted" rows to be green, "pended" red, etc.

           Any help will be greatly appreciated. Thanks!

        • 1. Re: Add colors to a report
          davidanders

          Home > Designing and creating databases > Editing objects on layouts > Selecting and working with objects on a layout > Defining conditional formatting for layout objects

          http://www.filemaker.com/12help/html/edit_layout.10.17.html

                                                                           
                              
          1.
                         
                              
          In Layout mode, select one or more objects.
                         
                                                                                                               
                                   
          2.
                              
                                   
          Choose Format menu > Conditional.
                              
                                                                                                               
                                   
          3.
                              
                                                        
                                                                                                               
                                   
          4.
                              
                                                        
                                                                           
                              
           •
                         
                              
          To specify a format based on common conditions, for Condition choose Value is. Then choose one of the following conditions and set the parameters.