- Welcome to the Knowledge Base
- Introduction
- Training
- Desktop Environment
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
-
Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
-
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
- Event Management
- Compliance Records
- GatorMail Integration
- 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
-
Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
- Outreach
- Scribe/Workbooks Connector
- People & Organisations
- Reporting
- Dashboards
- Transaction Documents
- Auditing
-
Configuration
- Introduction to System Administration
- Users & Security
- Database
- Accounting
- Email & Integration
- Customisation
- Automation
- PDF Configuration
- Contact Support
-
Releases & Roadmap
- Roadmap
- 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
Edit Grids
Edit Grid Overview
To make editing lots of records of the same type quicker, on a Landing Page you can activate ‘Edit Grid’ and carry out inline editing of your data. This is only available within the Desktop not on mobile devices. To use it, the Editable Grids module must have been activated on your database and you must have been given the appropriate capabilities.
You can edit multiple fields on one row of data or different fields on different rows.
The following record types are editable in grids:
- Activities
- API Data
- Cases
- Marketing Campaigns
- Opportunities (header information only, not Line Items)
- Organisations
- People
- Products
- Sales Leads
In addition, any Custom Objects on your database can also be edited in a grid.
Activating Edit Grid Functionality
There are two steps that System Administrators need to take to activate Edit Grid functionality:
- Switch on the Editable Grids module by navigating to Start > Configuration > Account Settings > Licences & Modules > Modules and ensuring there's a tick in the checkbox next to Editable Grids.
- Make sure the user has the appropriate Capability/Capabilities to allow them to edit a specific record type in a grid. Each record type that can be edited in a grid has a separate Capability, which is called "Allow editing of xyz records in grid".
BEFORE activating Editable Grids, please remember the following:
- Any On Save automated processes you have in place will not be initiated when you save a record you've edited in a grid
- Multi-select picklists cannot be edited in a grid
- Giving users the ability to edit Landing Pages in grids may give them access to fields that they cannot normally see/edit, so proceed with caution.
Using Edit Grid Functionality
To edit a Landing Page in a grid format, navigate to the appropriate Landing Page and use the View button towards the top right-hand corner to select Edit Grid. The screen will change slightly in appearance and you will now be able to click into the fields you want to edit and modify their content. While you're still editing a cell you'll see an edit icon in the left-most column and when you click or tab away from the cell you'll see a green triangle in the top left-hand corner, giving a clear indication of which field(s) you've modified. When you click onto a different row, you'll see that the edit icon changes to an undo icon. If you want to revert the changes you've made to a row, click on the undo icon. This will revert all field changes for that specific row.
If you try to save changes that are not acceptable - for instance removing the value from a mandatory field - you'll see an error message on the screen and a red triangle in the top left-hand corner of any cells that need to be corrected.
You cannot edit multi-select fields but you can use single select fields in the normal way. In addition, you can edit multi-line text fields and simply click enter to create a new line of text. Standard rich text fields are not available to edit within Edit Grid but you can edit custom rich text fields. Within some browsers (not Firefox) you are able to apply a limited range of formatting using the following controls:
- Bold - Ctrl/Cmd + b
- Italicise - Ctrl/Cmd + i
- Underline - Ctrl/Cmd + u
- Insert Timestamp - Alt + Shift +0
- Subscript - Alt + Shift +1
- Superscript - Alt + Shift +2
When you've made all the edits you want to make, click the green Save button above the grid and all the changes will be applied.
To open an individual record you need to change the view of your Landing Page back to View as Grid.
The video below takes you through how to activate and use Edit Grid functionality.