Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
3235 Widoki

Hello

I want to create 5 fields of selection type: N1, N2, N3, N4 and N5. Each field must have 3 possible selections. "Yes", "No" and "Do not apply"

And I need to calculate in another field the percentage of "Yes" answers out of the total fields.

Is it possible with Odoo Studio?



Thanks


Awatar
Odrzuć
Najlepsza odpowiedź

Hi,
The Selection fields can be directly created with the Odoo studio. Drag and drop 'Selection' from the Add > New fields selection and in the field properties popup add the required selection options - 'Yes', 'No', 'Do not apply'.

For the percentage calculation a Decimal(float) field can be used. We have to define a compute function for this float field. For that select the field, cllck on the 'More' option under the Properties tab. In the form view , you can see the options to provide Dependencies and Compute function.

In the dependencies provide the names of the 5 selection fields separated by comma. For example - x_studio_n1, x_studio_n2,x_studio_n3, x_studio_n4,x_studio_n5.
In the Compute field provide the code to calculate our percentage.

Sample Code:

for record in self:
  yes_count = 0
  if record.x_studio_n1 == 'Yes':
    yes_count += 1
  if record.x_studio_n2 == 'Yes':
    yes_count += 1
  if record.x_studio_n3 == 'Yes':
    yes_count += 1
  if record.x_studio_n4 == 'Yes':
    yes_count += 1
  if record.x_studio_n5 == 'Yes':
    yes_count += 1    
  record['x_studio_percentage'] = yes_count*100/5

Regards

Awatar
Odrzuć
Autor

Thank you so much, I prove it and it works perfectly¡

Powiązane posty Odpowiedzi Widoki Czynność
1
lis 21
2786
0
lip 22
1796
0
maj 22
2271
1
kwi 25
1434
1
gru 24
2871