Email Alerts - Message Customization get doc values to show in HTML

1

I am creating an email alert for an expense claim approval. In the message HTML I need the value of Expense claim type and description. How do I get this ?

Thanks

2

Hello @Sri,

Just follow the instruction below the Email Alert Record.
If you wanted to know the exact name of the field just click the button “View Properties (via Customize Form)”

image
image1150×450 12.5 KB

Or

Go to Setup > Doctypes > search your selected doctype for your Email Alerts

3

29 AM
29 AM912×202 10.4 KB

I need to send the expense claim type and description in the email message as well. How do I access these fields in the email message.

4

Still looking for a solutions to this issue. Any help is deeply appreciated.

5

@Sri

Use following code to fetch value from another doc.

 {{ frappe.db.get_value("Currency", "INR", "symbol") }} <br>
 {{ frappe.db.get_value("Expense Claim Type", "Travel", "description") }}

Also it will helpful if you fix user manual.
https://erpnext.org/docs/user/manual/en/setting-up/email/email-alerts