Solved

FM - Followup to Audit Trail Custom Function Solution

Posted on 2014-01-10
2
411 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
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

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…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

823 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