Solved

FM - Followup to Audit Trail Custom Function Solution

Posted on 2014-01-10
2
415 Views
Last Modified: 2014-01-10
The Superlog Audit Trail solution works great.  Followup questions:

1. Is there a way to display changes to all records in one field in a Foolter or Trailing Grand Summary.  Would I just create another field and use the List() function?
2. If you incude a lot of fields in the Data-log field, the text can grow exponeentially.  Do you have any script that periodically clears this field or better yet, one that can clear all entries past a certain number (say 100)?
0
Comment
Question by:rvfowler2
[X]
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
2 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39771848
1) I suppose you could use a self-join for all records and then use the List() function to concatenate the values for display in a Footer or Trailing Grand Summary, but that could be a huge list depending on the number of records and number of fields being monitored.

2) To limit a list to a certain number of lines, you can use the LeftValues() function. It works just like Left() except that it counts values in a List (meaning carriage returns) instead of characters. You could build this into the Auto-Enter if you wanted or make it part of a script.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 39772191
LeftValues().  Haven't used that one yet.  Thanks for the tip.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

733 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