rvfowler2
asked on
FM - Auditing Feature?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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 )
SuperLog ( Data_log ; TheText & TheText[2] & TheNumber & TheDate & TheTime )
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.
ASKER
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.
ASKER