Hello all,
I have a single record form with 2 fields from the database : Revenue (integer) and Cost (integer)
I have a ‘defined’ field : Profit
When I change the revenue or cost field on the form, and SAVE it, I want to update the Profit field.
I’ve tried adding the calculation in various events (onload, onrefresh, onvalidatesuccess, etc.
{profit} = {revenue} - {cost} ;
It updates profit correctly if I reload (F5) the form in the browser, but not if I SAVE.
I’ve tried making the profit field a label
I’ve tried making the integer (disabled insert/update)
I can’t get it to update.
How can I get this to work?
I’d prefer not to use AJax on field change, if possible.
Thanks!