This question has been flagged
1 Reply
5634 Views
fields
Avatar
Yakito

Hello,

I need to calculate the interest of a payment depending of the amountPay and the interestType fields that the user completes on a form. When the user hits submit I need to insert in the interest field lets say amountPay * 0.05.

The problem is that as interest is a function field and it searches for the value of the current amountPay and interestType records it fails because they haven't been saved yet. If after saving I edit the field and save it again then I get the correct interest.

Is there any way I can do this on the fly just by hitting submit 1 time?

Any tip in the right direction will be much appreciated, thanks!

Avatar
Discard
Voathnak Lim

You should take a look at on_change function.

Avatar
Grover Menacho
Best Answer

A dummy button can be useful to update your values with a function field.

Anyways you can write a on_change function. You can do something like this. I'm just supposing that your module is like this. But, It's going to guide you.

def onchange_amountPay(self, cr, uid, ids, amountPay, interestType)
interest=amountPay*interestType
return {'value': {'interest': interest}}

and on your view

<field name='amountPay' on_change="onchange_amountPay(amountPay, interestType)"/>
<field name='interestType' on_change="onchange_amountPay(amountPay, interestType)"/>

That it's going to help you. But it just calculate and show it only to the user. It's just to change it on the fly. The real value is calculated on the function.

If you have any question comment here.

Regards.

Avatar
Discard
Yakito
Author

Thanks! I always forget how many things the onchange method can achieve!