2 Replies Latest reply on Jul 14, 2010 7:21 PM by fmdark

    Creating a change log

    fmdark

      Title

      Creating a change log

      Post

      Using Filemaker Pro 11

      I want to include a change log for each entry but I can't seem to figure out how to do that.

      Currently I have a 5 cell table and a script that is triggered when a change is made to the form and if the difference in timestamp is greater than 5 seconds (low to debug).  The "update" runs twice to update the timestamp and current user.
      If the difference in timestamp is greater than 5 seconds, it will rearrange the array
      changelog[5]=changelog[4]
      changelog[4]=changelog[3]
      changelog[3]=changelog[2]
      changelog[2]=changelog[1]

      It works, but the logged changes done beyond the 5 steps would be discarded.

      Would it be possible to create something similar with a portal and a database with the following fields?
      Fields:
      CID (main key), User (current logged in user), Timestamp, and Changes (field names that were altered)

      I imagine the resulting changelog database will end up quite a few entries, so a limit of say 50 and automatic discarding of the oldest date would be an optional but desired feature.

      I am open to suggestions.  Thank you!