Grid - Mass/Record Actions
Last updated
Last updated
The quick actions are a set of actions that can be performed by the end-user manipulate the data displayed and by admin to configure the grids.
The quick actions can be configured using the component properties and the configuration wizard.
There are three different types of quick actions:
Configuration actions: Admin action like Config. Wizard or Inline Config.
Global action: Generic actions that apply on the whole grid without selecting a record.
Record action: Actions to apply when records are selected.
The action icons are visible at the top of the grid in the toolbar
Before implementing any GridMate Actions, ensure you have the GridMate Extensions package installed in your Salesforce Org. Please reach out to our Support Team to obtain the latest package version.
To execute a record action like Clone Items, the user has to select records. Multiple records could be select using SHIFT button + select.
To create a new filter.
Click on the drop-down Select Filter and select New
The Filter Wizard screen is displayed.
To create a filter to show only the cases which have been closed. In Select Filter Fields highlight the Status field from the available list and click on the right arrow to move it to the selected list.
In Define Filter Values select Equal and Closed.
In Filter Configuration provide a name for the newly created filter. By default, the junction is ‘AND’ between all the selected fields. Update the filter conditions using ‘OR’/’AND’ if necessary in the Filter Value field.
Select if you wish to make the filter global and then click Save.
When the filter is saved successfully, a confirmation dialog will be displayed.
Reload the lightning page for the changes to be effective.
To use the new filter, reload the lightning page and select the filter list drop-down. The new filter name is displayed.
Click the filter name and the data grid will refresh to show the now filtered data.
If selecting to make a filter global, the filter will be available across all lightning pages.
To edit an existing filter.
Select the filter name from the drop-down list of filters and click on the Edit Filter button.
The Filter Wizard is presented with the existing filter fields visible.
To edit the filter, adjust the filter fields or filter values as required, and click Save. The updates to the filter will be saved.
To clone an existing filter.
Select the filter name from the drop-down list of filters and click on the Clone Filter button.
The Filter Wizard is presented with the existing filter fields visible.
To edit the filter, adjust the filter fields or filter values as required, update the name and click Save. The cloned filter will be saved as a new record.
To delete an existing filter.
Select the filter name from the drop-down list of filters and click on the Edit Filter icon.
The Filter Wizard is displayed with the existing filter fields visible.
To delete the filter, click Delete, a confirmation dialog will be displayed.
Click OK to confirm to delete the filter, the filter is deleted.
To Create a Quick link Filter to existing filter.
Choose the desired filter from the dropdown list.
Click Quick Link Filter action.
Check auto-refresh and specify the update frequency if needed.
Click save.
To pin/unpin an existing filter.
Select the filter name from the drop-down list of filters
Click on the Pin/Unpin icon.
When a filter is pinned, it gets applied each time the grid is loaded. Pinned filters are defined per grid and managed by the end users not by the admin
To share an filter. Only owned filter can shared
Click on the Share action.
The sharing dialog is displayed.
Add the Users/Groups/Roles with the appropriate sharing (Read only | Read/Write)
Click Submit to proceed with the selected records.
To set the number of columns to freeze in the displayed data grid.
Click on the Freeze columns icon.
The Freeze Column dialog is displayed.
Enter the number of columns to freeze.
Click Save.
Columns will be frozen starting from the left-hand side.
Export the displayed data to an Excel or CSV file. All eligible records are exported not only the displayed ones. GridMate can export till 5K records!
Click on the Export icon.
This will open a dialog allowing the user to select the format (CSV, Excel, Formatted Excel) and the name of the generated file. We can also exclude the recordId from the export.
If you want to export only selected records, check Export only selected records
If you don't want to export Id including lookup fields, check Do not export record Id(s)
Click Export to download the data.
Currently Formatted Excel export supports only coloring. Grouping and aggregations will be supported in the coming versions.
The Edit Items function allows the end-user to perform inline editing of the data displayed on the data grid.
Click on the Edit Items icon.
The GridMate data grid will enter edit mode and the user will be able to directly edit the data fields displayed.
As the data fields are edited the border of each displayed data field will be highlighted to show it has changed.
To save the updates made to the data click Save, to cancel the updates click Cancel. If the updates are saved a confirmation dialog is displayed. If there is any error because of a trigger or a validation rule, the user gets notified. GridMate handles the errors at row level to easily fix the data.
All changes that are made during the inline editing are handled like a transaction. There are no changes that are saved into the server including record creation and deletion. When a grid is saved, all the changes are applied:
Create brand new objects
Update the edited objects
Delete records marked for deletion
The page is not refreshed when an inline grid is saved. Only the saved grid is reloaded to keep the master grid state the same.
All types of fields are supported except compound fields like addresses. We provide enhanced UI components for Multi PickList, Long Text, and Rich Text fields.
To enhance the performance and the search relevance, we use SOSL instead of SOQL for lookup fields.
To be more aligned with Salesforce UX, GridMate provides the same search dialog for lookup fields. However this feature is not available on Community and Salesforce Professional Edition.
During the inline editing, the end-user can add multiple records at a time. Put the number of the records to add, and hit Create New Record.
☝️GridMate handles well dependant picklist fields. The dependent fields should be displayed on the grid.
☝️We support lookup filters for lookup fields and recent items as well. When a lookup field gets the focus, the recent records list is displayed if the user doesn’t enter a search term.
☝️Vertical navigation is available during the inline editing. You can go from up or down using the keyboard shortcuts below:
☝️Multi copy paste is available during the inline editing. You can copy paste multiple values on the same column at one time. Almost all the data types are supported including lookup fields. This feature is a must for data capture from Excel files for instance. For lookup fields, GridMate will fetch the id(s) based on the lookup record name.
☝️During inline editing, the end user can reset a field to the original value using keyboard shortcuts below:
The reset value shortcut is available only for the list of fields below:
Boolean
String
Phone
Url
Currency
Double
Integer
Percent
Date
Datetime
Time
The Create Record function allows the end-user to create a new record.
Note: When this function is available from the toolbar, please ensure the GridMate component property “Default Values” is set to include the required fields for the object.
Click on the Create Record icon.
The New Record dialog is displayed, with the default values presented.
Enter the new record data.
When Submit is clicked the component creates a new record, populates it with the default values, stores it on the Salesforce back end, and displays it to the user. When the new record has been created, a confirmation dialog is presented.
The Clone Items function enables the cloning of records from the data grid.
From the displayed data grid, select at least one record to clone.
Click on the Clone Items icon.
The Clone selected items dialog is displayed.
Click Yes to proceed with the cloning of the selected records
When the records have been cloned, a confirmation dialog is displayed.
The cloned records are visible on the data grid.
The Mass Update function enables the mass update of records from the data grid.
From the displayed data grid, select at least one record to mass update.
Click on the Mass Update icon.
The Mass Update dialog is displayed.
Select the appropriate fields to update and set the new value for each field
Click Yes to proceed with the update of the selected records.
When the records have been updated, a confirmation dialog is displayed and the grid is refreshed accordingly.
The Mass Update can be configured as a bulk action using the action configuration below:
This action action can be triggered as a Bulk Action.
The Delete Items function enables the removal of records from the data grid.
From the displayed data grid, select the records to delete.
Click on the Delete Items icon.
The Delete selected items dialog is displayed.
Click Yes to proceed with the deletion of the selected records.
When the records have been deleted, a confirmation dialog is presented.
The Actions function enables access to custom quick actions associated with the object to be called and applied to the selected records.
From the displayed data grid, select at least one record.
Click on the Actions icon.
The list of available actions is displayed.
Select the appropriate action as required, for example Update Account. The user defined action will be presented using the same layout of the quick action.
Click Submit to apply the quick action.
Below is an example of a quick action configuration. This configuration can produced by the Config. Wizard.
name: the API name of the action.
label: the label of the the action.
icon: the SLDS icon of the action. Only utility family is supported.
attributes: Extra attributes to control the action. Only density is supported as of today. The density is used to override the density of the layout ("compact", "comfy").
GridMate provides a Mass Email action. This action can be added to the Actions menu and made available to the end-user. When the Mass Email action is selected the following dialog is displayed. The user can select from the options presented and click the Send button to send the email.
From: From Wide Default Email Address.
Recipient: The field name to use as a recipient. We list only Email, User, Contact and Lead fields.
Template: Email template to send. We list only available templates
Subject: Email subject. This field is locked when the template is selected
Mail Body: Email Body. This field is locked when the template is locked
Mass Email action can be configured to preset attributes like Recipient and template to use. You can leverage this feature to configure predefined email actions. The action below is an example to send a case response to the contact.
GridMate provides a default custom action to create contact roles from Contact Roles grid. This action can be added to the Actions menu and made available to the end-user. When the Create Contact Role action is selected the following dialog is displayed. The user can select from the contact, assign the right role, and click the Save button to save the record.
From the displayed data grid, select at least one record to submit.
Click on the Submit for Approval action.
The submission dialog is displayed.
Add your comment and click Submit to proceed with the selected records.
GridMate provides a default custom action to submit a list of records for approval. This action can be added to the Actions menu and made available to the end-user.
Below is an action configuration example. This configuration can produced by the Config. Wizard.
If the approver should be selected by the end user, the action can be configured to capture the approver. See the example below.
GridMate provides a default custom action to approve or reject a list of records. This action can be added to the Actions menu and made available to the end-user. The decision of the approval is defined on the action itself.
From the displayed data grid, select at least one record to process.
Click on the Approve or Reject action.
The approval dialog is displayed.
Add your comment and click Approve or Reject to proceed with the selected records.
Below is an action configuration example to approve the records. This configuration can produced by the Config. Wizard.
Below is an action configuration example to reject the records. This configuration can produced by the Config. Wizard.
GridMate provides a default custom action to call a flow on the selected records. This action can be added to the Actions menu and made available to the end-user. The flow to trigger and its parameters mapping is defined on the action itself.
From the displayed data grid, select at least one record to process.
Click on the $FlowAction action.
The flow dialog is displayed.
Run your flow as usual.
The grid is refreshed once the flow is executed
Below is an action configuration example. This configuration can produced by the Config. Wizard.
The attributes property is used to define the mapping between the flow parameters and the grid properties:
recordIdParam: the id of the current record
idListParam: the list of selected id(s)
itemListParam: the list of selected items
autolaunched: flag to indicate if the flow is an auto launched process. Auto-launched flows are run in the background and no screen is displayed to the end-user.
inputVariables: Pass through flow variables. With this approach, generic flows can be built and configured based on the needs.
At runtime, GridMate will instantiate the flow, populate its attributes based on the mapping, and display it to the end-user.
Below is a global action configuration example. Global action are launched without selection a record like create a new record.
For complex flows that needs more real estate, a modalSize can be set to large for instance.
Below is another example passing the flow input variables. Note that each flow variable declaration should have a type, name and a value.
A flow can be also configured as a record action. The attributes property configuration is slightly different from a global action:
recordIdParam: the id of the current record
itemIdParam: the Id of the current row
autolaunched: flag to indicate if the flow is an auto launched process. Auto-launched flows are run in the background and no screen is displayed to the end-user.
Below is a flow record action example:
GridMate provides a flow to mass convert a list of leads. This flow is available in GridMate extensions.
From the displayed data grid, select at least one record to convert.
Click on the Mass Convert action.
Complete the lead conversion properties (Account/Contact/Opportunity creation, Record Owner).
Submit the flow to convert all the selected leads
Below is an action configuration example. This configuration can produced by the Config. Wizard.
The Multi Clone function enables the creation of N copies of selected records from the data grid.
From the displayed data grid, select at least one record to clone.
Click on the Clone button.
The Clone selected items dialog is displayed.
Set the number of copies and click Yes to proceed with the cloning of the selected records
When the records have been cloned, a confirmation dialog is displayed.
The cloned records are visible on the data grid.
Below is an action configuration example. This configuration can produced by the Config. Wizard.
GridMate provides a default custom action to follow/unfollow a list of records on Chatter. This action can be added to the Actions menu and made available to the end-user.
From the displayed data grid, select at least one record to process.
Click on the Follow or Unfollow action.
The confirmation dialog is displayed.
Click Follow or Unfollow to proceed with the selected records.
Below is a follow action configuration example. This configuration can produced by the Config. Wizard.
Below is an unfollow action configuration example. This configuration can produced by the Config. Wizard.
GridMate provides a default custom action to assign a list of records to a User/Queue. This action can be added to the Actions menu and made available to the end-user.
From the displayed data grid, select at least one record to process.
Click on the Assign action.
The assignment dialog is displayed.
Select the new owner (Internal User/External User or Queue)
Click Submit to proceed with the selected records.
Below is an action configuration example. This configuration can produced by the Config. Wizard.
This action action can be triggered as a Bulk Action.
GridMate provides a default custom action to share a list of records with a User/Group/Role. This action can be added to the Actions menu and made available to the end-user.
From the displayed data grid, select at least one record to process.
Click on the Share action.
The sharing dialog is displayed.
Add the Users/Groups/Roles with the appropriate sharing (Read only | Read/Write)
Click Submit to proceed with the selected records.
Below is an action configuration example. This configuration can produced by the Config. Wizard.
GridMate provides a Reorder Rows custom action, enabling you to rearrange grid rows to your preferred order.
Click on the Reorder Rows action.
Rearrange the rows as needed.
Click Save
Below is the action configuration to reorder Product Lines on an Opportunity page.
Below is an overview of the mapping between the configuration properties above and the action screen:
GridMate provides a default custom action to call a visualforce page on the selected records. This action can be added to the Actions menu and made available to the end-user.
Below is an action configuration example.
The action above will open the visualforce and pass the list of selected recordId(s). To trigger the page individually on the selected records(multiple tabs), recordPage property should set to true as the example below:
GridMate provides a Grid Explorer for grid components (GM - RelatedList Grid, GM - ListView Grid, GM - FieldSet Grid, GM - ListView Kanban and GM - FieldSet Kanban). Through the explorer, the end-user is able to:
Filter the records using Filters tab
Add, remove and reorder columns using Columns tab
Group records using Grouping tab
The Grid Explorer is available only if the property Enable Explorer is checked on the App Builder. When the Grid Explorer is enabled, the filtering, columns and grouping are stored at the user level. Each user has his own settings. If the admin made any changes to layout/listview/fieldset, all the users should be notified to update their settings.
Edit, remove, or add filters to view only the records that meet your criteria. You have different options depending on the field(Picklist, Date, Currency) you want to filter on.
From the available columns dropdown menu, select the field to filter by.
Make a selection or enter a value(s) depending on the type of field
Repeat the same process to add extra columns, then click Apply
You can cancel or reset the filters at any time by clicking on Cancel or Reset. For Picklist, MultiPicklist and Lookup fields, multiple entries can be selected.
Add or remove columns to see only the columns that you are interested in.
From the available columns dropdown menu, select the field to display.
Drag & drop a column to change the order of the displayed columns
You can hide the column by clicking on the delete icon
Repeat the same process, then click Apply
You can cancel or reset at any time by clicking on Cancel or Reset
Add or remove columns to group the records. You can group opportunities by Stages for instance.
From the available columns dropdown menu, select the field to group by.
Drag & drop a column to change the order of the grouping
You can remove the column by clicking on the delete icon
Repeat the same process, then click Apply
You can cancel or reset at any time by clicking on Cancel or Reset
In addition to Quick Actions, VisualForce Page, Call Flow and GridMate actions (Share, Assign, Approval...), LWC Navigation actions can be added as a row level action.
| Label | Description | Type |
|---|---|---|
| Windows | Mac/Linux |
|---|---|
Select Filter
Enables the user to create a new filter or apply an existing filter to the data displayed.
Global
Quick Link Filter
Enables the user to create a Quick Link Filter for the selected filter.
Global
Pin/Unpin Filter
Enables the user to pin or unpin the selected filter.
Global
Edit Filter
Enables the user to edit the selected filter.
Global
Clone Filter
Enables the user to clone the selected filter.
Global
Search Input
Enable the user to search for a specific word in the grid.
Global
Reload Items
Reload the entire grid
Global
Load more Items
Loads more items based on page size defined on the grid.
Global
Freeze Columns
Enables the user to define a set number of columns to freeze.
Global
Export Items
Enables the data displayed in the grid to be exported to an Excel or CSV file.
Global
Edit items
Enables inline editing of the data displayed.
Global
Create Record
Enables the user to add a new record.
Global
Clone Items
Clones selected records.
Record
Delete Items
Enables a record to be deleted.
Record
Actions
Dropdown list enabling access to the GridMate provided and also user-created custom actions.
Record
Windows
Mac/Linux
Down : ALT + k
Up: ALT + SHIFT + k
Down : CTRL + k
Up: CTRL + SHIFT + k
ALT + Z
CTRL + Z
