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:

관련 게시물	답글	화면
Computed Field Using Two Different Models computed-fields Studio	1 4월 24	2742
Upgrading from 17 to 18 : Computed fields computed-fields Studio v18	1 2월 25	1602
How to compute a bool field in Studio? 해결 완료 fields: computed-fields Studio	1 5월 21	4652
Studio compute field with condition compute studio computed-fields Studio	2 8월 22	5422
Is Computed Fields working on Studio?? computed-fields Studio EE v14	1 10월 20	2138

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!