How to check if records in table was updated

[Serhii5]

Guy’s , hi, could you help me, how to check if table records data was updated ? My table has regular update with autoSysFields(false) 

Regards, Serhii

[Jaspal Singh]

Hi Serhii,

All you need is to right click form header & select History. Something as below.

Alternatively, you can look for Audit tables like sys_audit, sys_history_line as well.

[Serhii5]

Thanks for your answer, is it possible to check in script ?

[Jaspal Singh · Accepted solution]

'check in script' makes me to 2 things.

Script updated or not - For that you can right click the form header as above & select Related List & add Version to the form.

Script to check if field was updated - Yes, you can gliderecord sys_audit table to get the results but do it only if there are limited set of records audit table has whole lot of things & can cause some performance issue as it will pull details that may take longer time to retrieve as it audit everything on platform.