Computed field with two conditions with STUDIO

Question

Hi Everyone,
I am trying to create a computed field in Studio that is linked to two conditions, but I'm struggling to make it work.

I've used the below :
for record in self :
if record.x_studio_contract_par_sun ==False:
record['x_studio_commission_sun'] = 0
if record.x_studio_contract_par_sun ==True:
record['x_studio_commission_sun'] = record.x_studio_tarif_location * 0.10

Do you have any idea what I am doing wrong ?
I've seen maybe it should be linked to a control_var, but can't find info any

Jainesh Shah(Aktiv Software) · Accepted Answer

Hey Melanie Turleque,

I hope you are doing well.

Use the below code to compute the field.

for record in self:
record[‘x_studio_commission_sun’] = 0
if record[‘x_studio_contract_par_sun’] and record[‘x_studio_tarif_location’]:
record[‘x_studio_commission_sun’] = record[‘x_studio_tarif_location’] * 0.10

Note:- Check Indentation of the code after pasting the code.
Add x_studio_contract_par_sun and x_studio_tarif_location in the dependencies.

Hope this will help you.
Thanks & Regards,
Email:

bluewaplus · Answer

Your code looks mostly correct. Make sure to use the correct field names and check if the conditions are being evaluated as expected. Also, ensure the computed field is correctly set up in Studio. If issues persist, consider using a control_var for better control. Double-check your field names and conditions for accuracy.

Melanie Turleque · Answer

Thank you for the help ! very much appreciated. It works ! Brilliant.

Chris TRINGHAM · Answer

You should be able to replace
if record.x_studio_contract_par_sun ==True:  with
else:

Relaterade inlägg	Svar	Vyer
Computed Field Using Two Different Models computed-fields Studio	1 apr. 24	5025
Upgrading from 17 to 18 : Computed fields computed-fields Studio v18	1 feb. 25	3705
How to compute a bool field in Studio? Löst fields: computed-fields Studio	1 maj 21	6314
Studio compute field with condition compute studio computed-fields Studio	2 aug. 22	7452
Is Computed Fields working on Studio?? computed-fields Studio EE v14	1 okt. 20	3367

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!