I am trying to add a field in the MRP. production form that is the result of 2 other adjacent fields.

I have a Balance needed field that needs to display the result of the math sum below.  I can do it with an automated action but have to click on the update form button all the time.  is it possible to have the field calculate automatically in real time?

record.product_qty - record.qty_produced

so 3 fields balance_needed, product_qty and qty_produced

product_qty is populated from the creation of the MO

qty_produced updates automatically from the WO updates

the Balance needed needs to be the difference between the fields.

can you help me with this?