Jump to content
Salesforce and other SMB Solutions are coming soon. ×



Recommended Posts

I'm a fairly new user to filemaker.


I'm trying to create a database right now and trying to have certain fields store their changes. For instance if their is an account number for a record and then someone changes the number, I want the field to be able to store somewhere, the number that was changed and when. But it has to be able to be retrieveable for reporting purposes and able to keep numerous changes to that field. Basically like storing the history of the field.


Can someone please help!

Link to comment
Share on other sites

Jil, not as easy as one might think. There are many ways to do this, but here is one fairly straightforward approach.


Set up an archive database with fields to match those you want to track.

Create auto enter fields for modification date and current user to track who and when.

Create global fields for data entry of the fields you want to track.

Create "Make Changes" layout(s) which will have the global fields, then create a change script which take the user to this layout. Here you will have a button called Post Change(s).

The user enters the data into the global fields, presses the post button which executes the post change script.


The Post Change Script, will compare the global field against the 'master' field(s) and if different will first create a new record in the archive database, then copy the current data, user, date, time,... to this new archive record, then finally put the data from the global into the 'master' field(s).


Your historical reporting is then based upon the data in the archive database in conjunction with the 'live' database.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use