- 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 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
- 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
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- PDF Configuration
- Contact Support
Releases & Roadmap
- October 2021 Release
- June 2021 Release
- March 2021 Release
- December 2020 Release
- September 2020 Release
- April 2020 Release
- 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
Emailing Scheduled Reports
Workbooks allows Users to define a schedule on which Reports and Charts are run and emailed to one or more recipients. The recipient doesn't have to be a Workbooks User so it is a great way to share data held within Workbooks. For example, weekly sales reports can be sent to a manager every Monday morning, thus allowing them to review the previous week's sales and plan for coming week.
A single report, or a combination of reports and charts, can be sent in the same email. These can be sent within the email body or attached to the Email itself. If your report does not contain any data at a time it is due to be sent, rather than receive a blank email you can prevent the Email from being sent.
This is not designed to be used as a way to export large volumes of data from Workbooks on a schedule.
Note: For scheduled emails to work, the sender of the email MUST have at least Read permissions for the Reports being generated. In addition, to use this functionality, the user must have the following capabilities: View Scheduled Email Reports, and Modify Scheduled Email Reports.
Setting up a Scheduled Email
To access a Scheduled Email go to Start > Reporting where you can either create a New Scheduled Email or select My Scheduled Emails or All Scheduled Emails if you want to edit an existing one.
Selecting a New Scheduled Email will open a new Window where you can configure your Scheduled Email.
Please be aware: Workbooks will fail to send the email if you attach a report that takes too long to load or contains to many rows. Please ask Support if you need more detail.
From - This will be set to your User, this is read only and cannot be changed at a later date. You will need to ensure that you have a correctly configured Email Account within Workbooks if you want to send out a Scheduled Email.
Subject - This will default to “Workbooks Report” but can be overwritten and will be used as the Email Subject when it is sent out.
Send if empty - If all of the Reports are empty the email will only be sent if this is set to true. We recommend changing this to false so that Users do not receive emails needlessly.
Schedule - Here you can select whether your Email is generated Hourly, Daily or Monthly. Depending on the frequency the recurrence settings will change accordingly to allow you to better configure when this email is sent.
Enable - Once you are happy with how the Scheduled Email is configured, select Enable and the Email will be scheduled to send.
To - Enter the email addresses of those you would like to address the Email to, they do not need to be Workbooks Users or have a Person or Lead Record within your Database.
CC / BCC - Similarly to the To Field here you can include additional recipients to receive this Scheduled Email.
Message - Here add in any text that you will require within your Email this may be an overview of what the Reports show or just a simple one line. You do not need to worry about adding in the Reports to the message as this will be done automatically.
Note: Email Templates can be applied by using the Apply Template button along the Toolbar.
From this Tab you can add your chosen Charts or Reports to the Scheduled Email. This is done by selecting the Add Report or Add Chart button.
Adding a Report
Selecting Add Report will create a new Window where you can configure your chosen Report and configure how you would like it to be displayed in the Scheduled Email.
Report - Select the Report by name that you would like to add to the Scheduled Email
View - Select the View from that Report that you would like to include in the Scheduled Email.
Format - Here you can choose from inline, where the Report will appear within the body of the email. Alternatively you can select Excel Spreadsheet (XLS) or Comma Separated Values file (CSV) if you want to attach the Report to the email instead.
Note: The XLS file format is used instead of XLSX because it is compatible with older versions of Excel, but will cause you to see an 'incompatible' message in newer versions of Excel. However, it will not open in Excel Online; if using Excel Online, use the CSV option.
Position - Select where this Report will appear in the email. By Default this is set to Last so that if it is an Inline Report all of the text in the message Field will appear above it.
Note: Inline Reports are generated by the User that owns the Scheduled Email and as such you will only see a number of Rows, which is specified by their Preferences. This means that if the User generating the Report has their Preference set to only seeing 20 Rows on a page and the Report contains 25 rows only the first 20 rows will be sent in the Email.
Add a Chart
Selecting Add Chart will create a new Window where you can configure your chosen Report and Chart View to be displayed in the Scheduled Email.
Report - Select the Report by name that you would like to add to the Scheduled Email, this list will be limited to include only Reports that have at least one View charted.
Chart - Select the Chart from that Report that you would like to include in the Scheduled Email.
Format - Here you can choose the file type that you would like to generate from either Image file (PNG) or Scalable Vector Graphics file (SVG). Position - Select where this Chart will appear in the email, by Default this is set to Last so the text in the message Field will appear above it.
Note: Charts can only be included in the body of the Scheduled Email, they cannot be attached like Reports.
The Emails Tab stores every Email generated by the Scheduled Email. You may want to access this in case you want to review a historic Email that you are unable to locate in your inbox or if you want to ensure that a Email went out on schedule.
Note: Emails can be sent immediately by using the Send Now button on the Main Tab.