Using formulas


Use the Template Editor to add formula fields to your template.

Multi Collector allows the use of any kind of standardized ECMAScript (JavaScript/Java). They look like standard formulas. Any fields in the database can be accessed using 'f_' prefix.

item_id is used to get a unique item number. This can be used as an auto-increment identifier.


Math.min(f_id1, f_id2*10)


A lot of Java/JavaScript examples can be found on the Internet.


MultiCollector Formula editor


Formula Editor contains a Fields (5) and Functions (6) list with available database fields and the most popular functions. Double-click item in the list to auto-insert it to the formula.


The customer can set a personal formula, or use a default formula. If you leave blank a formula field (1) for your item, Multi Collector will use the default formula.



'Clear' (2) - Clear the field formula (use default formula).

'Default' (3) - Show the default formula for this field.

'Set Default' (4) - Set current formula as a default for all items.




Formulas Video Tutorial







Created by LignUp. All rights reserved.