It is time for another #LightningFlap! In an earlier post, I outlined how useful List Views are in Salesforce Lightning Experience. In this post, I cover:
- What is a List View?
- How are they helpful?
- Lightning vs Classic
- Deep dive: List Navigation & Usage
The theme throughout will be how List Views in Lightning can help your users be more productive. Specifically, an easy way to ‘act’ on insights from multiple records.
What is a List View?
Sometimes underutilised, list Views allow you to work with data from a specific object (e.g. Account, Opportunity, Contact, Custom Object etc). They provide a screen to sort, filter, search, view, create, edit, and delete an object’s records easily. Lightning Experience takes this to a new level.
How are List Views helpful?
The short answer, in lots of ways! Here are some common use cases.
However, the take-home is that they are a great productivity tool. In addition to allowing you to view multiple records at once, it provides the tools to act.
Lightning vs Classic
Here are the main differences between Lightning and Classic List Views. This post will not cover all features. If there is a feature you would like to hear more about, please reply in the comments below.
Feature Comparison: Lightning vs Classic
|Add Filter logic||Apply filters and logic to show only desired records (e.g. Accounts in London OR Birmingham)||✓||✓|
|Chatter Feeds||View Chatter Feed updates for Records shown||☓||✓|
|Create Charts||Create Vertical/Horizontal Bar and Donut charts based on Records shown||✓||☓|
|Create/Edit List Views||Create and Edit List Views, depending on permissions||✓||✓|
|Fields Displayed||Select up to 15 fields to display||✓||✓|
|Infinite Scroll||No need to select the number of records to display. Scroll down to load more records||✓||☓|
|Inline Editing||Edit one (or multiple) records||✓||✓|
|Kanban View||Graphically view records; summarise and group data (e.g. Opportunity Amount by Stage)||✓||☓|
|Pin List Views||Select a List View to be your default for a tab (e.g. All Accounts on the Accounts tab)||✓||☓|
|Printable View||Printable View of data. This must be enabled within Setup | User Interface | Enable Printable List Views||✓||✓|
|Resize Columns||Control column width size; expand or reduce||✓||✓|
|Search List View||Search record results (using eligible fields) from the List View’s inbuilt search bac||✓||☓|
|Sharing Controls||Control who has access: only you, all users, or groups of users (e.g. Roles, Public Groups etc)||✓||✓|
|Sort Columns||Click a column heading and values will be sorted ascending (small to large) or descending (large to small)||✓||✓|
|Wrap/Clip Text||Control whether you want to see all the content of a field, or just the first part||✓||☓|
Deep-Dive: List View Setup
Let us look in more detail within Lightning Experience.
Navigating List Views in Lightning
To access a List View, go to a tab (e.g. Accounts) within Salesforce. The screenshot below shows the main features of the screen.
If you are familiar with Classic, you may wonder where the ‘Records Per Page’ and page number are. These do not exist in Lightning, as this has been replaced with ‘infinite scroll’. This means, to load more records, just scroll!
Recently Viewed & Pinning
As a side-note, clicking on a tab within Salesforce will load the ‘Recently Viewed’ List View by default. This can cause confusion. Unlike other views, you cannot customise the view from the page itself. To add/remove fields from this page, Admins can refer to this Salesforce Help and Training guide.
However, users often have a specific view they need for their work. Consequently, ‘pinning’ is handy. With pinning, users can select the view which is most useful for them. This becomes their default for that tab. Should a user want to change their preference in future, navigate to another view and ‘pin’ that view. This will then overwrite the selection.
Create a List View
In this example, I shall create a simple view based on the ‘Account’ object. I will only show records with ‘SFDC Penguin’ in the name. To do this:
- Navigate to the ‘Account’ tab
- Click on ‘List View Controls’ and select ‘New’.
- Tip: always check if what you want already exists. There is no point re-inventing the wheel!
- Enter a List View Name and who can see it. Here I shall call my List View ‘Accounts – SFDC Penguin’. Press tab to automatically populate the ‘List API Name’. I will also limit visibility to ‘Only I can see this list view’. In the ‘real-world’ consider:
- Who will use this? If only yourself, limit visibility. This is particularly relevant to Admins and Managers
- Ensure List Views have a meaningful name, especially if shared! Consider a naming convention
- The List View has been created. Next, ‘filter’ the data to show only SFDC Penguin Account records. To do this, click on ‘Filter’. I shall apply the following.
- Filter By Owner: Update to ‘All accounts’. This will show all Accounts I have access to
- Filter ‘Account Name’ where the Account Name ‘contains’ SFDC Penguin. What this means is I want Salesforce to list all Accounts which have SFDC Penguin in the name
- Click ‘Done’ and then ‘Save’
- This will refresh the view and the results will be updated. It is also recommended to use the ‘Refresh’ button to get up to date data. The results have been sorted in ‘ascending’ order (smallest to largest, by Account Name). This has been achieved by clicking on the ‘Account Name’ column.
- I will then remove ‘Account Site’ and ‘Phone’ from the List View, and replace them with ‘Annual Revenue’ and ‘Billing Country’. To do this, go into: ‘List View Controls’ | Select Fields to Display and then use the add/remove fields component:
- From the same screen, we shall add ‘Annual Revenue’, ‘Billing Country’ and ‘Description’. Select these fields from the left-hand ‘Available Fields’ column and click ‘Add’ then Save
- This screen also allows us to re-order fields. To do so, click on a field from the ‘Visible field’ column and then the up or down arrows to change their position. Fields at the top of the list will be on the ‘left-hand’ side of the view
- We can now check the List View we have created. This List View is working fine, although the Description is currently being ‘clipped’. If this is not desired, simply click on the arrow next to ‘Description’ and select ‘Wrap Text’.
For Data Cleansing, in-line editing is extremely powerful. Let us assume the SFDC Penguin Accounts found in the List View above should all have the ‘Type’ ‘Customer – Direct’. With the View created, I can easily see they are not, but also update all three simultaneously.
To mass-edit, follow these steps:
- Select the records you wish to update
- Hover over a field within the records you want to update. This will only work where a ‘pencil’ icon is shown. If a padlock is shown, you will not be able to edit the field within in-line editing. For more information on this, please refer to this article
- Click on the ‘Pencil’ icon and select the value you want to enter. In this example, ‘Type’ is a picklist field, so I will choose ‘Customer – Direct’ from the list of options. However, if this were a text field, you would be able to enter your desired value into the field. Select ‘Update X’ selected items and then ‘Apply’
- A preview of the update is displayed. To save the changes, click ‘Save’. If you wish to reverse the change, click ‘Cancel’. Once you have clicked ‘Save’, you cannot automatically reverse the change.
NOTE: Up to 200 records can be selected from a List View at any one time
Last, but far from least, Kanban views are a relatively new feature and only available in Lightning. They provide a more visual way of interacting and viewing records. In a Kanban view, you can summarise certain fields (e.g. amounts/numbers) by a specified grouping. This is often particularly helpful in Opportunity records.
For example, you can ‘Summarise’ amounts to get totals, whilst Grouping by ‘Stage’. The output would be a Kanban view of a pipeline. To set this up:
- In this example, go to the Opportunities tab
- Select the ‘All Opportunities’ List View
- Select ‘Display As’ and choose ‘Kanban’
- By default, your List View will summarise by Amount and Group by Stage. Note that, in Opportunities, the Kanban view also highlights Opportunities without Open activities. This is to ensure Sales Teams remain focused and keep prospective customers engaged.
- Should you wish to customise or apply a different grouping or summary, click on ‘List View Controls’ and ‘Kanban Settings’.
- You will then be able to amend the Kanban view as required.
List Views in Lightning Experience can empower users and aid adoption. Tools such as pinning List Views, Charts, Kanban and In-line editing allow easy access to multiple records. They also aid data cleansing, prioritisation, and management. In short, they help users be proactive and focus their efforts.