Audit log script

[haani]

Hi Guys, I have created a simple audit log script, just wanted to know how to add parameters to allow capture of field name, old value and new value? script is below.

Show Custom Dialog [ Message: "Reason for this change/new record?"; Default Button: “OK”, Commit: “Yes”; Input #1: Clients::gChangeNote, "Change Log" ]

Freeze Window

Set Variable [ $ID; Value:Clients::ID ]

Go to Layout [ “Audit Log” (Audit Log) ]

New Record/Request

Set Field [ Audit Log::ID; $ID ]

Set Field [ Audit Log::ChangeLog; Clients::gChangeNote ]

Set Field [ Clients::gChangeNote; "" ]

Go to Layout [ original layout ]

[Wim Decorte]

Are you asking how to pass parameters to a script? 

 

For passing parameters, this is a good starting place: http://www.modularfilemaker.org/2013/11/paramconverter/

Know that there are many different ways to do this, you should be able to find many threads on this forum by searching on "script parameters".