The Latest Flow Tool from Salesforce Labs: Flow DataGrid

Released on March 12, 2020, the Flow Datagrid Pack from Salesforce labs is the latest free tool to improve the form and function of your flows. The pack includes three styles of presentation which allows the users to select multiple records from.

  1. Datatable, think a related list or list view.
  2. Map, yep, you guessed it a map from which users can pick from.
  3. Tile grid, similar to the tiles available on the community home pages.

The package is available on the App Exchange at https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000GAZr7UAH and includes a screenshot of each option.

To demo, let’s present our user with a list of past due opportunities on the home page so we can keep our pipeline up to date. Here’s how it could function:

1) Show a multi-selectable list of all open opportunities where the close date is before today. (This is where the new flow component from Salesforce Labs comes in).

2) Present each opportunity within the flow so that close date, next action, or whatever fields needed can be updated.

3) At the end of the flow we’ll thank them for the updates.

4) Within a few days, let’s hope they see this.

Here’s an overview of our flow, in our next post we’ll review it in depth.

How To Limit Product Availability based on Account Type in CPQ

You may have some products that should only be quoted or sold to a subset of your accounts, so to avoid having users adding them to quotes to be sent to customers and prospects would be a good thing.

One way of accomplishing this would be with multiple price books. You could have one for distributors, one for partners, and a third for customers. But managing multiple pricebooks, especially if you’re already managing multi-currency, is an admin headache that’s best avoided if possible.

Let’s say we have customers, distributors and partners, and some products we sell only to partners, some only to distributors and partners, and then then some we sell to all three.

Custom Actions & CPQ’s Search Filter

The buttons we see within quote lines aren’t your everyday Salesforce button. Each is actually a custom action record, and like most records easily accessible from the object’s tab.

Salesforce CPQ Product Search Fig 2

We’re going to want to find the one for Add Products. and then create a new Search Filter which we can do from the related lists on the action.

Salesforce CPQ Product Search Fig 3

So the key things here:

  1. Target Object and Target Field are going to point to the field on product you want to filter by.
  2. This is value of the filter, so I have a formula field on quotes that simply looks to the related account’s type field.
  3. Finally, we’re going to hide this filter so our end users can’t change it.
    So here’s what we see when we select Add products for a distributor.
Salesforce CPQ Product Search Fig 4

CPQ