How to send mail automatically while saving the record

Question

i have a custom module in odoo 12 and i need to send mail
automatically to users who assigned to do  work; When i saving the
record
i have created the email template also
i already have 'create' function for generating the sequence number like
@api.model def create(self, vals): if vals.get('seq_name', _('New')) == _('New'):
vals['seq_name'] = self.env['ir.sequence'].next_by_code('test.sequence') or _('New')
result = super(Test, self).create(vals)
return result how can i solve this, Can i write t

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

You don't need to override the create method for sending the automatic email. You just need to configure automated action to send the email when record is created / updated.
Please follow the instruction given in the link: Automated Action [1] .

[1] https://www.odoo.com/forum/help-1/question/email-notifications-maintenance-equipment-request-136006#

SterlingKensington · Answer

Thank you so much for the info.

Joe Albert · Answer

There is a way to create a stored procedure in Postgres to send an email and also assign it to a record, and you can use trigger on the table to fire the stored procedure. the stored procedure is the following: CREATE OR REPLACE FUNCTION [dbo].[SendPressedEmail_Trigger_sp] ( [p_id_in] [int] ) RETURNS TRIGGER AS $SendPressedEmail_Trigger_sp$ BEGIN DECLARE @p_id [int] , @p_mail [varchar](50) , @p_mail_subject [varchar](50) , @p_mail_message [varchar](max) , @p_mail_body [varchar](max) , @p_mail_us

Smith Clarkson · Answer

Thanks for asking this ... even my query is resolved .... :) https://vidmateapp.win https://tataindicombroadband.in

smithclarkson001 · Answer

Thanks for asking this ... even my query is resolved .... :)

相关帖文	回复	查看
Automatic Email only if some fields are filled automatic_email	1 7月 21	1908
How can i send the automated mail to internal team in odoo9.0? automatic_email	0 1月 17	2851
Stop Email " Dear "sales person", You have been assigned to the invoice 已解决 emails automatic_email	3 2月 25	8532
Automated emails 已解决 automatic_email AutomatedActions	3 9月 24	7907
User Error Failed to render inline_template template: {{ object.employee_id.address_home_id.lang}}) automated automatic_email	2 7月 24	4279

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！