Inline Editing for Salesforce Reports

0
(0)

Hello Trailblazers,

Up until now, reporting was primarily a view-only tool. You mainly built Salesforce reports to visualize your data in different forms, slice and dice the data, add charts to it, and build dashboards. But as we think about what’s next for reports, what if we were to reimagine the entire concept of reporting? Is reporting primarily a tool to view your data? Or can we make it a single-stop shop where you can act on your data as well? What if we build functionality that lets you edit your data directly from a report? Perhaps in the future, we could also add annotations to parts of your report? The annotations could notify other teammates of a discrepancy or change and even create new tasks and events. The possibilities are endless.

With this vision in mind, we came up with Inline Editing on Lightning Reports. As some of you may have already seen, the Summer ’21 release introduced Inline Editing for Text, Number, and Checkbox fields. Currently, we only allow single field edits, and the report refreshes after every edit.

But this is only the beginning! We have an entire roadmap for Inline Editing ahead of us (safe harbor).

Screen Shot 2021-06-02 at 1.09.28 PM.png

In the Winter ’22 release, we plan to include more data types for Inline Editing, including Lookup, Date, and Picklists. And eventually, we want to support multi-field editing.

Let’s dive into each of these. A Lookup is a Salesforce relationship that connects two objects together using a reference field. Reference fields can be added to the standard, custom, and external objects. The behavior of a lookup differs from the other field types because it can refer to the current entity or another parent entity. For example, in the standard Opportunities report, both the Opportunity Name field and the Account Name field are of the type Lookup. To make things intuitive for end-users, we’re designing Inline Editing so users can change Opportunity Name as text while changing Account Name as a lookup from a list of existing values. 

For Date fields, different regions and locales have different formats for displaying dates. For example, the US uses MM/DD/YYYY but Italy’s format is DD/MM/YYYY. We’ve adapted our picker component based on these differences so you can easily edit the date fields in your own locale.

Regarding Picklists, in Winter ‘22, we will support all types except controlling and dependent picklists. Since a report is built across multiple objects, you’ll be able to Inline Editing picklist values across different record types. 

Why isn’t a certain field editable in my report?

image.png

If a field isn’t Inline Editable (shows a lock icon on hover), it could be due to the following reasons:

  1. The data type isn’t supported. Check the releases and roadmap mentioned above to find out what’s currently supported.
  2. The field-level security for the field doesn’t allow you to edit it. Always check to see if you can edit the field in the page layout view. If not, most likely you won’t have privileges to edit it on the report.
  3. The record type plus page layout combination that’s assigned to your profile doesn’t allow you to edit the field. Inline Editing in reports follows the Salesforce architecture.
  4. Other restrictions apply. For example, you can’t edit the Amount when the Opportunity is closed.

More restrictions are documented here.

What’s Next?

So what’s next after we allow you to Inline Edit different data types? With Multi-Field Editing, you’ll be able to Inline Edit a number of fields in consecutive order before saving your changes. This will be helpful when you want to make multiple changes on the go at once, such as updating work item status in a work item report or assigning bugs to a user. Rather than the report refreshing after each edit, you can make a bunch of changes and then refresh your report. 

multi select.png

How do I enable Inline Editing?

Inline Editing is currently (Summer ’21) in Closed Beta so we can test out the feature with a limited set of customers. To enable Inline Editing, follow these steps:

  1. Submit a ticket with Salesforce asking to enable Inline Editing for your Org. Most customers prefer testing the feature out in a sandbox before enabling it in Production.
  2. Enable the Inline Editing perm in your org by going to Settings → Reports & Dashboards. Select the checkbox “Enable Inline Editing in Reports”.
image.png

Once enabled, Inline Editing will be enabled for all users in your Org. It’s not controlled by a user perm.

Have we missed any use cases that you’d like to see? Are there particular scenarios you’re concerned about? Do provide feedback and let us know how we can improve the product.

Forward-looking Statement

This content contains forward-looking statements that involve risks, uncertainties, and assumptions. If any such uncertainties materialize or if any of the assumptions proved incorrect, the results of salesforce.com, inc. could differ materially from the results expressed or implied by the forward-looking statements we make.

Any unreleased services or features referenced in this document or other presentations, press releases or public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make the purchase decisions based upon features that are currently available. Salesforce.com, inc. assumes no obligation and does not intend to update these forward-looking statements.

How useful was this post?

Click on a star to rate useful the post is!


11 thoughts on “Inline Editing for Salesforce Reports”

  • 1
    Sudharsan on June 8, 2021 Reply

    For a particular profile can we give this Inline edit permission?

  • 2
    Ankita Dutta on June 8, 2021 Reply

    @Sudharsan – Right now this is not profile based. But it’s activated for the entire org. What is your use case for activating it per profile ?

  • 3
    Steve Soltis on June 28, 2021 Reply

    My AE is having trouble signing me up for the closed Beta, can you help?

  • 4
    Ankita Dutta on June 28, 2021 Reply

    Hi Steve. I’ll reach out to you via email.

  • 5
    stefan on August 23, 2021 Reply

    very good feature!

    Here a suggestion: Within listviews it is possible, to select multiple records and change them all at once. The same function within reports would boost productivity!

    • 6
      Ankita Dutta on August 23, 2021 Reply

      Hi Stefan,
      That is something we’re working on for the next release. As you can see, multi field edits is the next feature the team is looking into.

  • 7
    Snehal Patel on September 2, 2021 Reply

    Hello Ankita,

    I can’t see this option in reports and dashboard settings so, what to do?

    • 8
      Ankita Dutta on September 2, 2021 Reply

      Hi Snehal,
      Which release is your org on? You can submit a ticket with Salesforce to help enable this feature and they should be able to guide you. Let me know if you run into any issues.

  • 9
    Mona on September 9, 2021 Reply

    I can see on our sandbox winter 22 release, however date inline editing is not part of it. Has it been pushed back?

    • 10
      Ankita Dutta on September 15, 2021 Reply

      Hi Mona,
      What do you mean its not a part of it ? Have you enabled it via Reports & Dashboards settings as mentioned above ?

  • 11
    Pete Ramsey on September 9, 2021 Reply

    What is the timeline for task object fields to have inline editing enabled? This would be a huge productivity boost for users who manage large projects.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.