Creating an audit log of all changed fields
I'm trying to create an audit log to track changes made to any field in a form. It's set to work on Validation on form submission. I've tried using the trusty old ChatGPT but it's getting confused too!
Can anyone point me in the right direction please? I'm getting an error on line 8, improper statement error might be due to missing ; at end of line or incomplete expression.
// Get the ID of the current record
recordID = input.ID;
// Get the list of fields in the form
fieldsToTrack = getFieldNames();
// Loop through the fields to track
for each field in fieldsToTrack
{
// Get old and new values
oldValue = ifnull(old.get(field), "");
newValue = ifnull(input.get(field), "");
// Check if the value has changed
if (oldValue != newValue)
{
// Add a new entry to the Activity log form
logEntry = insert into Activity
[
Date_Time = zoho.currenttime,
Field_Name = field,
Old_Value = oldValue.toString(),
New_Value = newValue.toString(),
User = zoho.loginuser,
Record_ID = recordID
];
}
}
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Robert Oldershaw
Damien Cregan
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー