- 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
Using SharePoint File Storage
After installing the plugin from the guide here and selecting the 'SharePoint' option, more fields will appear.
- The URL of your SharePoint site e.g. workbooksonline.sharepoint.com
- A company may have different sites on their SharePoint, sometimes by Teams or Regions. This field should be populated with the site URL you want e.g. site/FileStorageIntegrationTest.
- Using the SharePoint integration, it will natively create a folder for each record within the Documents section. In this case, a folder for each Organisation Record is created within the site mentioned in the above point. The Root Folder field should be populated with the naming convention of this Organisation folder you choose. For example, creating a folder called 'Atlantic Computer Services - ORG-489', you would populate the Root Folder field with '/{name} - {object_ref}'. This naming convention is using the API reference, of which a full list can be found within Configuration > Automation > API Reference, then clicking the Record Type you require and this will give you the names of the fields. It is worth noting the API reference will need to be enclosed by curly brackets, otherwise the plugin will not pick this up.
- The folders you want to add within this record folder (which you have created in the above field) e.g. Sales/Shared with Customer, Support/Shared with Customer, Sales/Internal Only, Support/Internal Only. Each folder specified needs to be populated one per line.
- The column used in SharePoint to match records from Workbooks to their respective folder. Following the guide on the Microsoft Help Site here shows how to create a single line of text column. It's advised to name this something unique to the Org Record in Workbooks, e.g. Org Reference, then populate the Reference Column field with the name of the column you have created in SharePoint. This column also needs to be indexed within SharePoint in order for the integration to work correctly. Follow the guide on the Microsoft Help Site here to see how this is done.
After all this information is populated, click 'Save'.
After saving, you will be able to see your created field with the SharePoint folders populated in all Organisation Records.
NOTE: Only once an Organisation record in Workbooks is opened, will this connect to SharePoint and create the folder.
Similarly to the File Storage Plugin, this is an easy to use drag and drop field that can also be added as a tab. This can be done by navigating to Configuration > Customisation > Record Types > Organisations (or whichever record you choose to add to) > Fields (tab), find the field you created and then click the checkbox to 'Show as Tab'.
All changes made on the field or tab within a Workbooks record will reflect SharePoint and vice versa.
- After clicking into any folder, this will appear to be able to go back one folder.
- Takes you back to the root folder.
- A link to this Knowledge Base Article.
- Refreshes the folder.
- Opens File Explorer to add new files.
- Opens up a new browser tab to view the folder in SharePoint.
- Deletes the folder/document.
- Can be dragged down to make the field larger to view all files.