Filemaker Record Modidified Field

I know you can create a TimeStamp field for record modification. Is there a way to create a field that sets to '1' if the record (any field) has been modified.
I was thinking maybe of a way of utilizing the TimeStamp field when a record is modified.
I do not want to do this using script triggers. I would like to do it using either a auto-enter field or calculation field.
PachecoPrimoAsked:
Who is Participating?
 
Will LovingPresidentCommented:
OK, that a bit different than what you originally asked for. It sounds like you want an audit trail of who modified what when, is that correct. There are a couple of ways to do this:

1) The traditional way is to use a Custom Function (which requires FileMaker Advanced to be installed) and a couple of fields to capture the modifications. There is a detailed description and example file at:  http://www.nightwing.com.au/FileMaker/demosX/demoX01.html

2) A new way, made available recently by the addition of the Get( ModifiedFields ) function in FileMaker 13 is described here: http://www.excelisys.com/blog/2014/06/26/filemaker-pro-13-tip-n-trick-easy-bake-filemaker-pro-13-audit-trail/   This also requires a Custom Function.
0
 
Will LovingPresidentCommented:
You can also create a Timestamp field for record creation, then create a calculation field that compares the Creation Timestamp with the Modification TimeStamp and yields a value of "1".
0
 
PachecoPrimoAuthor Commented:
Hi Will,
The thing is that records will be modified multiple times (for example on a daily basis, weekly basis), so the modify timestamp is going to change multiple times and this is exactly what I need to capture.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.