2 Replies Latest reply on Jun 1, 2010 9:23 PM by techprodave_1

    Conditional Formatting

    techprodave_1

      Title

      Conditional Formatting

      Post

      I have a database I'd like to set up conditional formatting for.

      I'm using FileMaker 10v3

       

      I have one field (field1) that has a value list of 5 items.

      Another field (field2) that is a calculation field, returning the current date, if any of the items in field1 are checked.

       

      My purpose is to have a field, either field1 or field2 or a new field, if necessary, to become red with white text when it has been 90 Days since field1 was checked.

       

      EXAMPLE SCENARIO

      Record1 (today) field1 has value checked, resulting in current date being set in field2

      Record2 (1 week later) field1 is unchecked, but I need field2 to carry forward the date previously set in Record1 (perhaps this is best done in a portal with a self-joining relationship?)

      Record3....and each record forward would be the same as Record2

      But at some point, 90 Days have elapsed and I want to be alerted by field1 or field2 turning red with white text.

       

      So, ultimately I want to show a date in field2 when field1 has a value checked.

      In subsequent records, I want to refer to that date to calculate the number of days that have elapsed.

      And when 90 days have elapsed, I want conditional formatting to change field1 or field2 or a new field (if that is what is necessary) to show as Red with White text.

       

      What I think is giving me grief, is how to carry forward a date that is placed by a calculation in field2, from record to record.

       

      Thank you, in advance, for any assistance...

      David S


        • 1. Re: Conditional Formatting
          philmodjunk

          A self join could be the simplest possibility here to set up.

           

          However, you appear to have one date field that applies to a group of records, that suggests you might set up a table of related records with one record in this table for each such group of records. You could put your date field in this table and all your records in your current table could link to it.

          • 2. Re: Conditional Formatting
            techprodave_1

            Of course, it is frequently said, "this forum rocks". Phil was the only respondent and quickly pointed me in the right direction.

            Thank you so very much. It took me a couple more hours, including the following documentation, which I'm happy to share in case someone else needs the help.

             

            /Users/dstark/Dropbox/Conditional Formatting Example.jpg

            Thanks.

            David S