This discussion is archived
3 Replies Latest reply: Feb 7, 2013 8:42 PM by scott.wesley RSS

Spreadsheet formulas - Data entry

VANJ Journeyer
Currently Being Moderated
APEX 4.2.1

When attempting to duplicate a typical spreadsheet-based app, data generally falls into 2 categories: user-input and formula (vlookup, cells A1+B1=C1, etc) generated. In a report/list view, there are a few options to show the calculated columns like a) 11g virtual columns or b) views containing the formulas as SQL expression.

On a form page, if I want to show the calculated fields as Display Only page items that are dynamically updated with the corresponding input fields, one would use APEX dynamic actions (Change, Set Value, etc).

However, this would mean that the code for the "formulas" is duplicated in the view/table definition and the APEX DA leading to maintenance issues when some formula needs to change.

Is there a way to not duplicate the formula code/expression and make them available to both the DA and the report?

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points