- Welcome to the Knowledge Base
- Introduction to Workbooks
- Using the Knowledge Base
- Editions & Licensing
- Logging In
- Supported browsers
- Landing Pages
- HTML Editor
- Welcome Messages & Bulletins
- Exporting Data
- Multi Language
- Notifications & Reminders
- Workbooks Mobile Client
- Forecasts & Quotas
- Introduction to Importing
- Preparing your Import Data
- Workbooks Import Wizard
- Managing your Imports
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Upload Library
Workbooks Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Gator Popup
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- Using HubSpot with Workbooks
- Introduction to Event Management
- Enabling the Event Management Module
- Using Event Records
- The Event Management Portal
- Compliance Records
- Setting up the Integration
- Sending Mailshots using GatorMail
- GatorMail - Dynamic Content
- GatorMail Domain Setup
- GatorMail Field Mappings
- Managing your GatorMail Account
- Setting up GatorMail Workflows
Electronic Signing Tools
- DocuSign Functionality
- Setting up the DocuSign Integration
- DocuSign - Worked Examples
- DocuSign - Reporting
- Adobe Sign Integration
- Docusign Integration
- Creditsafe Integration
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- New Workbooks Case to JIRA Ticket
- Jira Issue to new Case
- 123FormBuilder Form Entry to Case
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Wufoo Form Entry to Sales Lead
- Posted Credit Note to Task
- QuickBooks Online
- Survey Monkey responses to Tasks
- Multistep Zaps
- Email Dropbox
Workbooks Exchange Server Sync
- WESS System Requirements
- Setting up the WESS
- Synchronising Emails
- Synchronising People & Contacts
- Synchronising Tasks & Meetings
- WESS Troubleshooting
- The WESS Add-in
Workbooks Outlook Connector
- Introduction to the Outlook Connector
- Before downloading the Outlook Connector
- Download/update the Outlook Connector
- Installing the Outlook Connector
- Using the Outlook Connector
- Outlook Connector Troubleshooting
- Microsoft Office
- Scribe/Workbooks Connector
People & Organisations
- Introduction to People & Organisations
- De-duplication and Merge
- Using Loqate
- Data Enrichment
- Introduction to Reporting
- Reporting Explained
- Displaying reports within Record Views
- Displaying Reports
- Adding a Report view to a Dashboard
- Exporting Reports
- Advanced Reporting
- Introduction to Transaction Documents
- Credit Notes
- Customer Orders
- Supplier Orders
- Contract Management
- Introduction to System Administration
Users & Security
- User Groups
- Account Settings
- Licences & Modules
Email & Integration
- Email Settings
- API Keys
- Web to Case and Web to Lead
- Preference Centre
- MailChimp, Constant Contact & dotMailer
- SharePoint Integration
- Bank Account Validation
- Creating & Modifying Picklists
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- PDF Configuration
- Contact Support
Releases & Roadmap
- January 2020 Release
- September 2019 Release
- February 2019 - Event Management Release
- January 2019 Release
- October 2018 Release
- May 2018 Release
- February 2018 Release
- January 2018 Release
- November 2017 Release
- September 2017 Release
- June 2017 Release
- March 2017 Release
- December 2016 Release
- August 2016 Release
- January 2016 Release
- Workbooks Glossary
Workbooks' Auditing functionality provides you with information about any changes which have been made to your database. You can find information about which records have been created, deleted or updated, by whom and when, and details of the change that was made. Audit also records any changes made to Configuration and User Preferences, and it keeps track of when data has been exported or printed from Workbooks.
As Audit records every change made to a record, it's a powerful tool for identifying exactly what happens to your data, so if a record is erroneously changed or deleted, you can use Audit to piece the record back together again.
Changes to data can be viewed on a record-by-record basis, from the Audit landing page, or via Reporting. With reporting, Audit enables you calculate how long a record has been in a particular state. For example, you might want to know the average length of time Cases on your database are 'Open' before being moved to a 'Closed' status, or how much time elapses between a Lead being created and qualified in/out. Find more information on how to create such reports here.
The Audit module is a licensed extension to Workbooks. Your account must be licensed for Audit before any Audit data will be collected. Audit data will stop being collected if the Audit module is disabled. In order for Users to see Audit data they must have the Audit licence allocated to them and have at least one of the following Capabilities:
- View All Audit Records - this gives the User access to the Audit Landing Page and access to the Audit information for every 'auditable' record on your database. By default, all System Administrators will have this Capability.
- View Audit Record Detail - this doesn't give the User access to the Audit Landing Page but they can see the Audit details for the records they have permission to access. This Capability is included in the Everyone Group by default so will be granted to all Users.
There is a variety of ways in which you can see the audited changes to Workbooks records. If you have the right Capability, you can see all the audited records by clicking Start > Auditing, which opens the Auditing Landing Page. The grid on the right lists all the audited records.
Alternatively, for an individual record, you can also see the changes by opening the Information screen (using the icon in the top right corner) and clicking Audit to display the audit history for this record. If a record has a Summary tab, the Audit information will also be included within the Summary with a context type of 'Audited'.
You can click on the expander grid + symbol to see a quick view of the changes or click on the row to open the audit record, which will look similar to the screenshot below (click to enlarge).
The top part of the form shows details of:
- Date - when the change or changes were made.
- User - which User made the changes.
- Action - what type of change was made (either create, update or delete).
- Record Type - what type of record has been updated.
- Description - this is generally the name/subject of the record.
- Reference - the object reference for the record.
- Request ID - a number used to group together a number of modify/create actions into one request sent to the system. All Audit records with the same Request ID represent changes made by a single request to the service.
- Client IP Address - the IP address used when sending the request to the service.
- Client Type - what type of client sent the request.
The lower part of the form shows details about which field or fields have been changed. Columns for Previous Value and New Value enable you to see at a granular level what the changes were.
Some records can only be changed within the context of a 'parent' record. Examples include Notes, Pricing Schemes, Line Items and Contact details. When viewing audited changes for such records the parent record details will also be shown.
You can see what user activity is happening in your database, such as the number of records created, updated and deleted as well as the number of logins for each user per day. This will be particularly useful to track user adoption and monitor the trends on user usage.
By clicking Start > Auditing, this opens the Auditing Landing Page, there are three views below that can be used:
• Daily Usage
• Weekly Usage
• Monthly Usage
There will be a new record for each user created daily, which are then totalled up to Weekly and Monthly.
A record only shows fields for operations that the user has performed. These records are also reportable, and you will now have Daily Usage, Weekly Usage and Monthly Usage options when creating a new report for more advanced analysis of the trends.
Workbooks allows records to be related to one another. Changes to these relationships are audited as individual audit records. The Descriptor field describes the relationship.
You can build reports based on Audit information to help you track the changes made to your data. Click here for more information on Audit reports.
Configuration and Preference Auditing
Changes to your Workbooks configuration can now be tracked using Audit. You'll need to go to Start > Auditing and use a 'contains' filter on the Record Type column to find the changes, use the grid below for help finding the specific customisation audit records.
|Customisation Type||Record Type 'contains' filter|
|Linked Fields||Field Mapping|
|Custom Fields||Custom Field|
|Record Template||Record Template|
|Form Layout||Form Layout|
Viewing changes made to Preferences works in a similar way, go to Start > Auditing and filter on Record Type with the name of the section.
NOTE: It's not always obvious what the Record Type is called for Configuration or Preference Audit records, therefore if you're looking for a particular change, make a temporary change yourself to the setting in question, look through the audit logs to identify what the precise Record Type name is from the most recent audit record, then simply filter on this to find other occurrences of the change.
Auditing can also show records of users that have been deleted. In the event that a user's profile disappears from the system for any reason, a log of this will be held within the audit records.
Export and Printing Auditing
An audit record is created every time a user exports or prints data from Workbooks. To find out a log of all exports, go to Start > Auditing and apply a filter on Action starts with 'export'. Likewise, filter on Action starts with 'print', to find all instances where the print button was used.