How Eventos Aktum Built a Real-Time Audit Trail for Event Quotations
A Zoho Creator page-script solution that gives event management teams full visibility into who changed what, when — eliminating financial disputes and enabling data-driven accountability.
About Eventos Aktum
Eventos Aktum is a full-service event management company based in Mexico that coordinates corporate and social events end-to-end. Their operations — from initial client quotation through vendor payments and post-event financial reconciliation — run on a custom-built Zoho Creator application that manages the entire event lifecycle.
The Zoho Creator application handles quotations (Cotizaciones), events (Eventos), clients (Clientes), income tracking (Ingresos), expense management (Egresos), advance payments (Anticipos), supplier coordination (Proveedores), and operational checklists — a comprehensive system spanning over 73,000 lines of Deluge code.
No Visibility Into Quotation Changes
Cotizaciones (quotations) are the financial backbone of the business — they define pricing, line items, expected profit margins, and client commitments. Multiple team members frequently edit these records throughout an event's lifecycle: adjusting quantities, changing prices, adding services, or modifying payment terms.
Before this solution, there was no systematic way to answer basic accountability questions: Who changed a price? When was a discount applied? Which user removed a line item? This created real friction during financial reconciliation and occasionally led to disputes between team members about what was agreed and when.
Zero Audit Trail
No record of who modified Cotización fields, making post-event financial review guesswork.
Financial Discrepancies
Unexpected changes to pricing or terms surfaced only during reconciliation — too late to investigate.
No Operational Dashboards
Management had no centralized view of team activity on quotations — no trending data, no per-user analytics.
We'd finish an event and discover the final numbers didn't match what was originally quoted. Nobody could tell us exactly when or why the figures changed. We needed a system that would make every modification transparent — in real time, not after the fact.
— Eventos Aktum, Operations Team
Assessing the Gap
A diagnostic audit of the Zoho Creator application revealed that while the system tracked financial data thoroughly (Ingresos, Egresos, Flujo reports), it had no mechanism to log changes to the Cotización records themselves. The "Edit on Success" workflow — the script that fires whenever a quotation is saved — handled 16 distinct processes including orphan cleanup, financial recalculations, and event synchronization, but none of them captured a change history.
The evaluation identified that Zoho Creator's native audit trail was too coarse-grained for the business need: management needed field-level change tracking with user attribution, aggregated into a visual dashboard that could answer questions at a glance.
The ChangeLog Dashboard
A two-part solution was designed: a lightweight logging mechanism that captures every field-level change to Cotización records, and an HTML dashboard built as a Zoho Creator page that visualizes the change data across multiple time horizons.
Cotizacion_Change_Log Form
A dedicated form that captures the record ID, modified field name, old value, new value, user who made the change, and timestamp — automatically triggered on every Cotización save.
Last 7 Days Section
A rolling weekly view with user activity bar charts, per-cotización change summaries, and a detailed change log table — designed for day-to-day operational monitoring.
Last 30 Days Section
A monthly lookback mirroring the weekly structure, built to surface trends and patterns in modification behavior over longer periods.
User Activity Analytics
Bar charts showing change volume per user, enabling management to understand workload distribution and identify unusual modification patterns.
Built in Two Weeks, Zero Downtime
The solution was implemented in two phases. First, the Cotizacion_Change_Log form and its triggering workflow were added to the existing "Edit on Success" script — carefully inserted to avoid disrupting the 16 processes already running on each save. Second, the dashboard page was built using Deluge page scripts with embedded HTML/CSS, following the exact patterns established in other working dashboards within the application.
A key technical challenge was Deluge's page-scope variable collision. Because all variables in a Zoho Creator page script share a single scope, the weekly and monthly dashboard sections initially collided — loop variables from the 7-day section were being overwritten by the 30-day section. This was resolved by prefixing all monthly-section variables with m (e.g., mCotID, mUserName), a pattern now documented as a best practice for all future Creator pages.
An additional null-handling issue was caught during testing: some Cotización IDs came through as empty strings from ifnull() casts, which would pass != null checks but crash on downstream operations. Guards using != "" were added to all critical paths.
Complete Financial Transparency
From the day the ChangeLog Dashboard went live, every modification to every Cotización record became visible — who changed it, what field was affected, what the old and new values were, and exactly when it happened.
Replicability: Why This Matters Beyond Aktum
This pattern — a dedicated ChangeLog form + Deluge page-script dashboard — is fully replicable for any Zoho Creator application that needs field-level audit trails. The architecture is form-agnostic: the same approach works for tracking changes to invoices, purchase orders, project records, or any business-critical form. The dashboard template (user activity charts, per-record summaries, detailed log tables) can be deployed in under a week for new applications.
Now when someone asks 'why did this number change?' — we have the answer in seconds, not hours. The dashboard has become a daily tool for our operations team. It's changed how we manage accountability across the entire event pipeline.
— Eventos Aktum, Management
Need an Audit Trail for YourZoho Creator App?
This solution is replicable. Let's build field-level change tracking for your business-critical records.