Solved

FM - Followup to Audit Trail Custom Function Solution

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 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

23 Experts available now in Live!

Get 1:1 Help Now