Skip to Content
This question has been flagged
automatic_email
5 Replies
8315 Rodiniai
Portretas
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


Portretas
Atmesti
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

Portretas
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 .

Portretas
Atmesti
Portretas
SterlingKensington
Best Answer

Thank you so much for the info.

Portretas
Atmesti
Portretas
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

Portretas
Atmesti
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/

Portretas
Smith Clarkson
Best Answer

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

 

Portretas
Atmesti
Portretas
smithclarkson001
Best Answer

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

Portretas
Atmesti
OdooBot
You are on the wrong place.

On Wed, Nov 13, 2019 at 1:59 PM smithclarkson001 <installvidmate02@gmail.com> wrote:
Related Posts Replies Rodiniai Veikla
Automatisation of mails to customers
automatic_email
Portretas
Portretas
Portretas
3
rugs. 25
1000
Automatic Email only if some fields are filled
automatic_email
Portretas
Portretas
1
liep. 21
2782
How can i send the automated mail to internal team in odoo9.0?
automatic_email
Portretas
0
saus. 17
3815
Stop Email " Dear "sales person", You have been assigned to the invoice Solved
emails automatic_email
Portretas
Portretas
Portretas
Portretas
3
rugs. 25
9451
Automated emails Solved
automatic_email AutomatedActions
Portretas
Portretas
3
rugs. 24
9828