New Feature: Equations & Text Combos

01/18/2013 Posted by Brandon

We’ve recently released two new fields we’re really excited about: equations and text combos.

Both fields are used to create new values based on others.

Equations

Equations are used to perform mathematical functions on numeric fields. So like the example above, you can easily create simple math equations for doing things like:

  • totalling orders
  • calculating sales commissions
  • determining profit/loss
Equations can also be combined with the other formula fields like Sum, Average, Min, Max to create some complex equations.

Text Combos

Text combos are similar to equations except you can combine any field and text (not just numbers). Instead of math functions these are all simply combined together to form a new text field.

Text Combos are useful for:

  • combining fields to create a more informative ID fields
  • creating name or address fields from separate fields

Beta

Please note that these are both in Beta. This means that you may encounter some bugs or unexpected behavior while using them. Please contact us immediately if you do.