4 Replies Latest reply on Jan 25, 2012 2:05 PM by Mike_Mitchell

    When is a field changed?

    hagtunerik

      Hello

      Is there a way I can see when a field is last changed? I want to make a conditional formatting rule based on when a separate field is changed.

       

      Best

      Erik H

        • 1. Re: When is a field changed?
          Mike_Mitchell

          Well, one way is to create a separate timestamp field that has this as an auto-enter calculation:

           

          Case ( IsEmpty ( YourField ) ; Get ( CurrentTimestamp ) ; not IsEmpty ( YourField ) ; Get ( CurrentTimestamp ))

           

          and set it to override its contents (i.e. uncheck the box that says, "Do not replace existing value of field (if any)"). This way, whenever the contents of "YourField" change, then the other field will reset itself to the current date and time.

           

          There's probably a more elegant way to do it, but this will work.

           

          HTH

           

          Mike

          1 of 1 people found this helpful
          • 2. Re: When is a field changed?

            I would suggest using a calculation (result is timestamp) as:

             

            Let ( trigger = yourField ;

            Get ( CurrentTimeStamp )

            )

             

            Because you are referencing your field within the calculation, it will automatically update the timestamp when the data in your field changes.

            1 of 1 people found this helpful
            • 3. Re: When is a field changed?
              hagtunerik

              Thank you Mike.

              I was wondering about a GET function but this was a nice solution. I try it in my FM base tomorrow. 

               

              Have a nice day

               

              Here is almost night.

               

              Erik H

              Norway

              • 4. Re: When is a field changed?
                Mike_Mitchell

                Ah, yes. Much better. Thanks.

                 

                Mike