I have a form on a page that I need to display information such as a calculated value. I have 2 fields (Qty and Price). I have a 3rd field TotalSales that is Qty * Price. I want to be able to display this information before the user submits the record. How is this accomplished. Currently I have the database setting the value after insert but it is obviously not available until the record is created. I have a few other fields like this, costs and taxes for example. How would I set these defaults here so that it is valid before submission. I can remove the database default at that point.
I would like the edit form to be able to update the data as well if the user changes it later.