Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

FM - Auditing Feature?

Posted on 2014-01-07
8
511 Views
Last Modified: 2014-01-08
Boss wants an auditing trail in Filemaker.  A one step history is easy with the auto enter modification data and account name, but he would like to keep track for several changes.  How would you do that?  Would you create a series of set fields and copy field4 to field5, then field3 to field4 and so on?
0
Comment
Question by:rvfowler2
  • 4
  • 4
8 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39762608
I've used Nightwing's SuperLog Audit System (in various incarnations) with great success. It's been extremely helpful. The only issue I've encountered with it is if you have a very large number of fields marked for auditing, it can significantly slow down imports.

http://www.nightwing.com.au/FileMaker/demos8/demo809.html
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 39762692
Looks interesteing, but they provide no instructions whatsoever.  Assuming you install this on the server and that it is an AddOn, but some instructions would be nice.
0
 
LVL 25

Assisted Solution

by:Will Loving
Will Loving earned 500 total points
ID: 39762746
It's really very straightforward. You simply import the three Custom Functions: SuperLog, ScriptLog and PrepLog. Then you add an Audit field (they call it "Data_Log") to each table that you want to track and populate the Auto-Enter Calculation with the SuperLog () function and any fields you want to be tracking.

To display the results, I usually create a separate layout with just the Data_Log field on it and a "Close" button. The user displays the layout via a script linked to either a button or a menu item. You can just copy the field from the demo if you want. Be aware that the nice column spacing in the demo is achieved by applying tab formatting to the field.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 2

Author Comment

by:rvfowler2
ID: 39765894
I'll test it.  The only problem if I understand this correctly is that it tracks per field when we are really interesed in any change someone makes on the record, though I suppose we could emphasize key fields that a mistake in which would cause the most problems.
0
 
LVL 25

Expert Comment

by:Will Loving
ID: 39765918
You can list as few or as many fields as you want. Many fields are not likely to require monitoring, but you might be able to modify the Custom Function to monitor for any change in the record. Probably easier though to just specify the key data fields.
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 39765931
Also, the auto-enter text is as follows.  Do I have to create a 2nd repetition for each field or is TheText[2] simply an example of a second field you would use?

SuperLog ( Data_log ; TheText & TheText[2] & TheNumber & TheDate & TheTime )
0
 
LVL 25

Expert Comment

by:Will Loving
ID: 39766264
TheText is a repeating field; in the Demo it's used for First and Last name. In the Auto-Enter calculation TheText traps for changes to the first repetition, TheText[2] traps for changes to the second repetition of the field.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 39766277
Thanks, Wll.  Works well in testing.  Notice that it shows results per record.  Tried using an X relationshi and putting it in a Footer or Grand Trailing Summary, but wouldn't show results.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question