- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
-
Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
-
Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- GatorMail
-
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?
- GatorSurvey
- GatorWorkflow
- GatorPopup
- Opportunities
-
Integrations
- Mapping
- Electronic Signing Tools
- Creditsafe Integration
-
Zapier
- 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 Integrations
- Email Dropbox
- Workbooks Exchange Server Sync
- Workbooks Outlook Connector
- RevenueGrid Intelligence and Engage
-
Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
-
Outreach
- Installation
- 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
- RingCentral
- Auditing
- Comments
- People & Organisations
- Projects
-
Reporting
- Introduction to Reporting
- Using Reports
- Charts
- Exporting Reports
- Advanced Reporting
- Report Snapshots
- Dashboards
-
Transaction Documents
-
Introduction to Transaction Documents
- Displaying & Adding Transaction Documents
- Copying Transaction Documents
- Transaction Documents Fields Help
- Transaction Documents Line Items Help
- Printing & Sending Transaction Documents
- Managing Transaction Document Currencies
- Managing Transaction Document Statuses
- Setting a Blank Default Currency on Transaction Documents
- Credit Notes
- Customer Orders
- Invoices
- Quotations
- Supplier Orders
- Contract Management
- Sagelink
-
Introduction to Transaction Documents
- Auditing
-
Configuration
- Introduction to System Administration
- Users & Security
- Preferences
- Database
- Accounting
- Email & Integration
-
Customisation
- Creating & Modifying Picklists
- Theme
-
Record Types
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Automation
- PDF Configuration
- Contact Support
- Releases & Roadmap
DocuSign Report - Multiple Send Report Grid
Prerequisite: This Report relies on Custom Fields that will only become available once the DocuSign Plugin has been installed and at least one Template has been created for the Record Type.
This Report forms part of the DocuSign integration when using the Multiple Send feature. This page guides you through how to create the Report and embed it on a record allowing you easily review all DocuSign tasks for a given record and their status.
Stage 1 - Build the Report
We recommend that you build the Report from the Record Type that the Report Grid will be based on, rather than creating an Activity Report. For example, if you are sending multiple documents from a Contract - start your report from the Contract record type and then drill through to Activities for the fields that you are interested in. This will allow the Report to run much faster and remain scalable as more documents are sent out for signature.
Click Start > New > Report > Create a new blank report > Customer Contracts and then add the following columns to the Report:
- Reference
- Activities > Status
- Activities > Activity reference
- Activities > Type
- Activities > DocuSign: Document Name
- Activities > DocuSign: Last Action
- Activities > DocuSign> Signed Document URL
Add the following Criteria to the Details view:
Activities > Type is DocuSign
Finally, add the following two calculated columns:
DocuSign Task Status - This column provides a more simple naming convention for the Document Status Field making it easier to review.
CASE activities.cf_task_docusign_document_status WHEN 'Document Draft - Not Sent' THEN 'Draft' WHEN 'Document Viewed by Recipient' THEN 'Viewed by Recipient' WHEN 'Document Sent for Signature' THEN 'Document Sent' WHEN 'Document Rejected - Recipient Declined' THEN 'Recipient Declined' WHEN 'Document Voided by Sender' THEN 'Cancelled by Sender' WHEN 'Document Signed' THEN 'Document Signed' ELSE NULL END
CSS Styling - This column will apply colour coding logic depending on the Document Status where anything in progress is marked as orange, completed documents in green and anything rejected will be in red. You can change the colours to suit your needs.
CASE activities.cf_task_docusign_document_status WHEN 'Document Draft - Not Sent' THEN 'text-align: center;background-color:DarkOrange;color: white' WHEN 'Document Viewed by Recipient' THEN 'text-align: center;background-color:DarkOrange;color: white' WHEN 'Document Sent for Signature' THEN 'text-align: center;background-color:DarkOrange;color: white' WHEN 'Document Rejected - Recipient Declined' THEN 'text-align: center;background-color:Red;color: white' WHEN 'Document Voided by Sender' THEN 'text-align: center;background-color:Red;color: white' WHEN 'Document Signed' THEN 'text-align: center;background-color:Green;color: white' ELSE NULL END
The CSS Styling Column can be added to all columns in the Report, this will then highlight the entire row.
Stage 2 - Create a Report Grid
Once you have built the report, you can use it to create a Report Grid Custom Field on Customer Contracts that is constrained by the Reference field. Click Start > Configuration > Customisation > Record Types > Customer Contracts, then go to the Fields tab and select New Custom Field > Report. Configure a sensible field label and select the report/report view that you just created.
Finally, constrain the results of the Report so that the Contract Reference from the Report is equal to the Contract Reference of the record.
This will ensure that only the Activities related to a given Contract are shown. Remember to add the field to the appropriate Form Layouts - enabling you to easily review the status of all DocuSign Activities related to this record.