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:

1. 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.

2. 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.