Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Salesforce Formulas

Spring 2019 Note: Pulsar now directly supports evaluating Salesforce formulas both online and offline.

  • Supports formula fields
  • Supports default value field formulas (during initial record creation)
  • All numeric, logical, string, and date/time operators and functions are supported
  • Most summary and advanced functions are supported (some server-side-specific functions are not supported)
  • Set pulsar.formula.enableSFDCFormulas Pulsar Setting to TRUE to enable this functionality in the Pulsar mobile app

Best practices

...

and caveats

  • If there is both a Salesforce formula and a PSL formula for the same field, the PSL formula takes precedence, and the Salesforce formula is ignored
  • Salesforce formulas and PSL formulas across objects/fields should not interact (e.g., if FormulaFieldA__c is a Salesforce formula and FormulaFieldB__c is a PSL formula, the result is undefined if they reference each other).
  • Formula fields are calculated on-the-fly every time you view a detail page (but not when editing)
  • Formula fields are NOT calculated in list views.  The values showing in the list view may not match the latest information unless you perform a step to persist the calculation to the local database (see below)

Persisting formula field values

Due to inherent processing limitations, by default, formula field calculations are not persisted to the local database.  When running offline, this can present a "stale data" problem if formula fields are present in list views, or if you are querying the database for formula fields.


...

PSL Formulas

Spring 2019 NOTE: we recommend that you use SFDC Formulas going forward, but PSL formulas will continue to be supported.

...