I have a standard form view that includes a computed float field as follows. I would like to change the color of the field based on it's value. For example 0 0.2 == green I know I can set the color of the field like this but I can't figure out how to apply conditional formatting to a style. Everything I've found in searching seems to only apply to the tree view.

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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

How to apply conditional formatting to a form view field?

fields xml style colors studio

2 الردود

21203 أدوات العرض

Pierre de Giorgio

I have a standard form view that includes a computed float field as follows.

I would like to change the color of the field based on it's value.

For example

0 < x_margin < 0.1 == red

0.1 < x_margin < 0.2 == yellow

x_margin > 0.2 == green

I know I can set the color of the field like this

but I can't figure out how to apply conditional formatting to a style. Everything I've found in searching seems to only apply to the tree view. I would like to apply this to a field in a form view.

Ray Carnes

أفضل إجابة

Can you just put a label above/below/near the field?

Don't follow this snippet exactly - I used the existing MARGIN field which is a flat dollar margin amount - but you should be able to get what you want if you understand what I did here:

<label colspan="2"
            string="YOU ARE FIRED IF YOU SELL AT THESE PRICES"
            attrs="{'invisible': [('margin','<', 45)]}" style="background-color:yellow;"/>
<label colspan="2"
            string="HEALTHY COMMISSION CHECK COMING YOUR WAY!"
            attrs="{'invisible': [('margin','>=', 45)]}" style="background-color:palegreen;"/>

Pierre de Giorgio

الكاتب

Ray Carnes thanks for the help - I used your idea and did this instead.

<field name="x_elec_lab_mar" attrs="{'invisible':[('x_elec_lab_mar','>',0.3)]}" style="background-color:green;" nolabel="1" readonly="1"/>

So basically I'm showing the field twice and just making the other condition invisible so it just shows one at a time. Not the most elegant solution but it does work.

I was hoping there was a way to directly inject some conditional statement for the style attribute.

Ray Carnes

Just check the the field has a value both times - there aren't many cases where you can show a field twice in the same view and have the value work on the second occurance of the field.

Pierre de Giorgio

الكاتب

I actually have it on there 3 times (3 colors) and it seems to work for all cases. I tested it and changing a value changes all 3 instances. Thanks for the warning though. I will keep an eye on it.

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
How to truncate Field contents? views fields xml origin studio	2 يونيو 17	7175
unbild decimail place fields studio	1 فبراير 25	1473
Remove (studio) custom field تم الحل fields studio	1 مارس 23	5795
Studio changes create a big mess in XML تم الحل xml studio	1 مارس 25	3321
Editing Fields تم الحل fields studio	2 نوفمبر 20	4023

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!