AnsweredAssumed Answered

How can I store an original value field for audit log purposes?

Question asked by Alejandro Felix on Feb 9, 2018
Latest reply on Feb 10, 2018 by philmodjunk

Having reviewed several methods to create an audit log record, I find that specific types of field styles are difficult to catch the original value of a field. The styles I'm reffering to, are: Drop-down list, pop-up menu, checkbox set, radio button set, and drop-down calendar.

The context is:

I'm using FMP 16 Advanced in a Mac, File is hosted in a FMS 16 Mac server, Script is not running under PSOS yet.

 

The problem is:

Some of the fields that I want to track on an audit log, have some of the styles mentioned above. When you modify the field content using a mouse: selecting from a list, clicking a radio or checklist button, or selecting a date, most of the available script triggers won't run.  I need a script trigger that is executed before the modifying event ocurrs. ¿Any ideas?

 

The best looking option was "On object validate", but it seems not to be working properly. When the script starts running using script debugger, the active field content is not the original, but the modified one.

 

The first step is:

 

Captura de pantalla 2018-02-09 12.24.21.png

Thanks in advance

Outcomes