If you're an advanced form builder you may have seen the 'Formula' field.  This field lets you leverage molti's built in formula options to make your forms that much more powerful.

Say you want to calculate some numbers based on inputs in your form.  Or, say you want to run true/false scenarios.  You can actually do that in molti automagically!

When you build forms there are number of form field options.  The 'Formula' field lets you build formulas into your forms that are connected to other cells in your form.
​

Keep in mind! To connect fields to the 'Formula' field, the 'Data Type' must be a number.

For example, I want to create a formula in my report that will add two fields together.  So that 'Field 1' + 'Field 2' = the number displayed in the 'Formula' field.

To do this, first we need to create Field 1 and Field 2.  Just drag and drop the fields as you normally would into your form.  Don't forget that you must set the 'Data Type' for each field as a Number.

Next you want to add your 'Formula' field.  First you want to select your 'Reference field'.  Click the 'Add reference to field' drop down and search for your field name.  Then 'Select' and the corresponding field number will be entered in the formula bar.  

Finish up your formula by adding the operation (in this case '+') and the next field you want to add.  Voila!  Now when you use the form, the 'Formula' field will perform the calculation for you.

Formula fields can get pretty complicated.  For a list of some commonly used functions check it out below:

You can also use formulas to return True (1) or False (0) values.  Check out the table below for some examples:

These are just some examples of formulas available to you with the 'Formula' field.  If you're having trouble, reach out to our support team for tips!