Schedule a monthly email with report as pdf
Requirement
Schedule a monthly sales
report to the sales manger in
a
PDF with stats on achieved sales
versus
target
for the month.
Use Case
A sales management app records sales activities and numbers to track the performance of its sales team and the overall business.
The sales manager needs a monthly report
that
graphs the achieved sales as compared to the target, in
a
PDF.
Steps to follow
|
Form
|
Form Link Name
|
Field Type
|
Field Name
|
Field Link Name
|
|
Sales
|
Sales
|
Single Line
|
Sales Rep
|
Supplier_Name
|
|
Name
|
Customer Name
|
Customer_Name
|
||
Subform
|
Order
|
Order
|
||
|
Currency
|
Total Cost
|
Total_Cost
|
||
|
Target vs Achieved
|
Target_vs_Achieved
|
Date
|
Date
|
Supplier_Name
|
|
Currency
|
Target Sales
|
Target_Sales
|
||
|
Currency
|
Achieved Sales
|
Achieved_Sales
|
The
Target vs Achieved
form is used for the monthly reporting. The
Date
and
Target Sales
field values are provided manually every month. The Achieved Sales field's value is calculated by adding up all the values in the
Total Cost
field for each month.
2. Create a Pivot Chart report
named
Forecast vs Actual
based on the form
Target vs Achieved, with the settings as displayed below. Plot the
Date
field on the X-Axis, and
Target Sales
and
Achieved Sales
fields on the Y-Axis.
3. Configure a schedule
with the following details:
4. Click
Add New Action
and select
Deluge Script.
5. Save the following Deluge snippet in the Deluge editor:
-
// Fetch all records from Sales form for the current month
-
-
sales_records = Sales[ID != 0 && Date_field in this month];
-
-
// Calculate the total sales
-
total_sales = sales_records.sum(Total_Cost);
-
-
// Fetch records from Target_vs_Achieved form and sort in descending order to have the latest record (current month) on top
-
forecast_records = Target_vs_Achieved[ID != 0] sort by Added_Time desc;
-
-
// Assign the total sales value to the Achieved Sales field in the first record
-
forecast_records.Achieved_Sales=total_sales;
-
-
// Send mail with the attachment to the sales maneger
-
sendmail
-
[
-
from: zoho.loginuserid
-
subject: "Monthly Report"
-
message: "Please find the attached monthly sales report"
-
attachments:report:Forecast_vs_Actual as PDF
-
]
The script calculates the total sales for the month, and assigns the value to the
Achieved Sales
field. The report containing this value and the forecast value is then sent as an attachment.
See how it works
Points to Note
-
It is recommended to place the send mail snippet in a separate scheduler with some time gap. This ensures there is sufficient time for fresh data to be generated with new calculations in the Pivot Chart before the attachment is sent.
-
Pivot Charts can only be sent in a PDF. Learn more about the send mail task and the supported formats for various report types.
Related Links
-
Learn more about the send mail Deluge task.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Zoho FSM Video Tutorials
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Send Page as PDF Attachment via Email
Requirements Schedule an email to send a Zoho Creator page as a PDF attachment at defined time intervals using Deluge's sendMail task. Use Case To support customer engagement and business promotion, an organization uses the Pages feature in Zoho ...Configuring data access actions for schedule workflows
What does this page cover Learn how to configure data access actions in Zoho Creator schedule workflows to add a new record, modify or delete an existing record in any form in your application. Before proceeding, ensure you have a comprehensive ...Create pivot chart from live application
You can create a pivot chart from the live mode of the application shared with you using shared analytics. To enable this feature, the admin needs to provide Create Report permission. To create a new report from live application: Click the Create ...Schedule workflow actions
What does this page cover Learn about the various actions available in schedule workflows and how to configure them effectively. Before proceeding, ensure you have a comprehensive understanding of schedule workflows and how to create them. ...Create pivot table from live application
You can create a pivot table from the live mode of the application shared with you using shared analytics. To enable this feature, the admin needs to provide Create Report permission. To create a new report from live application: Click the Create ...
New to Zoho LandingPage?
Zoho LandingPage Resources