The Formula Builder is the environment for creating and editing scripts, written either in Jitterbit script or JavaScript.

Currently, most functions are available only when using Jitterbit script, though a portion of the functions have been ported and available through JavaScript.

Modes

The Formula Builder includes a drop-down allowing you to view the tool's interface in Business Analyst or Developer mode.

If you are in Business Analyst mode, the list of functions indicates with an icon  the functions that have wizards. When you click the insert button (see Using the Formula Builder), you will be in a wizard to assist with inserting and completing the function in your script. Note: you may need to close and reopen the project in the Design Studio for the icons to appear or disappear if you have changed modes.

Features

Here are some of the main features of the Jitterbit Formula Builder.