Solved

FM - Followup to Audit Trail Custom Function Solution

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

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now