Automatically create daily reports and send current day's reports as email attachment
Requirement
Schedule custom actions to automatically create labour reports everyday at the specified time and send a filtered report of all the reports corresponding to the current day as an email attachment.
Use case
Let's assume your company has signed with a contract agency to employ maintenance teams. The contractors allocate workers and you will have to send them a labour report everyday. This process can be automated using the Zoho Creator's schedule feature. In an Employee Tracker application, information like number of shifts worked by a worker and labour charge per shift are maintained in the Contract Labour form. The Contract Labour form's records that correspond to the current day will be automatically consolidated and added as a record in the Daily Wages form. In addition, from the Daily Wages form, only the records corresponding to the current date will be sent as email to the contractor's email address. This process takes place everyday at the specified times.
Steps to follow
1. Create two forms with the following details.
Form | Form Link Name | Field Type | Field Name | Field Link Name |
Contract Employees | Contract_Employees | Name | Name | Name |
Single Line | Department | Department | ||
Number | Number of Shifts Worked | Number_of_Shifts_Worked | ||
Currency | Wage Per Shift | Wage_Per_Shift | ||
Currency | Total Wage | Total_Wage | ||
Daily Wages | Daily_Wages | Single Line | Agency | Agency |
Date | Date | Date_field | ||
Subform
| Workers Report
| Workers_Report
| ||
Currency | Total Wage | Total_Wage |
2. Create a schedule with the following details:
3.Click Add New Action > Deluge Script, and save the following Deluge snippet in the Deluge editor.
- // HOUSE KEEPING WAGES
- // Define a variable to calculate total house keeping wage
- total_wage = 0;
- // Create a collection to store subform values
- workers_collection = Collection();
- //Iterate the Contract Employees form to populate the subform rows and calculate total wage.
- for each worker in Contract_Employees[Department == "House Keeping" && Added_Time == zoho.currentdate]
- {
- row = Daily_Wages.Workers_Report();
- row.Name=worker.Name;
- row.Number_of_Shifts_Worked=worker.Number_of_Shifts_Worked;
- row.Wage=worker.Total_Wage;
- total_wage = total_wage + worker.Total_Wage;
- workers_collection.insert(row);
- }
- //Insert a new record into Daily Wages form
- record_id = insert into Daily_Wages
- [
- Added_User=zoho.loginuser
- Agency="Zylker - House Keeping"
- Date_field=zoho.currentdate
- Workers_Report=workers_collection
- Total_Wage=total_wage
- ];
- // SECURITY WAGES
- // Repeat the same steps for calculating total wages report of Security department
- total_wage = 0;
- workers_collection = Collection();
- for each worker in Contract_Employees[Department == "Security" && Added_Time == zoho.currentdate]
- {
- row = Daily_Wages.Workers_Report();
- row.Name=worker.Name;
- row.Number_of_Shifts_Worked=worker.Number_of_Shifts_Worked;
- row.Wage=worker.Total_Wage;
- total_wage = total_wage + worker.Total_Wage;
- workers_collection.insert(row);
- }
- record_id = insert into Daily_Wages
- [
- Added_User=zoho.loginuser
- Agency="Zylker - Security"
- Date_field=zoho.currentdate
- Workers_Report=workers_collection
- Total_Wage=total_wage
- ];
4. Create another schedule with the following details.
5. Click Add New Action > Deluge Script, and save the following Deluge snippet in the Deluge editor.
- sendmail
- [
- from: zoho.adminuserid
- to: "admin@zylker.com"
- subject: "Daily Labour Report"
- message: "Please find the PDF attached of Daily Labour Report"
- attachments:view:All_Daily_Wages [Date_field==zoho.currentdate] as PDF
- ]
See how it works
Related Links
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:
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?
Zoho DataPrep Resources
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
Create Serial Number for subform rows
Requirement Create serial numbers or auto-numbers for subform rows when a new row is added. Use Case In an employee management system, an employee can add up to five dependents. It will be easy for the employees if the dependents added in the subform ...Add subform rows with dynamic data from another subform
Requirement Automatically add rows to a subform and populate it with dynamic data fetched from another subform. Use Case A form named Orders Database contains customer details and their frequent orders in a subform. We have another ...Insert records through email
Requirement When an email is received, content from the email is extracted and used to create records. Use Case The HR team sends an email to shortlisted candidates. Candidates can reply to the email with details that are extracted and added as ...Understand reports
Note: To optimize efficiency and security, support for XLS format has been deprecated, and instead, the XLSX format will be supported with effect from 21-March-2024. We insist you to replace any instance of .xls to .xlsx across Deluge scripts in your ...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 ...
New to Zoho LandingPage?
Zoho LandingPage Resources