I added a custom field called "x_test_textbox". And then added the field in the Quotation form view. I added the line <style>body,.top-bar{margin-top:1.9em}</style> _sql_constraints = [ ('name_uniq', 'unique(x_test_textbox)', 'text duplicated!!') ] into sale.py and update the webpage. But the custom field is still repeatable. Does somebody know to solve this problem?

Add a custom field with unique attribute in Sales/Quotation

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

All apps

1 ตอบกลับ

4217 มุมมอง

I added a custom field called "x_test_textbox". And then added the field in the Quotation form view. I added the line

_sql_constraints = [ ('name_uniq', 'unique(x_test_textbox)', 'text duplicated!!') ]

into sale.py and update the webpage. But the custom field is still repeatable. Does somebody know to solve this problem?

คำตอบที่ดีที่สุด

Hi,

I think you have to try it in anew database, sql constrains will not get into effect in an existing database.

So create a test db and install the module and see whether it is working as expected or not.

Thanks

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

Related Posts	ตอบกลับ	มุมมอง
How does drop shipping work in sale order in odoo 11? sales dropshipping odoo11	5 ก.พ. 19	7814
The record has been modified, your changes will be discarded. Do you want to proceed? sales quotations odoo11	1 พ.ย. 17	7933
Display Page number Body of QWeb report sales qweb reporting odoo11	3 พ.ค. 25	11495
How to make a boolean field(in res.config.settings) "true" while installing a module? แก้ไขแล้ว sales odoo11 res.config.settings sale.stock	2 ม.ค. 20	7502
Boolean Field. How can I make all other records FALSE when a single record is made TRUE? Only ONE "True" boolean at a time? แก้ไขแล้ว unique select boolean odoo11	5 ธ.ค. 18	28803