I have a table of historic data that includes a field which is a decimal value. Going forward, I want to calculate that field in the data entry form (columnA/columnB) and have that value fill the column.
Finally, is there any other property of the page item or page processing I need to 'adjust' due to this calculated value. I am on Apex 4.2.1
Okay. You speak of an historical data table and a data entry form. Are you filling the form and then writing the record(s) to the table? Are these all inserts to the table. Any updates to or deletes from the table?
Or, do you just need the calculated value to display on the form and nothing is written back to the table?
Thanks for the reply. Yes, I want to write the record back to the table. And yes, I may also be doing updates and deletes of records as well. I wanted the calculated field to be written to the table in the field columnC that will hold the result of the calculation on the form (which result from columnA/columnB).
Thanks for any advice,
I guess it depends when/whether you want the field recalculated.
How about a dynamic action (DA) that recalculates that field whenever you load that form and another one (or two) for whenever you change either of the values it depends on?