Formats of the text fields and formulas


Form Pilot:       Main Page       Features       Download       Order       Tutorial       FAQ       News

 

In Form Pilot, there are four text field formats:

1. Text – the format for “as is” text entry. This format means that content of the text field is displayed just as it is entered by the user.

Text format example

2. Numerical – the format for entering numbers and making calculations. You can turn the field separator (or separator of the digit groups) on/off, set number of decimal places, enter minus numbers, and use formulas for calculations.

View the numerical format field

– in the edit mode: Numerical format example - edit mode

– in the display mode (number of decimal places is equal to two): Numerical format example - Display mode

3. Money – the format for displaying a number together with the currency symbol. You can set number of decimal places and use formulas for calculations.

Money format example

4. Index number – the format for number of the document. In the database, the index number of each new document is increased by one automatically. See also the Renumbering Forms section.
 

How to change the format

To change the format, click the Format option on the Properties panel and the setting window will appear.

Changing the format of the text field
 

How to use formulas

Set the numerical format for the text fields you want to use in your calculations.

Start the formula’s record with the “=” sign. Then, you can enter your formula using numbers (5; 4,687; -7.5), text fields’ names (Text0;Text1), operators (+;-;*;/), and parentheses ().

Examples:

Example of using formulas

In the edit mode, the formula is shown. In the display mode, the result of a calculation is shown.

Example of using formulas

 


Form Pilot:       Main Page       Features       Download       Order       Tutorial       FAQ       News