Formulas Editor

[chuckkramer]

1.) Can you post current documentation for Formulas Editor
2.) Is there a way within Formulas Editor to determine what the current field is? E.g. Same Formula is stored in multiple fields within Endorsement. need for Formula to know whether it is being executed on Description or Charge field.
3.) Is there a way to set a variable in a Formula and then reference it later when setting the "value"

[Phil Barton]

In answer to your questions:

1.) The documentation related to the formula editor can be found at this URL: http://help.softprocorp.com/select/v4.0 ... lectskin_2.

2.) The formula editor does not have a knowledge of the field that it is on. Internally, it is aware of the type of entity that is it's context and the type of the property on which it is being placed. However, there is no programmatic access to those types. In your requirements, you state that the same formula is being used on multiple properties on the same entity (Endorsements, in this case) but those properties are of different types (string vs. decimal). I would caution against that approach. Formulas are intended to be tailored to the entity and single field on which they reside. If the same formula is put on a different field of a different type, the system will attempt to coerce the value to the new type. This may or may not success and may return unexpected results.

3.) There is currently on the 'Value' variable available. This is a design limitation that we hope to address. But, for now, it's the only variable available.