{"id":1123,"date":"2008-02-29T03:45:37","date_gmt":"2008-02-29T09:45:37","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=1123"},"modified":"2023-04-11T11:37:18","modified_gmt":"2023-04-11T16:37:18","slug":"adding-the-current-date-time-and-user-for-auditing-purposes","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/adding-the-current-date-time-and-user-for-auditing-purposes","title":{"rendered":"Adding the Current Date, Time, and User for Auditing Purposes"},"content":{"rendered":"\n

Overview<\/h2>\n\n\n\n

When you utilize maintenance applications for your end users, you will, more likely than not, want to record when and who have made the most recent changes to your data. Doing this within the m-Power software is a breeze.<\/p>\n\n\n\n

The feature outlined in this documentation will only track the most recent changes made to a record. For those who want to track all changes that have been made to a record over time (not just the most recent), please see our Historical Auditing feature here<\/a>.<\/p>\n\n\n\n

Configuration<\/h2>\n\n\n\n

Edit your application and within the data model navigate to your Field Settings screen. Here, change the “Basic field attributes” dropdown to “Form validation and auditing”.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

In the Audit column that appears is a selectable drop-down that will only appear for any non-numeric fields. Selecting a value from this drop-down will have your application automatically insert a date, user, time, or application number (ex. ‘M00001’) for when the record is submitted or updated. <\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

The drop-down options are as follows:<\/p>\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n\n\n


<\/a> ‘Add<\/strong> (Date\/Time\/User\/PGM)’ will audit when a new record is submitted<\/p>\n\n\n\n

‘Change<\/strong> (Date\/Time\/User\/PGM)’ will audit when an existing record is updated.<\/p>\n\n\n\n

‘Add\/Change <\/strong>(Date\/Time\/User\/PGM)’ will perform both of the above.<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/div>\n\n\n\n

Runtime<\/h2>\n\n\n\n

Any fields that are have an audit option applied will be automatically hidden from the maintainer form at run-time when viewing a record in add, update, or delete mode. However when the form is submitted, the application will write the audit columns appropriately. <\/p>\n\n\n

\n
\"\"\/<\/a><\/figure>\n<\/div>\n\n\n

You the have the ability to capture the user <\/strong>only if you are utilizing Dictionary Security. Without utilizing security, a user will not sign-in to run an application and therefore cannot not be audited. <\/p>\n","protected":false},"excerpt":{"rendered":"

Overview When you utilize maintenance applications for your end users, you will, more likely than not, want to record when and who have made the most recent changes to your data. Doing this within the m-Power software is a breeze. Configuration Edit your application and within the data model navigate…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[252],"ht-kb-tag":[280,292],"class_list":["post-1123","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-maintainer","ht_kb_tag-audit","ht_kb_tag-maintainer"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=1123"}],"version-history":[{"count":19,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1123\/revisions"}],"predecessor-version":[{"id":12473,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1123\/revisions\/12473"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=1123"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=1123"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=1123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}