Email Customer the Job Sheets when a Service Appointment is Completed
Step 1: Create a connection
- Navigate to Setup > Developer Space > Connections and click Create Connection.
- Under the Default Services tab, search for and click Zoho FSM.
- Enter the following details and click Create And Connect.
- Connection Name: ZFSM
The Connection Link Name will be populated automatically. - Disable Use Credentials Of Login User.
- Select the Scope ZohoFSM.modules.JobSheets.READ
- Click Connect in the authentication page.
- Click Accept in the Authorization page.
Step 2: Create a custom function
- Navigate to Setup > Automation > Functions and click Create Function.
- Enter the following details and click Save:
- Function Name: SendJobsheetsToCust
- Module: Service Appointments
- In the Deluge Script Editor, enter the following script:
try { file_list = list(); Appointment_id = service_appointment.get("id"); contactId = service_appointment.get("Contact").get("id"); contactResp = zoho.fsm.getRecordById("Contacts",contactId); email = contactResp.get("data").toMap().get("Email"); info email; related_resp = invokeurl [ url :"https://fsm.zoho.com/fsm/v1/Service_Appointments/" + Appointment_id + "/Job_Sheets" type :GET connection:"zfsm" ]; if(!related_resp.isNull() && !related_resp.isEmpty()) { jobsheetResp = related_resp.get("data"); if(jobsheetResp.isNull() || jobsheetResp.isEmpty()) { info "No jobsheets present in the SA !!!"; } else { jobsheet_list = related_resp.get("data").toList(); for each jobsheet in jobsheet_list { Status = jobsheet.get("Status"); if(Status.equalsIgnoreCase("Completed")) { filename = jobsheet.get("Name"); file_id = jobsheet.get("id"); if(!file_id.isNull() && !file_id.isEmpty()) { fileResp = invokeurl [ url :"https://fsm.zoho.com/fsm/v1/Job_Sheets/" + file_id + "/actions/download?type=pdf" type :GET connection:"zfsm" ]; filename = filename + ".pdf"; fileResp.setFileType("pdf"); fileResp.setFileName(filename); file_list.add(fileResp); } } } } } if(!file_list.isEmpty()) { sendmail [ from :zoho.adminuserid to :email subject :"Jobsheets " message :"PFA" Attachments :file:file_list ] } } catch (err) { info err; sendmail [ from :zoho.adminuserid to :zoho.adminuserid subject :"Error in executing the code" message :err ] } |
Step 3: Create a workflow rule
- Go to Setup > Automation > Workflow Rules and click Create Workflow.
- Enter the following details, then click Next:
- Module: Service Appointments
- Rule Name: SendJobsheetsToCust
- Description: On service appointment completion, email the job sheets in service appointment to the customer.
- Select the rule trigger as Edited. Select Specific field(s) gets modified and add the condition When Status is modified to the value Completed. Check Repeat this workflow whenever a Service Appointment is edited. Click Next.
- Select the rule criteria as To all Service Appointments. Click Next.
- Click +Action and select Functions.
- Select Existing Functions and click Next.
- Select the custom function created in the previous step.
- Click Save.
Testing the usecase
- Create a Service Appointment.
- Complete a job sheet in the service appointment.
- Click Complete Work for the service appointment.
The job sheets will be emailed to the contact in the service appointment.
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:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
How do I automatically email the customer the Job Sheets when a Service Appointment is Completed?
To automatically send the completed job sheets to the customer when a Service Appointment is marked as Completed, you can set up an automation in Zoho FSM using custom functions and workflow rules. To implement this automation in your FSM setup, ...Job Sheets
Job Sheets are customizable, reusable forms that serve as a checklist for the services that technicians need to carry out and as a tool for data collection. While on location, the checklists and instructions within the job sheet guarantee that the ...Job Costing
Job Costing in Zoho FSM enables you to track, analyze, and manage all expenses tied to a specific service job. By providing a clear view of labor, services/parts, and travel costs, it helps your business accurately measure job profitability, keep ...What’s the difference between a Service Report and a Job Sheet in Zoho FSM?
A Service Report is a report of the overall Service Appointment. It captures details such as the work performed, technician inputs, and customer acknowledgment (signature and rating), and is typically generated during or after job completion. A Job ...How do I make a Service Report mandatory for a Service Appointment in Zoho FSM?
Making service reports mandatory for a service appointment in Zoho FSM Go to Setup → Transaction Settings Navigate to the Service Appointments section Enable the option “Service Report required for Service Appointment completion” Once enabled, a ...