A dynamic formula in iPaaS.com is a formula written out in C# that assists in the mapping or transformation of data as it flows to or from iPaaS.com.

The iPaaS mapping uses a dynamic code interpreter called EvalExpression to allow users to define custom logic for field mappings. This allows for certain programmatic operations to enable more complex mapping rules. For example, if you want to prefix the SKU on a website with the letters WEB, you could define a mapping with SKU assigned to the websites SKU to be "WEB"+ SKU.

For parent/child mapping collections (e.g. Products and their Units), there are some additional fields to reference the parent data, or to reference the children from the parent. For example, you may want to define the price of a unit using a field from the parent. Conversely, you may want to calculate the quantity field on the parent using the inventory children object. The available fields for these types of mappings are outlined in the Parent Only section of this section.