If you were to post the exact calculation used, we could easily tell you. But as is, that would either be the name of a table occurrence--a "box" in the relationship graph or a field. The difference is in syntax not included in your post as it might look like:
Excelissys_ChangeLog::FieldName, in which case, it's a table occurrence.
It might look like:
TableOccurrenceName::Excelissys_ChangeLog, or just Excelissys_ChangeLog and then this is a reference to a field
The exact calculation they used is:
Case ( Modification Timestamp ;
Excelisys_ChangeLog ( Get ( ModifiedFields ) ; Self ) ;
They do not have any other tables or table occurances, their only table is "data" and the only fields in that table are "change log" "first name" "last name" "phone number" "modification timestamp" and "full name"
It looks like it is listed under "functions" in their solution, but I have no idea how to get that function copied to my own solution
It's a custom function. You will not be able to include that in your solution unless you have FileMaker Advanced where you can use Manage | custom functions to include that function in your own solution.
Well that is a bummer. Any ideas on how to get an audit log without using their function?
Frankly, if you are doing something as complex as an audit log, you really need to invest in FileMaker Advanced as it's design tools can save you time, $$ and frustration.
There have been a few discussions of audit logging here in the forum that do not use the above method. They use script triggers to capture the current value of a field OnObjectEnter--using a script paramter to get the value before it changes, but putting the value in a global variable. An OnRecordCommit then creates a record in an AuditLog table and saves the data from the global field into that record before clearing the record. That's only the barest description of a process that builds a return separated list of field names and previous values in one or more global variables. before the commit triggered script saves the data into a change log record.
Okay thank you, that is very helpful. I will invest in filemaker pro advanced.