Supporting formulas in form defaults would be a flexible way of implementing this.
- That way a user could copy a formula into the “Form defaults” and instead of it being set to a static value, the value is dynamically calculated.
- A “Calculate now” button may need to be added to the bottom of the screen to trigger calculation and prevent circular references locking the program up.
- I could live with the existing GUID references. They could be upgraded to what ever replaces them in the rest of the program when that happens
- Formula could be part of localization imports or manually entered.
Done this way I suspect users could use it to automate many other Manager entries such as Cost Price Sale Price Markup Field Idea