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 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 ...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 ...Auto-populate subform data from a form based on lookup selection
Requirements Streamline the process of retrieving and displaying relevant data by auto-populating a subform based on the value selected in a lookup field. Use Case Consider an IT asset management application used by organizations to conduct asset ...Communicate stakeholders about an out-of-stock situation without manual intervention
Requirement When an item runs out of stock, send an automated email to the vendor, and alert the customer that the item is not available. Send an alert to the customer when the item gets restocked. Use Case In an order or inventory management ...
New to Zoho LandingPage?
Zoho LandingPage Resources