Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1131
  • Last Modified:

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.
0
PachecoPrimo
Asked:
PachecoPrimo
  • 2
1 Solution
 
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
 
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now