Customize your Pipeline View

Fields, Filters, Spotlights, oh my!

Updated this week

Fields & Sorting

Add Salesforce fields that are critical to your workflow into the view, move them where you need them, and sort them as desired! πŸŽ‰ You can even bring in cross-object fields!

πŸͺ„ Suggestion: To combine Account and Opportunity info, start in your opportunity pipeline. To combine Account and Contact info, start in your Contact pipeline.

🚨 You are able to view cross-object fields that have a one-to-one relationship with the object you are in.

  • One-to-one:- In one-to-one relationship, an object is only connected with one other object. It is a fundamental relationship between two objects

    • Example: every opportunity has ONE account it is related to, creating a 1:1 relationship.

  • One-to-many:- In one-to-many relationship one object is connected with many objects.

    • Example: an account can have MANY opportunities, so this would be a one-to-many relationship

❓ In a Pipeline View, is it possible to unlock and move the default first column?

β†’ Not as of today, the left-most column is locked and all others are able to be moved.

❓ Do hyperlinks within text fields work in Scratchpad?

β†’ As of today, hyperlinks within text fields are not supported in Scratchpad.

❓ Why is the "Next Meeting Scheduled" Calendar Icon only populating next to certain Opportunities?

β†’ The calendar icon will automatically appear next to an Opportunity if you have a Google Calendar event with an invitee whose email matches the Contact Role assigned the Opportunity. Keep in mind, Scratchpad syncs with your calendar at the top of the hour.

❓ Does Scratchpad inherit formatting from SFDC for "number" fields?

β†’ As of today, we only add formatting (like commas) to currency fields


Row Height

Change the row height on your Pipeline Grid views to improve the UI or allow long form fields to wrap their text.

  1. Open the Pipeline Grid view and select the view you'd like to update

  2. Select the icon from the menu that is 3 lines with arrows pointing up and down

  3. Choose what height you'd like from the drop-down menu

    1. Options include - Short, Medium, Tall and Extra Tall

  4. Changes save automatically and are applied only to the current view


Naming Views

Don't forget to rename your Grid or Kanban views so you can quickly differentiate between them! ⬇️


Folders

You can create folders for Scratchpad Pipeline Views to stay organized, reduce clutter, and focus on what's most important moment to moment.

To Create a Folder:

  1. Open the Pipeline tab of your Scratchpad Workspace in the top left-hand corner of your screen

  2. Hover over the Header "My Views" and you'll see a plus button appear to the right

  3. Select "New Folder" from this menu and give your new folder a title

To Manage Your Folders:

  1. Click on the toggle triangle to the left of the Folder to open and close the folder.

  2. If you want to move views from one folder to another simply OPEN BOTH folders and drag and drop the notes from one folder to the next.


Filtering

Basic Filtering

Use Filters to view records that fit your specific criteria, you can really get creative here!

Examples: [Close Date] [is] [This Month], [Opportunity Owner] [is] [xx], [Last Activity] [is before] [Today], [Created Date] [is on or after] [Number of Days ago] [xx], etc.

❓ Can I edit the "Last 90 days" filter?

β†’ You can customize the date range by scrolling down to the bottom of the preset options to "Number of days ago" and then entering in your desired number. Let's say you want to see what opps/accounts were created within the last 30 days (so this includes 30 days ago AND anything up until present day), use the "is on or after", "number of days ago" filters and enter the number of days that concerns you.

❓Can I filter for a specific date range?

β†’ Of course! You can create a sandwich with filters.

1. XYZ date "is on or after" [select date]

2. XYZ date "is on or before" [select date}

❓ But I am not the record owner. Can I still surface the records I want?

β†’ Of course! Check out this article to dive into customizing these filters.

❓ Can't find a field you're looking to filter by?

β†’ It's possible that the Field you are wanting to filter on is a Long Text or Text Area Field. This field type is not currently supported by Filters in Scratchpad due to a Salesforce limitation, but you can spotlight the field as a workaround!

❓ Can Scratchpad filter Amount/Currency Fields on converted currency amount, or just the display amount?

β†’ Today, Scratchpad only Filters on the numeric value entered into the Amount field, not the converted amount. As a result, opps matching the numeric value in the filter will be included, regardless of currency.

❓ What determines the "My Team" scope?

β†’ This is based on your SFDC Hierarchy and assigned Roles. Here's a Salesforce Article that may help to adjust your Roles if they are not populating correctly.

❓ How can I filter for deactivated or inactive users?

β†’ You can add a cross-object filter from Opportunity Owner for "Active is false" and surface all deactivated users. If you want to narrow down the list to a specific person, you can add a a filter for Opportunity Owner "Last Name is xx".

❓ Is there a limit to the number of filters I can add to a view?

β†’ There is no limit!


Advanced Filtering

Do you need add "or" to your filtering? Boolean logic? We all know that surfacing the records you desire can be a little complicated. Don't worry, with Advanced Filtering, you can hone in on just the records you care about.

To use advanced filtering:

  1. Open your Pipeline to a Grid or Kanban View you'd like to update

  2. Select Filters in the menu toolbar and toggle on the Advanced Filters button in the top right-hand corner

  3. Select for ANY or ALL of the following conditions.

  4. When adding additional filters select CONDITION for a new rule or GROUP to set a new level of subsequent rules

  5. Continue to add groups and conditions as needed.


Cross-Object Filtering

Applying cross-object filtering within your Scratchpad Pipeline Views has never been easier. Apply filters from other objects to hone in on exactly the records you want to see.

πŸ‘€ Look for the [ > ] next to the field names. After you select the cross-object field, you will see the πŸ”— icon.

πŸͺ„Suggestion: Filter by account information in your opportunity pipeline. Filter by account information in your contact pipeline.

🚨 You are only able to filter on cross-object fields that have a one-to-one relationship with the object you are in.

  • One-to-one:- In one-to-one relationship, an object is only able to be connected with one other object. It is a fundamental relationship between two objects.

    • Example: every opportunity has ONE account it is related to, creating a 1:1 relationship.

  • One-to-many:- In one-to-many relationship one object is able to be connected with many objects.

    • Example: an account can have MANY opportunities, so this would be a one-to-many relationship.


Spotlights (Highlights)

Deal Spotlights

Scratchpad's Deal Spotlighting makes it easy to add focus to your priority opportunities or your team initiatives. Deal spotlighting adds a touch of color to your Pipeline Views without losing any visibility of any details within your view!

To add Deal Spotlights:

  1. Open a Pipeline Grid or Kanban View

  2. Click on Highlighting at the top of your View

  3. Select + Add Highlight and select + Add custom highlight

  4. Define a rule:

    1. From the first drop-down select the field you want to define the rule for

    2. From the second drop-down select the logic for your rule

    3. From the third drop-down enter or select the value for your rule

  5. Cells are now spotlighted based on the rule you defined and you can add multiple spotlights to any view.

πŸͺ„ PRO TIP: You can also hide a deal spotlight by selecting the eye icon or dispose of the spotlight by clicking on the trash icon

Grid View ⬇️

Kanban View ⬇️

❓If a cell in Grid View meets the criteria for two different spotlights, which color wins?

β†’ Whichever filter you have on top, wins. If you change the order, the color will change.


Change Spotlights

Audit Trail tracks the changes you or your team have made to any field from Scratchpad. The spotlight feature in the pipeline spotlights the fields that have been changed in Scratchpad in the last seven days. The History tab within the expanded view of any record, shows your change history for that specific record.

  1. Click on HIGHLIGHT button (along the top of your view)

  2. Select UPDATES LAST 7 DAYS

    • You may change the color of the spotlight by clicking the colored circle and selecting a new color option.


Advanced Calculations

  1. Open your Pipeline Grid View and Opportunities

  2. To calculate the number of opportunities, click Calculate at the bottom of your view and Count All

  3. To calculate the total value of your opportunities, click Calculate at the bottom of your view and Sum

Benefits:

βœ… Always know the value of your pipeline & when you need to prospect for more opportunities

βœ… Be prepared for 1:1's with leadership!


Grouping

Grouping within Pipeline Grid Views helps you organize your deals based on what matters to you.

Salesforce reports allow grouping, but reports are not in-line editable and records open in a new tab. This makes updating Salesforce from within the report difficult. With Scratchpad, you can Group your Pipeline into manageable sections and do calculations, make updates in-line, or open a record to see details, all without opening a new tab!

Examples:

Managers/team leads - grouping a team's opportunities by opportunity owner

Account executives - grouping opportunities by stage

Customer success - grouping support cases by status

To Group your Pipeline:

  1. Open your Pipeline Grid View

  2. Click on Group

  3. Select what you want to group by:

    1. For Reference fields (like Record Owner, Assigned BDR, etc) you will be asked to choose who you want to group by.

    2. For Picklist fields (like stage, forecast category, etc), your view will be grouped by each picklist values automatically.

    πŸ”₯ You can also leverage Advanced Calculations for each group!

🚨 Today, you cannot export from a grouped view so it is suggested that you duplicate your current view, remove group, then export.

❓ Can I Group by cross-object fields?

β†’ As of today, you cannot Group by cross-object fields

❓ Can I Group by close date?

β†’ As of today, you cannot Group by dates.

❓ Why are some values missing in my Grouped View?

β†’The Group will not surface if there are no applicable records within them.

To Ungroup your Pipeline:

  1. Open desired Pipeline View

  2. Click on your Current Grouping and then REMOVE GROUP


Kanban Views

Kanban view presents each record as a card, and is organized into columns, which can be grouped in myriad ways: by Opportunity Stage, by Forecast Category, or Lead Source, etc. Each "card" within the column, displays key pieces of information such as opportunity name, closing date, amount, probability. You can customize each card by adding additional fields from your Salesforce instance.

  1. Clicking the '+' icon next to 'My Views' on the left menu in pipeline

  2. Select 'Kanban view'

  3. Choose the 'group by' field you wish to use (stage, lead, type, etc)

  4. Choose your "Summarize by" field (Amount, ACV, ARR, etc)

  5. From there, customize your columns (click 'customize columns'):

    • Do this by checking (or unchecking) the options that surface in the picklist

  6. Then, customize your cards (click 'customize cards'):

    • Do this by checking (or unchecking) the fields that surface in the picklist

  7. Ensure you are seeing the records you want to see by clicking FILTER and creating the conditions/parameters desired. Leverage Advanced Filtering (and/or logic) and Cross-Object Filtering as well.

❓ Why is the Field that I selected not populating in my Kanban View?

β†’ If that field is null/empty, it will not show on the card in your Kanban View.


Did this answer your question?