Watch The Tutorials

Getting started Grid pages Freestyle pages
Getting Started with Form Maker Layout Demo Form Maker Freestyle Pages
Image fields Text fields Buttons and multi-page
Image Field Demo Text Fields Demo Form Maker Buttons and Multiple Pages
Choice fields Camera fields Video fields
Choice Fields Demo Camera Demo Video Demo
Table Lists Simple Form Mapping Form
Table List Demo Form Demo Map Demo
Color Palettes Multi-Columns PDF Printing
Color Palette Demo Multi-Column Demo iPhone and PDF issues with Form Builder
Formulas Export / Import
Formula Demo Export Import Demo


To find out more please email:





iPad Form Maker on iTunes


Formulas

Formulas let you link fields together and perform calculations on them. All formulas follow the same format and are made up as follows:

=formula(tag)[n]{p} e.g. =SUM(tagOne)[2]{3}

The tag can be anything you like, any text that identifies the source fields for the foumula. So if you want to add up all the amount fields on your form, set the tag for all these fields to a value that means something to you e.g. tagAmount. Then in the field you want to hold the result of the addition enter the formula =sum(tagAmount).

The number of decimal places to calculate amounts is stored between square brackets, [0] is the default and mean no decimal places, usually [2] is used for monetary amounts.

The order of precedence is held in curly brackets. This is only needed if you want a formula to be the result of another formula. In this case Form Maker needs to know to do one formula before the other one. For example you may want to sum up all the amount fields, then apply a percentage to it. In this case the summing up could be done using =sum(tag)[2]{1}, the field with this formula would then need a tag to make it the source field for another formula. The result of the multiplication could then be specified as =multiply(tagTwo)[2]{2}.

Here are a list of formulas available:

value: Copy the contents of the field e.g. =value(tagOne) will copy the contents of the field with its tag set to tagOne.

sum: Add together the contents of the fields as numbers e.g. =sum(tagOne) will add up all the contents of the fields with their tags set to tagOne.

reciprocal: The same as 1 / sum. Can be used for division.

multiply: Multiply together the contents of the fields as numbers e.g. =multiply(tagOne) will multiply together all the contents of the fields with their tags set to tagOne.

average: Average the contents of the fields as numbers e.g. =average(tagOne) will average all the contents of the fields with their tags set to tagOne.

index: Lets you link together two pickers or segmented controls so as you change the selection in one, it is reflected in the same selection in the other. e.g. =index(tagOne) will make this picker or segmented control be set to the same selection position as that of the picker or segmented control with the tag tagOne.