GoFormz Functions and Formulas

GoFormz Calculation Guide

An easy to use guide for all calculations and functions available in GoFormz. We will take you from the basics of a calculation and what it does, to the most advanced functions you can create in GoFormz.

If you're new to GoFormz, you'll soon find that it's more than just a form in which you are filling out fields on a form. Sure, you can use GoFormz to find totals for a list of numbers or get the totals on a timesheet, but you can also calculate a mortgage payment, solve math or engineering problems, or find a best case scenario based on variable numbers that you plug in.

GoFormz does this by using formulas in template fields. A formula performs calculations or other actions on the data that is entered in the fields on your form. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (like a + or - sign for addition or subtraction), and built-in GoFormz functions, which can really expand the power of a formula.


Examples:

As an example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.

=2*3+5


Here are some additional examples of formulas that you can set up in a template:

=[Subtotal]+[Tax]-[Discount] Adds the values in the Subtotal and Tax fields, while subtracting the discount.

=SUM([Items]![2][1]:[2][10]) Uses the SUM function to return the sum of the numbers in column 2 of the table field "Items". This could be a list of prices, or any other numbers you may have in a table

=UPPER([Customer]) Converts the text typed in the "Customer" field to all caps by using the UPPER function.

=IF([Subtotal]>0,"true","false") Uses the IF function to test the cell A1 to determine if it contains a value greater than 0.

Updated about 20 hours ago

GoFormz Calculation Guide


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.