Working with Functions

How to use Function(s)

The Flexi Kanban functions is very powerful and flexible tool that may help to build your complex logic and get rid of custom code in your application. You can use functions in the Flexi Kanban Dashboards, Forms and Actions.

The Flexi Kanban application provides its own library of functions, with the ability to extend the library with client custom functions.

To use the function(s) or expression in your component configuration you have to cover the whole expression into "FORMULA[]", except the places where the type of content is "Formula" (for example Action conditions).

Examples: 
1 + 2 = FORMULA[1 + 2]
The current year is "FORMULA[FORMAT({$system.Date}, 'yyyy')]"

How to register custom Function

The Flexi Kanban application allows you define your own functions.

To define your own function go to Setup->Custom Code->Custom Settings->KanBan Config List->Manage and click "New" button.

Here you can configure the custom function properties:

• Name - custom function name. Should not contain spaces & special symbols. Preferable the upper case. Example: CALCULATETOTAL

• Option 1 - apex class name that implements FLX_KB.KanBanInterfaces.FunctionInterface interface and stores function code. Example: MyCustomFunctionClass

• Option 2 - definition of the formula that will be shown as a formula example expression. Example: CALCULATETOTAL(column_id)

• Option 3 - category to put the formula in. Example: Numeric

• Value - must be "Function"

And click "Save" button.

The configuration should looks like:

After that you will be able to find this function in all application formula builders and use it.

The example of code that represents the custom function:

public class MyCustomFunctionClass implements FLX_KB.KanBanInterfaces.FunctionInterface {
    public Object executeFunction(String name, List<Object> parameters, Map<String, Object> context) {
        return null;
    }
}