Email Updated record
Email Updated record
HI
I'm new to Zoho so sorry if this is a basic question, feel free to point me in the right way of some documentation to read.
The issue I have is the database (A facilities management database) emails certain people when a record is added.
This works well using the email notification setting with the default template.
The issue I have is making it recreate the exact email when anything is changed or updated in the record. This might be contractor assigned or notes added. I want it to send all the information not just the field that's updated
I have achieved some success by adding in a task under automation on the particular form (Issue_Register) but I'm pretty sure its not the right way to achieve what I want. It does send out an email with everything I need except the two fields which are subforms to the main form (Contractor type from the form Contractor_type and Contractor Name from the form Contractor).
below is the email I added into the task of the Issue_Register form, I've highlighted the two fields that don't work, they simply email exactly as written, the Contractor type is exactly as it was inserted from add feild, the contractor name was my attempt to shown the contractor it is assigned to, the other fields all have data in them when emailed.
Test
User submitted data
Auto Number ${Auto_Number}
Reported By ${Reported_by}
Date ${Date_field}
Email ${Email}
Contact Number ${Contact_Number}
Description ${Issue_Discription}
Priority ${Priority}
Contractor Type ${3260547000000012735}
Status ${Assigned}
Contractor ${Company_Name}
Date Assigned ${Date_Assigned}
Estimated Cost ${Estimated_Cost}
Costs Approved ${Approved}
Final Cost ${Final_Cost}
Order Number ${Order_Number}
Notes ${Notes}
Issue Signed off ${Issue_Signoff}
Date of Sign Off ${Date_Completed}