- Welcome to the Knowledge Base
- Supported browsers
- Landing Pages
- Workbooks on Mobiles and Tablets
- Introduction to Cases
- Displaying & Adding Cases
- Managing Cases
- Custom Fields
- Case Portal Configuration
- Case Portal Additional Features
- Using the Case Portal
- Forecasts & Quotas
- Introduction to Importing
- Preparing your Import Data
- Workbooks Import Wizard
- Managing your Imports
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Upload Library
- Using HubSpot with Workbooks
- Introduction to Event Management
- Enabling the Event Management Module
- Using Event Records
- The Event Management Portal
- On The Day Registration App
- Setup On the Day Registration App
- Compliance Records
- What is Spotler?
- Navigating your Spotler homepage
- Introduction to GatorMail
- Managing your GatorMail Account
- GatorMail Configuration
- Creating Emails in GatorMail
- Sending Emails in GatorMail
- Advanced Features
GatorLeads / Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- 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?
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
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
Event & Webinar Integration Tools
- Create/Update & Cancel Webinars from Events
- Event Attendees as Webinar Registrants
- Event Speakers as Webinar Panelists
- Retrieve Webinar Data
- Authentication with ON24
- Create Webcasts from Events
- Event Attendees as Webcast Registrants
- Retrieve Webcast Data
- Retrieve Survey Data
- Engagement Hub Interactions
- Azure Active Directory
- Power BI
- Outreach Authentication
- Sync People to Outreach Prospects
- Sync Organisations to Outreach Accounts
- Sync Workbooks Opportunities to Outreach
- Sync Tasks/Activities from Workbooks to Outreach
- Sync Outreach Sequences to Workbooks
- Sync Outreach Sequence States to Workbooks
- Sync Outreach Sequence Step Numbers to Workbooks
- Sync Prospects/Accounts/Opportunities from Outreach to Workbooks
- Sync Outreach Tasks/Calls/Meetings to Workbooks
- Scribe/Workbooks Connector
People & Organisations
- Introduction to People & Organisations
- De-duplication and Merge
- Using Postcode Lookup
- Data Enrichment
- Introduction to Reporting
- Adding Targets, Conditional Formatting and CSS Styling
- Reporting with multiple currencies
- Drilling into Summary Views
- Improving Report Performance & Run Time
- Displaying reports within Record Views
- Displaying Reports
- Adding a Report view to a Dashboard
- Reporting Explained
- Exporting Reports
- Using Calculated Columns
- Audit Reporting
- Okta Authentication
- 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
- Bank Account Validation
- Creating & Modifying Picklists
- Desktop Preferences
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Workbooks Scripts
- API Data
- Triggers and Webhooks
- PDF Configuration
- Contact Support
Releases & Roadmap
- March 2022 Release
- October 2021 Release
- June 2021 Release
- March 2021 Release
- 2020 Releases
- 2019 Releases
- 2018 Releases
- 2017 Releases
- 2016 Releases
- 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 tracks every change made to a record, it's a powerful tool for identifying exactly what happens to your data, so if a record is accidentally 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.