Clearing a calculation field containing a custom function.

[Bob Kerr]

Hello All,

I just started playing around with custom functions and I found this one for logging every change made. Sorry if this was the wrong place to post this thread.

http://www.filemakermagazine.com/videos/super-audit-logging.html

First, is there an easier way to do this?

Second, everything works as it should, I then use a script to open another file to store all the data and organize it, which all works fine.

The problem I have is that I am trying save space in the live database (the one containing the log function). After I export the data I would like to clear the logs in the main file.

FileMaker will not allow me to do this, because the field is not modifiable.

Is there any way to do such a thing?

Thanks in advance for the help,

Bob

[Bob Kerr]

anyone?

[Fitch]

The audit log is typically implemented using a text field, which auto-enters the calculated log info. A text field can be cleared out with a simple Replace command.