Skip to Content
This question has been flagged
automatic_email
5 Replies
7083 Views
Avatar
Prajith

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 the mail sending code inside this function ???
Please help me to fix this


Avatar
Discard
Sehrish

Most of the time we need to send an email after successfully completion of some tasks or event. To day I will show you how to send an email in odoo using button click.

Reference: https://goo.gl/z16PBZ

Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best 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 .

Avatar
Discard
Avatar
SterlingKensington
Best Answer

Thank you so much for the info.

Avatar
Discard
Avatar
Joe Albert
Best 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_user_id [int] , @p_mail_created_user_id [int] , @p_mail_status [varchar](10) , @p_mail_status_message [varchar](50) , @p_mail_date_sent [datetime] , @p_mail_last_sent_at [datetime] , @p_mail_delivered [bit] , @p_mail_error [bit] ; SET @p_mail_status = 0; SET @p_mail_delivered = 0; SET @p_mail_error = 0; SET

Avatar
Discard
Joe Albert

Looking for the best keyboard for investment banking? We've got you covered! Our best keyboard for investment banking post will tell you everything you need to know about keyboards for investment banking. Read on to learn more. https://hightechreviewer.com/best-keyboard-for-investment-banking/

Joe Albert

The best tablets for construction drawings are the ones that are durable, dependable, and offer a wide range of features. Of course, not all tablets are created equal. Read more here to find out which tablet is the best for your needs. https://nonstoptechno.com/best-tablet-for-construction-drawings/

Avatar
Smith Clarkson
Best Answer

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

 

Avatar
Discard
Avatar
smithclarkson001
Best Answer

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

Avatar
Discard
OdooBot
You are on the wrong place.

On Wed, Nov 13, 2019 at 1:59 PM smithclarkson001 <installvidmate02@gmail.com> wrote:
Related Posts Replies Views Activity
Automatic Email only if some fields are filled
automatic_email
Avatar
Avatar
1
Jul 21
1798
How can i send the automated mail to internal team in odoo9.0?
automatic_email
Avatar
0
Jan 17
2765
Stop Email " Dear "sales person", You have been assigned to the invoice Solved
emails automatic_email
Avatar
Avatar
Avatar
Avatar
3
Feb 25
8337
Automated emails Solved
automatic_email AutomatedActions
Avatar
Avatar
3
Sep 24
7642
User Error Failed to render inline_template template: {{ object.employee_id.address_home_id.lang}})
automated automatic_email
Avatar
Avatar
Avatar
2
Jul 24
3958