Blog

As promised, we will be highlighting feature updates and releases related to Reports and Dashboards through a blog series. For the second part of our installment, we discuss the ‘Attach .csv Files Report Subscription’ functionality.

This feature release is pretty straightforward: reports can now be generated more efficiently via email without the hassle of printing each page, thus making the reporting process more digital and seamless. Sounds modern and techie, isn’t it? But that’s just the tip of the iceberg.

To guide you further on this feature, here is a sample case:

Burgeon Inc., an electronic components manufacturing company, sends out Production and Quality monitoring reports to their Regional Director weekly. They prefer to receive the reports as CSV files so they can easily search, filter, and leave notes to their hearts’ content while analyzing the report.

Promptly updating the key persons with important company metrics is one of the benefits of report scheduling and subscription. Without the hassle of manually running the report, the directors at Burgeon Inc. are on course with the latest status of their production sites, which allows them to deliver their products on time.

The best thing is, the Administrators no longer need to print out the reports and snail-mail them. Instead, they can use Salesforce scheduled reports to send emails with the report file to all subscribed users.

First Step: Report Subscription

Users can subscribe to reports on their own or ask the Admin to it on their behalf.

Users can also subscribe to and set scheduled refresh for dashboards.

The Administrator at Burgeon is responsible for setting up the report subscriptions. One of their weekly reports is configured like this:

Users can personalize their subscription settings such as the schedule of when the report will run, the recipients, and the user running the report.

The report runner setting has two options called ‘Me’ and ‘Another Person’. If the ‘Me’ option is selected, the logged-in user runs the report, and recipients see report data in the emailed report as the user. On the other hand, the ‘Another Person’ option can be used to specify another user who has the permission to run reports and access to the report.

Emailed reports will contain data based on the data visibility of the person running the report. Recipients may view more or less data in the report than what they can actually see in Salesforce.

Optionally, conditions can be added to the subscription settings. Recipients will be notified every time a specified condition is met:

For example, when the report reaches a total of 10 records, a notification will be sent to the recipients.

Winter ‘21 Feature: Report Subscription Attachments

The Winter ‘21 release came with a feature that allows users to receive report results in CSV format as an attachment to the subscription email.

As of Winter ‘21, the Report Subscription Attachments feature is generally available. This was first released as a beta feature in Summer ‘20.

The email only contains the report name in the subject line and all row-level record details are inside the attached CSV file.

The attachment can be configured by editing the subscription settings and clicking the ‘Attach File’ button.

You may also notice that the view options available for the subscription email attachment are the same options for exporting a report: Formatted Report or Details Only. This sets how the report results will be presented in the CSV file.

The report subscription attachment feature makes sending report results seamless, efficient, and trouble-free. 

Before you forget! To enable the users to add attachments to the report subscription emails, an important permission must be granted in the Reports & Dashboards Settings:

Sending reports and acting on the results immediately has never been this easy with this feature in place! It sets up a more efficient workflow by eliminating the need to convert the report results into a more usable format.

Can’t get enough of useful system updates? Brace yourself for another feature highlight in our next blog update! 

What Certification are you studying for now?

Focus on Force currently provide practice exams and study guides for nine certifications

Reports and Dashboard Series: Attach CSV Files to Report Subscriptions

As promised, we will be highlighting feature updates and releases related to Reports and Dashboards through a blog series. For the second part of our installment, we discuss the ‘Attach .csv Files Report Subscription’ functionality.This feature release is pretty straightforward: reports can now be generated more efficiently via email without the hassle of printing each page, thus making the reporting process more digital and seamless.

Reports and Dashboard Series: Attach CSV Files to Report Subscriptions

Focus on People: Yash Arora – Solidifying Salesforce Experience through Certification

Yash is a Sales Operations Manager who has optimized crucial organizational processes using Salesforce. In his pursuit to be a certified Salesforce Admin, he learned that his Salesforce experience is already an edge, and studying for the exam unraveled further Salesforce knowledge that strengthens his current expertise. In this article, he also shared stories of his industry tenure, study habits for the certification, and his future career goals.

Focus on People: Yash Arora – Solidifying Salesforce Experience through Certification

Focus on People: Cary Walkin – Making the Impossible Possible

As an accountant, Cary primarily uses Excel. After taking a new role as a Financial Systems Manager, he was introduced to Salesforce to do the job more efficiently. This pushed him to take Salesforce certifications, making him an in-house expert of the platform. He also shared here his preparations for the exam, the challenges while learning the platform, and how he leveraged his certifications to establish stronger process alignments across the board.

Focus on People: Cary Walkin – Making the Impossible Possible

Batch Apex in Salesforce (Real World Scenarios)

Salesforce has introduced numerous declarative automation tools and features in recent times, significantly decreasing the reliance on Apex code. However, despite these advancements, developers still rely on Batch Apex when dealing with a high volume of records.What is Batch Apex?Batch Apex is used for processing a large number of records. Since the code is run asynchronously, the records are processed within platform limits. Once the batch Apex job is invoked,… Read More

Batch Apex in Salesforce (Real World Scenarios)

Focus on People: Mark van Voornveld – Taking the Big Shift: From Microsoft to Salesforce

Mark van Voornveld is an IT professional with a 30-year career built around Microsoft Azure Stack and Dynamics. While relatively new for him, he chose to transition to Salesforce, seeing it as a fresh path to take and a good addition to his expertise. Here, he shared his professional journey, reasons for this transition, and his adjustments to a new CRM and the essential, non-technical skills that make an IT… Read More

Focus on People: Mark van Voornveld – Taking the Big Shift: From Microsoft to Salesforce

Salesforce Einstein: 24/7 At Your Service!

Sugar, spice, and ‘everything nice’? Salesforce almost has it all now that Einstein, the smart CRM assistant, is already at our service. Einstein was first introduced as part of the Salesforce Spring ‘17 release and is now a component of Salesforce core cloud products. This innovation was built for the Customer Success Platform to break down the complexity of artificial intelligence technology, helping customers leverage AI capabilities. It must be… Read More

Salesforce Einstein: 24/7 At Your Service!

Salesforce: How It Started and How You Can Be Part of the “Ohana”

How did an innovative cloud platform become one of the world’s best CRM solutions?Salesforce has been bringing companies and customers together for over two decades. It began as a Software as a Service (SaaS) company. Salesforce is now the fifth-largest software company in the world. They leverage cloud technology and build a variety of applications for businesses to help better give them key insights into their services through analytics and… Read More

Salesforce: How It Started and How You Can Be Part of the “Ohana”

Apparent Gender Bias Hampers Women’s Career Progression in the Salesforce Ecosystem

by Zoë Morris Flexible and home working are the most desired employment benefits among women working with Salesforce, but their entitlement to these benefits is actually lower than their male counterparts. This is having an adverse effect on gender representation in the Salesforce ecosystem.Mason Frank’s annual salary survey is the largest independent exploration of Salesforce culture. As well as being useful for benchmarking salaries and learning the best education and… Read More

Apparent Gender Bias Hampers Women’s Career Progression in the Salesforce Ecosystem

4 Salesforce Exam Writing Tips to Achieve Salesforce Certification Success

by Cary Walkin Do you have your eye on a Salesforce Certification to advance your career? Perhaps it’s your first certification. Maybe you’re challenging yourself with a difficult certification. I’m a 6x Salesforce Certified professional who has had a career full of exams, and the tips in this guide have helped me and my team pass all of the Salesforce Certification exams that we’ve written. I wrote this guide to… Read More

4 Salesforce Exam Writing Tips to Achieve Salesforce Certification Success

Top 10 Tips for Taking a Salesforce Online Proctored Exam

So you’ve decided to take a Salesforce exam? Congratulations! You’re now one step closer to becoming a Salesforce certified professional. But with the COVID-19 outbreak, taking onsite examinations at a testing center are now not possible.Undergo a safer, more convenient option and take an online proctored exam instead. This is now the perfect time to take these tests especially if you’re worried about the online testing requirements. Because of the… Read More

Top 10 Tips for Taking a Salesforce Online Proctored Exam

Focus on People: Damian Galbally – Maximizing Sales with Salesforce

Damian Galbally became curious about the potential of Salesforce when he was met with some limitations while using it. In this interview, he talked about the challenges he had experienced and how these challenges had shaped the way he helps SMEs maximize Salesforce as a consultant for small businesses today. My name is Damian Galbally, and I am a consultant. My first contact with Salesforce was with a former company I… Read More

Focus on People: Damian Galbally – Maximizing Sales with Salesforce