Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Artificial Intelligence
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Email dynamic fields

Subscribe

Get notified when there's activity on this post

This question has been flagged
fieldsemailtemplatedynamicbuilder
1 Reply
12589 Views
Avatar
Martin T

I'm customizing the Sales Order - Send by Email template. and I want to change the one of the first lines of the template.

Hello ${object.partner_id.name},

to

Dear $(object.partnerIid.title) $(object.partner_id.name),

Unfortunately this is not working.

I get browse_record(res.partner.tittle,6) instead of Sir.

How can I change the template so I get the correct title?

0
Avatar
Discard
Avatar
Paul Catinean
Best Answer

First of all you have a typo in your code

Dear $(object.partnerIid.title) should be ${object.partner_id.title}

Next the title is a model that is linked by a many2one relationship from the partner model, it has two fields called name and shortcut, hence you need: ${object.partner_id.title.name} or ${object.partner_id.title.shortcut}

Use the dynamic value builder or check the fields that come from the object and search them up in the interface.If they are a char/int/text and you stop there and if it's another object that you further need to look for subfields and append them to the placeholder

Best,
Paul Catinean

2
Avatar
Discard
Martin T
Author

Yes, I noticed the typo when I double checked the field. But that was just after I asked the question here.

Martin T
Author

Your solution works great for the english e-mail, but unfortunately not for the translated e-mail. I tried to check te box in the dynamic value builder, but then I could not save the form because it was a base field. Do you have any suggestion how I can proceed?

Paul Catinean

I'm not sure what you mean by that, it is possible that there is no translation available or there's a different template used.Normally though it should do the exact same operation only pass the language in the context and get the translation instead of the original value.You do not get any error or output whatsoever? Give a few more details please

Martin T
Author

Oke, what i'm trying to say is the following: The $(object.partnerid.title) works in the english template. I got as expected the text "Dear mister ...", but when I open the same template in the Dutch language, I got "Geachte mister...." instead of "geachte dhr ...". So I checked if the object has a dutch translation in the database, and it exists. When I check the field in the dynamic value builder I noticed that there is a checkbox, "translatable" which is not selected by default, when I check marked the box, and try to save it give my an error, cannot save because it's a base field.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Dynamic Email Template Fields
fields email template emailtemplate v14
Avatar
Avatar
Avatar
2
Nov 25
4554
Add company logo to template email, odoo 15
email template
Avatar
Avatar
Avatar
2
Jan 24
6592
Problem with email template (SOLVED) Solved
email template
Avatar
Avatar
2
Jan 24
12546
How to use IF ELSE (conditional clause) in email template
email template
Avatar
Avatar
1
Mar 21
11718
Permissions for using Email Template to send quotation
email template
Avatar
0
Jan 19
8966
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now