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:
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
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 ...Form workflow actions
What does this page cover Learn about the various actions available in form workflows and how to configure them effectively. Before proceeding, ensure you have a comprehensive understanding of form workflows and how to create them. Availability ...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 ...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 ...Limitations: Reports
General Duplicating a report is not supported when it displays data from 150 fields or more in each record. For displaying subform data in a report you can use up to 20 fields as ‘display fields’. Displaying multi-select/checkbox and subform fields ...
New to Zoho LandingPage?
Zoho LandingPage Resources