Capture who last changed when was last changed record ?

[Jaidee]

DaDaBIK version 11.9-Elba enterprise, installed on 06-28-2023
PHP Version: 7.4.33
mysql version: 8.0.31
Web server: Apache/2.4.54 (Win64) PHP/7.4.33

Opposed to creator and registration date tat is explained very well in CRM video.
Question is, today, I create 2 new fields Who Last Modifier (of existing record ) and When was last modified
How do I do that ? Any help please
How can I capture this Thanks in advance.

 

[juergen_mueller]

You can enable revision for every table allowing you to view who entered or modified a record including date and time - see screen shot attached..

I just noted, this is for DadaBIK Platinum only. You are on Enterprise version.

PS: you could also enable the $enable_sql_logging parameter (line 1026 in the config.php) in order to record updates and inserts