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 回覆

4081 瀏覽次數

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

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
How does drop shipping work in sale order in odoo 11? sales dropshipping odoo11	5 2月 19	7686
The record has been modified, your changes will be discarded. Do you want to proceed? sales quotations odoo11	1 11月 17	7788
Display Page number Body of QWeb report sales qweb reporting odoo11	3 5月 25	11323
How to make a boolean field(in res.config.settings) "true" while installing a module? 已解決 sales odoo11 res.config.settings sale.stock	2 1月 20	7288
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 12月 18	28620