SlideShare a Scribd company logo
How to Configure Field
Cleaning Rules in Odoo 17
Enterprise
Introduction
Enterprise
In this slide let’s discuss how to configure field cleaning rules in
odoo 17. Field Cleaning is used to format the data that we use
inside Odoo. Odoo 17's Data Cleaning module offers Field
Cleaning Rules to improve data consistency and quality within
specific fields of our Odoo records. By using the field cleaning,
we can correct the typos, correct the spaces between them and
also formats can be corrected.
Enterprise
Lets go to Data Cleaning module and from the configuration,
we can set these rules.
Enterprise
Here we can see the already configured field cleaning rules.
Enterprise
We can configure new rule by clicking on New button. In that
form view, we can give the name for the rule and specify the
model in which cleaning need to be done and choose the
cleaning mode, either manual or automatic. Also we can notify
users, if there are new records to be cleaned. After providing
the details, we can add rules by clicking on Add a line button.
Enterprise
A pop up opens for creating the rule. Here, we can choose the
field to be cleaned and choose the action from the available
options. Here we have chosen to set type case and all cases
will be converted to uppercase.
Enterprise
We can create multiple rules in one field cleaning rule. Here we
have chosen the action to trim all spaces in the field name of
contact.
Enterprise
After setting the rules, we can click on Clean button to see the
records satisfying this cleaning rule.
Enterprise
In the list view of the records satisfying this rule, we can click
on Validate or Discard button, so that rule will be applied to
that record.
Enterprise
In the Contacts module, we can create a contact like this:
Enterprise
If we go to Data cleaning module and click on clean button, we
can see the record to be cleaned. It also shows the current
record name and the suggested name after rule is applied. We
can click on validate to make the rule apply.
Enterprise
After rule is applied, from contact module, we can see the
change. All the spaces are removed and also all letters are
converted to Uppercase.
For More Info.
Check our company website for related blogs
and Odoo book.
Check our YouTube channel for
functional and technical videos in Odoo.
Enterprise
www.cybrosys.com

More Related Content

Similar to How to Configure Field Cleaning Rules in Odoo 17

Workflow Manager
Workflow ManagerWorkflow Manager
Workflow Manager
EMAINT
 
View Solution #48 - Email- Active Directory - Samanage
View Solution #48 - Email- Active Directory - SamanageView Solution #48 - Email- Active Directory - Samanage
View Solution #48 - Email- Active Directory - Samanage
Andrew Peisner
 
Proc contracts
Proc contractsProc contracts
Proc contracts
obulreddy biyyam
 
Proc contracts part1
Proc contracts part1Proc contracts part1
Proc contracts part1
obulreddy biyyam
 
Mobile VoIP Reseller Account generation
Mobile VoIP Reseller Account generationMobile VoIP Reseller Account generation
Mobile VoIP Reseller Account generation
STARSSIP LIMITED
 
How to Empty a One2Many Field in Odoo 17
How to Empty a One2Many Field in Odoo 17How to Empty a One2Many Field in Odoo 17
How to Empty a One2Many Field in Odoo 17
Celine George
 
How to Add / Delete User in OpenERP
How to Add / Delete User in OpenERPHow to Add / Delete User in OpenERP
How to Add / Delete User in OpenERP
Navyug Infosolutions Pvt. Ltd.
 
New features of Maintenance Module in Odoo 17
New features of Maintenance Module in Odoo 17New features of Maintenance Module in Odoo 17
New features of Maintenance Module in Odoo 17
Celine George
 
How to perform critical authorizations and so d checks in sap systems
How to perform critical authorizations and so d checks in sap systemsHow to perform critical authorizations and so d checks in sap systems
How to perform critical authorizations and so d checks in sap systems
TL Technologies - Thoughts Become Things
 
Cis 407 i lab 6 of 7
Cis 407 i lab 6 of 7Cis 407 i lab 6 of 7
Cis 407 i lab 6 of 7
helpido9
 
Model Constraints In Odoo 16
Model Constraints In Odoo 16Model Constraints In Odoo 16
Model Constraints In Odoo 16
Celine George
 
eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module
eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module
eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module
eresource infotech pvt ltd
 
Security and-data-access-document
Security and-data-access-documentSecurity and-data-access-document
Security and-data-access-document
Amit Sharma
 
Premier HR and Payroll integration
Premier HR and Payroll integrationPremier HR and Payroll integration
Premier HR and Payroll integration
Mogbojuri Babatunde
 
Cis407 a ilab 6 web application development devry university
Cis407 a ilab 6 web application development devry universityCis407 a ilab 6 web application development devry university
Cis407 a ilab 6 web application development devry university
lhkslkdh89009
 
Business information systems in organisations
Business information systems in organisationsBusiness information systems in organisations
Business information systems in organisations
Al-Madinah International University (MEDIU)
 
Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records
Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records
Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records
vraopolisetti
 
Salesforce Summer ’22 Release Notes - Highlights
Salesforce Summer ’22 Release Notes - HighlightsSalesforce Summer ’22 Release Notes - Highlights
Salesforce Summer ’22 Release Notes - Highlights
SkyPlanner
 
BEX.pptx
BEX.pptxBEX.pptx
BEX.pptx
Phani163371
 
Oracle Fusion Employment Models
Oracle Fusion Employment ModelsOracle Fusion Employment Models
Oracle Fusion Employment Models
Feras Ahmad
 

Similar to How to Configure Field Cleaning Rules in Odoo 17 (20)

Workflow Manager
Workflow ManagerWorkflow Manager
Workflow Manager
 
View Solution #48 - Email- Active Directory - Samanage
View Solution #48 - Email- Active Directory - SamanageView Solution #48 - Email- Active Directory - Samanage
View Solution #48 - Email- Active Directory - Samanage
 
Proc contracts
Proc contractsProc contracts
Proc contracts
 
Proc contracts part1
Proc contracts part1Proc contracts part1
Proc contracts part1
 
Mobile VoIP Reseller Account generation
Mobile VoIP Reseller Account generationMobile VoIP Reseller Account generation
Mobile VoIP Reseller Account generation
 
How to Empty a One2Many Field in Odoo 17
How to Empty a One2Many Field in Odoo 17How to Empty a One2Many Field in Odoo 17
How to Empty a One2Many Field in Odoo 17
 
How to Add / Delete User in OpenERP
How to Add / Delete User in OpenERPHow to Add / Delete User in OpenERP
How to Add / Delete User in OpenERP
 
New features of Maintenance Module in Odoo 17
New features of Maintenance Module in Odoo 17New features of Maintenance Module in Odoo 17
New features of Maintenance Module in Odoo 17
 
How to perform critical authorizations and so d checks in sap systems
How to perform critical authorizations and so d checks in sap systemsHow to perform critical authorizations and so d checks in sap systems
How to perform critical authorizations and so d checks in sap systems
 
Cis 407 i lab 6 of 7
Cis 407 i lab 6 of 7Cis 407 i lab 6 of 7
Cis 407 i lab 6 of 7
 
Model Constraints In Odoo 16
Model Constraints In Odoo 16Model Constraints In Odoo 16
Model Constraints In Odoo 16
 
eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module
eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module
eresource Xcel ERP | ERP For Manufaturing Indusrty | Admin Module
 
Security and-data-access-document
Security and-data-access-documentSecurity and-data-access-document
Security and-data-access-document
 
Premier HR and Payroll integration
Premier HR and Payroll integrationPremier HR and Payroll integration
Premier HR and Payroll integration
 
Cis407 a ilab 6 web application development devry university
Cis407 a ilab 6 web application development devry universityCis407 a ilab 6 web application development devry university
Cis407 a ilab 6 web application development devry university
 
Business information systems in organisations
Business information systems in organisationsBusiness information systems in organisations
Business information systems in organisations
 
Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records
Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records
Who Sees What When? Using Dynamic Sharing Rules To Manage Access To Records
 
Salesforce Summer ’22 Release Notes - Highlights
Salesforce Summer ’22 Release Notes - HighlightsSalesforce Summer ’22 Release Notes - Highlights
Salesforce Summer ’22 Release Notes - Highlights
 
BEX.pptx
BEX.pptxBEX.pptx
BEX.pptx
 
Oracle Fusion Employment Models
Oracle Fusion Employment ModelsOracle Fusion Employment Models
Oracle Fusion Employment Models
 

More from Celine George

How to Manage Reporting in Events of Odoo 17 Events
How to Manage Reporting in Events of Odoo 17 EventsHow to Manage Reporting in Events of Odoo 17 Events
How to Manage Reporting in Events of Odoo 17 Events
Celine George
 
How to Install Custom Module in Odoo 17 - Odoo 17 Slides
How to Install Custom Module in Odoo 17 - Odoo 17 SlidesHow to Install Custom Module in Odoo 17 - Odoo 17 Slides
How to Install Custom Module in Odoo 17 - Odoo 17 Slides
Celine George
 
Manufacturing New Features in Odoo 17 - Odoo 17 Slides
Manufacturing New Features in Odoo 17 - Odoo 17 SlidesManufacturing New Features in Odoo 17 - Odoo 17 Slides
Manufacturing New Features in Odoo 17 - Odoo 17 Slides
Celine George
 
How to Empty a Many2Many Field in Odoo 17
How to Empty a Many2Many Field in Odoo 17How to Empty a Many2Many Field in Odoo 17
How to Empty a Many2Many Field in Odoo 17
Celine George
 
How to Set Maximum Difference in Odoo 17 POS
How to Set Maximum Difference in Odoo 17 POSHow to Set Maximum Difference in Odoo 17 POS
How to Set Maximum Difference in Odoo 17 POS
Celine George
 
How to use noupdate 0 or 1 in Odoo - Odoo 17 Slides
How to use noupdate 0 or 1 in Odoo - Odoo 17 SlidesHow to use noupdate 0 or 1 in Odoo - Odoo 17 Slides
How to use noupdate 0 or 1 in Odoo - Odoo 17 Slides
Celine George
 
How to Call Python Function from Menu Item
How to Call Python Function from Menu ItemHow to Call Python Function from Menu Item
How to Call Python Function from Menu Item
Celine George
 
How to Clear/delete All Order Lines in Odoo 17 POS
How to Clear/delete All Order Lines in Odoo 17 POSHow to Clear/delete All Order Lines in Odoo 17 POS
How to Clear/delete All Order Lines in Odoo 17 POS
Celine George
 
How to add button in list view Odoo 17 - Odoo 17 Slides
How to add button in list view Odoo 17 - Odoo 17 SlidesHow to add button in list view Odoo 17 - Odoo 17 Slides
How to add button in list view Odoo 17 - Odoo 17 Slides
Celine George
 
What is the Difference Between Lot & Serial Number in Odoo 17
What is the Difference Between Lot & Serial Number in Odoo 17What is the Difference Between Lot & Serial Number in Odoo 17
What is the Difference Between Lot & Serial Number in Odoo 17
Celine George
 
Float Operations in Odoo 17 - Odoo 17 Slides
Float Operations in Odoo 17 - Odoo 17 SlidesFloat Operations in Odoo 17 - Odoo 17 Slides
Float Operations in Odoo 17 - Odoo 17 Slides
Celine George
 
Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17
Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17
Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17
Celine George
 
Multi Language and Language Translation with the Website of Odoo 17
Multi Language and Language Translation with the Website of Odoo 17Multi Language and Language Translation with the Website of Odoo 17
Multi Language and Language Translation with the Website of Odoo 17
Celine George
 
How to Manage Advanced Pricelist in Odoo 17
How to Manage Advanced Pricelist in Odoo 17How to Manage Advanced Pricelist in Odoo 17
How to Manage Advanced Pricelist in Odoo 17
Celine George
 
How to Configure Extra Steps During Checkout in Odoo 17 Website App
How to Configure Extra Steps During Checkout in Odoo 17 Website AppHow to Configure Extra Steps During Checkout in Odoo 17 Website App
How to Configure Extra Steps During Checkout in Odoo 17 Website App
Celine George
 
How to Restrict Price Modification to Managers in Odoo 17 POS
How to Restrict Price Modification to Managers in Odoo 17 POSHow to Restrict Price Modification to Managers in Odoo 17 POS
How to Restrict Price Modification to Managers in Odoo 17 POS
Celine George
 
How to Integrate Facebook in Odoo 17 - Odoo 17 Slides
How to Integrate Facebook in Odoo 17 - Odoo 17 SlidesHow to Integrate Facebook in Odoo 17 - Odoo 17 Slides
How to Integrate Facebook in Odoo 17 - Odoo 17 Slides
Celine George
 
Odoo 17 Project Module : New Features - Odoo 17 Slides
Odoo 17 Project Module : New Features - Odoo 17 SlidesOdoo 17 Project Module : New Features - Odoo 17 Slides
Odoo 17 Project Module : New Features - Odoo 17 Slides
Celine George
 
How to Add Collaborators to a Project in Odoo 17
How to Add Collaborators to a Project in Odoo 17How to Add Collaborators to a Project in Odoo 17
How to Add Collaborators to a Project in Odoo 17
Celine George
 
How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17
How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17
How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17
Celine George
 

More from Celine George (20)

How to Manage Reporting in Events of Odoo 17 Events
How to Manage Reporting in Events of Odoo 17 EventsHow to Manage Reporting in Events of Odoo 17 Events
How to Manage Reporting in Events of Odoo 17 Events
 
How to Install Custom Module in Odoo 17 - Odoo 17 Slides
How to Install Custom Module in Odoo 17 - Odoo 17 SlidesHow to Install Custom Module in Odoo 17 - Odoo 17 Slides
How to Install Custom Module in Odoo 17 - Odoo 17 Slides
 
Manufacturing New Features in Odoo 17 - Odoo 17 Slides
Manufacturing New Features in Odoo 17 - Odoo 17 SlidesManufacturing New Features in Odoo 17 - Odoo 17 Slides
Manufacturing New Features in Odoo 17 - Odoo 17 Slides
 
How to Empty a Many2Many Field in Odoo 17
How to Empty a Many2Many Field in Odoo 17How to Empty a Many2Many Field in Odoo 17
How to Empty a Many2Many Field in Odoo 17
 
How to Set Maximum Difference in Odoo 17 POS
How to Set Maximum Difference in Odoo 17 POSHow to Set Maximum Difference in Odoo 17 POS
How to Set Maximum Difference in Odoo 17 POS
 
How to use noupdate 0 or 1 in Odoo - Odoo 17 Slides
How to use noupdate 0 or 1 in Odoo - Odoo 17 SlidesHow to use noupdate 0 or 1 in Odoo - Odoo 17 Slides
How to use noupdate 0 or 1 in Odoo - Odoo 17 Slides
 
How to Call Python Function from Menu Item
How to Call Python Function from Menu ItemHow to Call Python Function from Menu Item
How to Call Python Function from Menu Item
 
How to Clear/delete All Order Lines in Odoo 17 POS
How to Clear/delete All Order Lines in Odoo 17 POSHow to Clear/delete All Order Lines in Odoo 17 POS
How to Clear/delete All Order Lines in Odoo 17 POS
 
How to add button in list view Odoo 17 - Odoo 17 Slides
How to add button in list view Odoo 17 - Odoo 17 SlidesHow to add button in list view Odoo 17 - Odoo 17 Slides
How to add button in list view Odoo 17 - Odoo 17 Slides
 
What is the Difference Between Lot & Serial Number in Odoo 17
What is the Difference Between Lot & Serial Number in Odoo 17What is the Difference Between Lot & Serial Number in Odoo 17
What is the Difference Between Lot & Serial Number in Odoo 17
 
Float Operations in Odoo 17 - Odoo 17 Slides
Float Operations in Odoo 17 - Odoo 17 SlidesFloat Operations in Odoo 17 - Odoo 17 Slides
Float Operations in Odoo 17 - Odoo 17 Slides
 
Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17
Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17
Prepayment Amount in Odoo 17 - How to Make Partial Payment in Odoo 17
 
Multi Language and Language Translation with the Website of Odoo 17
Multi Language and Language Translation with the Website of Odoo 17Multi Language and Language Translation with the Website of Odoo 17
Multi Language and Language Translation with the Website of Odoo 17
 
How to Manage Advanced Pricelist in Odoo 17
How to Manage Advanced Pricelist in Odoo 17How to Manage Advanced Pricelist in Odoo 17
How to Manage Advanced Pricelist in Odoo 17
 
How to Configure Extra Steps During Checkout in Odoo 17 Website App
How to Configure Extra Steps During Checkout in Odoo 17 Website AppHow to Configure Extra Steps During Checkout in Odoo 17 Website App
How to Configure Extra Steps During Checkout in Odoo 17 Website App
 
How to Restrict Price Modification to Managers in Odoo 17 POS
How to Restrict Price Modification to Managers in Odoo 17 POSHow to Restrict Price Modification to Managers in Odoo 17 POS
How to Restrict Price Modification to Managers in Odoo 17 POS
 
How to Integrate Facebook in Odoo 17 - Odoo 17 Slides
How to Integrate Facebook in Odoo 17 - Odoo 17 SlidesHow to Integrate Facebook in Odoo 17 - Odoo 17 Slides
How to Integrate Facebook in Odoo 17 - Odoo 17 Slides
 
Odoo 17 Project Module : New Features - Odoo 17 Slides
Odoo 17 Project Module : New Features - Odoo 17 SlidesOdoo 17 Project Module : New Features - Odoo 17 Slides
Odoo 17 Project Module : New Features - Odoo 17 Slides
 
How to Add Collaborators to a Project in Odoo 17
How to Add Collaborators to a Project in Odoo 17How to Add Collaborators to a Project in Odoo 17
How to Add Collaborators to a Project in Odoo 17
 
How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17
How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17
How to Manage Different Invoice & Delivery Addresses of a Customer in Odoo 17
 

Recently uploaded

Angular Roadmap For Beginner PDF By ScholarHat.pdf
Angular Roadmap For Beginner PDF By ScholarHat.pdfAngular Roadmap For Beginner PDF By ScholarHat.pdf
Angular Roadmap For Beginner PDF By ScholarHat.pdf
Scholarhat
 
principles of auditing types of audit ppt
principles of auditing types of audit pptprinciples of auditing types of audit ppt
principles of auditing types of audit ppt
sangeetha280806
 
Brigada eskwela 2024 sample template NARRATIVE REPORT.docx
Brigada eskwela 2024 sample template NARRATIVE REPORT.docxBrigada eskwela 2024 sample template NARRATIVE REPORT.docx
Brigada eskwela 2024 sample template NARRATIVE REPORT.docx
BerlynFamilaran1
 
Q1_LE_English 7_Lesson 1_Week 1 wordfile.docx
Q1_LE_English 7_Lesson 1_Week 1 wordfile.docxQ1_LE_English 7_Lesson 1_Week 1 wordfile.docx
Q1_LE_English 7_Lesson 1_Week 1 wordfile.docx
SANDRAMEMBRERE1
 
Class-Orientation for school year 2024 - 2025
Class-Orientation for school year 2024 - 2025Class-Orientation for school year 2024 - 2025
Class-Orientation for school year 2024 - 2025
KIPAIZAGABAWA1
 
PPT Jessica powerpoint physical geography
PPT Jessica powerpoint physical geographyPPT Jessica powerpoint physical geography
PPT Jessica powerpoint physical geography
np2fjc9csm
 
Powerpoint on Classroom Orientation2024-2025
Powerpoint on Classroom Orientation2024-2025Powerpoint on Classroom Orientation2024-2025
Powerpoint on Classroom Orientation2024-2025
MarynolMagbanuaJimer
 
Understanding Clergy Payroll : QuickBooks
Understanding Clergy Payroll : QuickBooksUnderstanding Clergy Payroll : QuickBooks
Understanding Clergy Payroll : QuickBooks
TechSoup
 
How to Use Quality Module in Odoo 17 - Odoo 17 Slides
How to Use Quality Module in Odoo 17 - Odoo 17 SlidesHow to Use Quality Module in Odoo 17 - Odoo 17 Slides
How to Use Quality Module in Odoo 17 - Odoo 17 Slides
Celine George
 
Celebrating 25th Year SATURDAY, 27th JULY, 2024
Celebrating 25th Year SATURDAY, 27th JULY, 2024Celebrating 25th Year SATURDAY, 27th JULY, 2024
Celebrating 25th Year SATURDAY, 27th JULY, 2024
APEC Melmaruvathur
 
Types of Diode and its working principle.pptx
Types of Diode and its working principle.pptxTypes of Diode and its working principle.pptx
Types of Diode and its working principle.pptx
nitugatkal
 
How to Load Custom Field to POS in Odoo 17 - Odoo 17 Slides
How to Load Custom Field to POS in Odoo 17 - Odoo 17 SlidesHow to Load Custom Field to POS in Odoo 17 - Odoo 17 Slides
How to Load Custom Field to POS in Odoo 17 - Odoo 17 Slides
Celine George
 
Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst - P...
Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst  - P...Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst  - P...
Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst - P...
EduSkills OECD
 
Brigada Eskwela editable Certificate.pptx
Brigada Eskwela editable Certificate.pptxBrigada Eskwela editable Certificate.pptx
Brigada Eskwela editable Certificate.pptx
aiofits06
 
Personality Development , Dr. SAROJ KUMAR DATTA
Personality Development , Dr. SAROJ KUMAR DATTAPersonality Development , Dr. SAROJ KUMAR DATTA
Personality Development , Dr. SAROJ KUMAR DATTA
CallplanetsDeveloper
 
sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...
sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...
sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...
ABELARDOBALDOVEAZUEL
 
Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...
Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...
Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...
OH TEIK BIN
 
Lecture Notes Unit5 chapter 15 PL/SQL Programming
Lecture Notes Unit5 chapter 15 PL/SQL ProgrammingLecture Notes Unit5 chapter 15 PL/SQL Programming
Lecture Notes Unit5 chapter 15 PL/SQL Programming
Murugan146644
 
How to install python packages from Pycharm
How to install python packages from PycharmHow to install python packages from Pycharm
How to install python packages from Pycharm
Celine George
 
FINAL MATATAG LANGUAGE CG 2023 Grade 1.pdf
FINAL MATATAG LANGUAGE CG 2023 Grade 1.pdfFINAL MATATAG LANGUAGE CG 2023 Grade 1.pdf
FINAL MATATAG LANGUAGE CG 2023 Grade 1.pdf
Janna Marie Ballo
 

Recently uploaded (20)

Angular Roadmap For Beginner PDF By ScholarHat.pdf
Angular Roadmap For Beginner PDF By ScholarHat.pdfAngular Roadmap For Beginner PDF By ScholarHat.pdf
Angular Roadmap For Beginner PDF By ScholarHat.pdf
 
principles of auditing types of audit ppt
principles of auditing types of audit pptprinciples of auditing types of audit ppt
principles of auditing types of audit ppt
 
Brigada eskwela 2024 sample template NARRATIVE REPORT.docx
Brigada eskwela 2024 sample template NARRATIVE REPORT.docxBrigada eskwela 2024 sample template NARRATIVE REPORT.docx
Brigada eskwela 2024 sample template NARRATIVE REPORT.docx
 
Q1_LE_English 7_Lesson 1_Week 1 wordfile.docx
Q1_LE_English 7_Lesson 1_Week 1 wordfile.docxQ1_LE_English 7_Lesson 1_Week 1 wordfile.docx
Q1_LE_English 7_Lesson 1_Week 1 wordfile.docx
 
Class-Orientation for school year 2024 - 2025
Class-Orientation for school year 2024 - 2025Class-Orientation for school year 2024 - 2025
Class-Orientation for school year 2024 - 2025
 
PPT Jessica powerpoint physical geography
PPT Jessica powerpoint physical geographyPPT Jessica powerpoint physical geography
PPT Jessica powerpoint physical geography
 
Powerpoint on Classroom Orientation2024-2025
Powerpoint on Classroom Orientation2024-2025Powerpoint on Classroom Orientation2024-2025
Powerpoint on Classroom Orientation2024-2025
 
Understanding Clergy Payroll : QuickBooks
Understanding Clergy Payroll : QuickBooksUnderstanding Clergy Payroll : QuickBooks
Understanding Clergy Payroll : QuickBooks
 
How to Use Quality Module in Odoo 17 - Odoo 17 Slides
How to Use Quality Module in Odoo 17 - Odoo 17 SlidesHow to Use Quality Module in Odoo 17 - Odoo 17 Slides
How to Use Quality Module in Odoo 17 - Odoo 17 Slides
 
Celebrating 25th Year SATURDAY, 27th JULY, 2024
Celebrating 25th Year SATURDAY, 27th JULY, 2024Celebrating 25th Year SATURDAY, 27th JULY, 2024
Celebrating 25th Year SATURDAY, 27th JULY, 2024
 
Types of Diode and its working principle.pptx
Types of Diode and its working principle.pptxTypes of Diode and its working principle.pptx
Types of Diode and its working principle.pptx
 
How to Load Custom Field to POS in Odoo 17 - Odoo 17 Slides
How to Load Custom Field to POS in Odoo 17 - Odoo 17 SlidesHow to Load Custom Field to POS in Odoo 17 - Odoo 17 Slides
How to Load Custom Field to POS in Odoo 17 - Odoo 17 Slides
 
Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst - P...
Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst  - P...Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst  - P...
Stéphan Vincent-Lancrin, Deputy Head of IMEP division and Senior Analyst - P...
 
Brigada Eskwela editable Certificate.pptx
Brigada Eskwela editable Certificate.pptxBrigada Eskwela editable Certificate.pptx
Brigada Eskwela editable Certificate.pptx
 
Personality Development , Dr. SAROJ KUMAR DATTA
Personality Development , Dr. SAROJ KUMAR DATTAPersonality Development , Dr. SAROJ KUMAR DATTA
Personality Development , Dr. SAROJ KUMAR DATTA
 
sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...
sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...
sdintegrating21stcenturyskillsinclassroom-basedassessment-240715032004-e59ed7...
 
Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...
Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...
Life of Ah Gong and Ah Kim ~ A Story with Life Lessons (Hokkien, English & Ch...
 
Lecture Notes Unit5 chapter 15 PL/SQL Programming
Lecture Notes Unit5 chapter 15 PL/SQL ProgrammingLecture Notes Unit5 chapter 15 PL/SQL Programming
Lecture Notes Unit5 chapter 15 PL/SQL Programming
 
How to install python packages from Pycharm
How to install python packages from PycharmHow to install python packages from Pycharm
How to install python packages from Pycharm
 
FINAL MATATAG LANGUAGE CG 2023 Grade 1.pdf
FINAL MATATAG LANGUAGE CG 2023 Grade 1.pdfFINAL MATATAG LANGUAGE CG 2023 Grade 1.pdf
FINAL MATATAG LANGUAGE CG 2023 Grade 1.pdf
 

How to Configure Field Cleaning Rules in Odoo 17

  • 1. How to Configure Field Cleaning Rules in Odoo 17 Enterprise
  • 2. Introduction Enterprise In this slide let’s discuss how to configure field cleaning rules in odoo 17. Field Cleaning is used to format the data that we use inside Odoo. Odoo 17's Data Cleaning module offers Field Cleaning Rules to improve data consistency and quality within specific fields of our Odoo records. By using the field cleaning, we can correct the typos, correct the spaces between them and also formats can be corrected.
  • 3. Enterprise Lets go to Data Cleaning module and from the configuration, we can set these rules.
  • 4. Enterprise Here we can see the already configured field cleaning rules.
  • 5. Enterprise We can configure new rule by clicking on New button. In that form view, we can give the name for the rule and specify the model in which cleaning need to be done and choose the cleaning mode, either manual or automatic. Also we can notify users, if there are new records to be cleaned. After providing the details, we can add rules by clicking on Add a line button.
  • 6. Enterprise A pop up opens for creating the rule. Here, we can choose the field to be cleaned and choose the action from the available options. Here we have chosen to set type case and all cases will be converted to uppercase.
  • 7. Enterprise We can create multiple rules in one field cleaning rule. Here we have chosen the action to trim all spaces in the field name of contact.
  • 8. Enterprise After setting the rules, we can click on Clean button to see the records satisfying this cleaning rule.
  • 9. Enterprise In the list view of the records satisfying this rule, we can click on Validate or Discard button, so that rule will be applied to that record.
  • 10. Enterprise In the Contacts module, we can create a contact like this:
  • 11. Enterprise If we go to Data cleaning module and click on clean button, we can see the record to be cleaned. It also shows the current record name and the suggested name after rule is applied. We can click on validate to make the rule apply.
  • 12. Enterprise After rule is applied, from contact module, we can see the change. All the spaces are removed and also all letters are converted to Uppercase.
  • 13. For More Info. Check our company website for related blogs and Odoo book. Check our YouTube channel for functional and technical videos in Odoo. Enterprise www.cybrosys.com