How Calculated Custom Fields Work

From SmartWiki
Revision as of 09:55, 31 July 2009 by Cameron (talk | contribs)

Jump to: navigation, search

Special - Calculated Value

  • Expressions entered into this field type are evaluated as JavaScript functions.
  • These functions are added to associated page and executed in the client browser.
  • You can enter any valid JavaScript construct into these expressions.
  • The major limitation of this expression type is that it can only use values that are within the current page.
  • The expression cannot be used to manipulate values stored on other tabs or aggregate data from related entities.

Special - Browser Script

  • If you need to add a JavaScript to a page that does not manifest on the page then you can use the Special - Browser Script field type.
  • Generally, this field type is used to specify validation routines.
  • Functions defined in these scripts can be referenced in other calculated custom field.
  • You can control when the script is executed by using any valid JavaScript event triggers. You could force the script execution on page load (onLoad) or Save (OnSubmit).

Template Level Formulas

  • Template level formulas can be associated with UTA level 1 and 2 templates plus Sales Tracking.
  • Template level formulas are not JavaScript functions and are not executed in the client browser.
  • These formulas are executed in the database server and are constructed using valid SQL syntax.
  • The benefit of this approach is that you can aggregate data across entities and update information across other entities.