Solved

FM - Followup to Audit Trail Custom Function Solution

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

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

Title # Comments Views Activity
FMP auto filed input? 3 130
FM - Sorting Titles 5 71
Filemaker - Access data/file from Client on shared windows drive 7 80
change filemaker server web direct port 1 170
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
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 video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

791 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