Formula Engine

By providing an advanced formula engine that has context sensitivity and can hook into our API we ensure you always can perform advanced customisation throughout the entire product. Building on the ability for users to drag and drop to create their own queries for data, you can combine that by calling those queries using our functions in the formula engine – thus ensuring you can always get the values you want into your formulas, calculations and algorithms.

As with all functionality in LemonEdge, we want to ensure the capability is accessible everywhere throughout the platform, and provides the full range of capabilities you would expect. Thanks to this being .Net scripting, anyone who has slight familiarity with Excel functions can use the formula engine. There’s no proprietary scripting language to learn, making the whole process transparent, quick and more powerful.

Your formulas can be written in c#, and thus leverage all the syntax, validation and power of .Net.

Mark entities and their properties when you’re designing them using our API or Auto Code Designers, with customised validation rules.

Whether or not views are visible can be specified by formulas.

Embed your default values or formulas into any item.

All custom parameters you create can have values determined, or evaluated, by the formula engine.

Formulas used as conditional gates evaluating whether or not the associated action should be processed given the current state.

Default values for parameters to be used against a SQL query can be hardcoded, or evaluated by formulas to provide a default value.