Update display field on form
Posted: Sun Apr 03, 2016 7:58 pm
Hi there,
I've been trying to get this done for a couple of hours now, but for the life of me I can't figure out how.
I have 2 fields on a form that the user would complete e.g. Leads, Sales. These are saved to the database, and when the record is requested again, I set up a display field that calculates the difference between the 2 e.g. Leads - Sales = Deficit.
What I would like to do, is be able to create the Deficit field on the form, so that once the user has filled in the Leads and Sales fields, the Deficit field will automatically be filled with the difference between the 2.
Thank you for any assistance.
Vinaduro
I've been trying to get this done for a couple of hours now, but for the life of me I can't figure out how.
I have 2 fields on a form that the user would complete e.g. Leads, Sales. These are saved to the database, and when the record is requested again, I set up a display field that calculates the difference between the 2 e.g. Leads - Sales = Deficit.
What I would like to do, is be able to create the Deficit field on the form, so that once the user has filled in the Leads and Sales fields, the Deficit field will automatically be filled with the difference between the 2.
Thank you for any assistance.
Vinaduro