Form element

See also: Configuring VAT forms

Only relevant if you want to change the background colour of the text.

Is normally set using the colours dialog. The colours dialog can be found by pressing the * key on the keyboard or by double clicking in the field.

Press * or double-click to select colour.

1 - First copy

2 - Not first copy

3 - Last copy

4 - Not last copy

Only relevant if you want to format the decimal type on the printout.

If the field is not filled in (has the value 0 in the database), the default decimals for the column in question are used.

0 - Default

1 - Fixed

2 - Floating

Only relevant if you want to format the decimal field on the printout.

Must be specified to display the form element correctly on the paper printout.

Must be specified to display the form element correctly on the paper printout.

No digit grouping symbol

There will be no thousand separators on the printout. You must select this field for XML files because numbers with spaces are not accepted.

Get Company data if empty

Country and currency will be retrieved from the Company information table if it is missing from the order.

Remove spaces

All spaces will be deleted in the fields that you have entered in the Text/parameters field on the row. You can for example use bank account number and company number when you want to print these fields to an XML file.

Remove all except numbers

Everything except numbers will be deleted on the printouts.

Omit on original printout

The row will be excluded from the original printout. The row will then only be displayed when you print a copy of the order document from the Order document table. You can for example use the field to show that the printout is a copy by writing the text Copy on the row and selecting the option Omit on original printout.

Omit on printout from order document table

The row will be excluded when you print a copy of the order document from the Order document table. The row will only be shown on the original printout.

Do not truncate/round decimals on VAT report

The decimals in the VAT report will not be truncated.

Note:

This parameter must be used in countries where decimals shall be printed on VAT reports.

Do not break line with pipe character

When the option is checked, no line break will occur when a pipe character (a vertical bar, | ) appears in the field Text/parameters.

Must be specified to display the form element correctly on the paper printout.

0 - E-document

Rows in the Form element table with the value 0 - E-document in the Element type field will be processed in connection with E-documents and will not be included in the Order document formula table.

1 - Text

You can use relationship operators and logical operators in the Text/parameters field.

Relationship operators (same as in SQL):

• Equal to: =
• Greater than: >
• Less than: <
• Greater than or equal to: >=
• Less than or equal to: <=
• Different from: <>

Logical operators (same as in C++ and Java):

• Negation (not): !
• Conjunction (and): &&
• Disjunction (or): ||

These expressions return 1 if true or 0 if false.

Evaluation order for parentheses and operators in the Text/parameters field:

1. Brackets
2. Multiplicative operators (+, -, *, / and %)
3. Additive operators (* and /)
4. Relational operators (=, >, <, >=, <= and <>)
5. Negation (!)
6. Conjunction (&&)
7. Disjunction (||)
8. Conditions and partial expressions (? and :), see point 1498

Operators at the same level are evaluated from left to right.

Conditional formulae for form elements:

• In the Text/parameters field in the Form element table, formulas (which start with an equals sign) can contain conditions and sub-expressions which are evaluated if the condition is true or false.
• The condition is followed by a question mark and the expressions are separated by a colon (in the same way as in C++ and Java).

= Condition ? Expression if the condition is true: Expression if the condition is false:

• The conditions can have an almost unlimited number of levels, using parentheses.
• The entire composite expression is entered in the relevant field.

Example of two levels:

• = Condition 1 ? ( Condition 2 ? Expression which will be evaluated if conditions 1 and 2 are true. : Expression which will be evaluated if condition 1 is true but not 2. ) : Expression to be evaluated if condition 1 is false.
• ? and : have the lowest priority of all operators and have been added at the end of the listings of evaluation order in points 1464 and 1478.

This is an alternative to using IF, ELSEIF, ELSE and ENDIF in the Element type field where a numerical value is to be returned.

2 - Line

Graphic line

3 - Rectangle

Graphic rectangle

4 - Rounded rectangle

Graphic rounded rectangle

5 - Oval

Graphic circle

6 - Bitmap

Is an image file

7 - IF

Conditional execution of form elements:

With IF and ELSEIF, the condition must be specified in the Text/parameters field on the row.

IF, ELSEIF and ELSE must be followed by one or more form elements which will be executed if the condition is true or false in the case of ELSE.

For each IF, there can be 0 or more ELSEIF's, 0 or 1 ELSE, and there must be 1 ENDIF.

Using ELSEIF merges ELSE and a following IF and eliminates the need for an extra ENDIF.

(If the program encounters an ELSEIF, ELSE or ENDIF without a preceding IF, the drawing of the form is stopped.)

When using conditional execution of form elements with element type IF and ELSE IF in the Form element table where the condition involves a varchar field and the comparison value is an empty string it is necessary to enclose the comparison value in double quotes (").

Example: @Order (Your ref.)<>""

The control structures can have an almost unlimited number of levels.

Example of two levels:

IF Condition 1 Form elements which will be executed if condition 1 is true.

IF Condition 2 Form elements which will be executed if condition 2 is true.

ELSEIF Condition 2B Form elements which will be executed if condition 2 is false, and 2B is true.

ELSE

Form elements which will be executed if the condition(s) is/are false.

ENDIF ELSEIF Condition 1B Form elements which will be executed if condition 1 is false, and 1B is true.

ELSE

Form elements which will be executed if the condition(s) is/are false.

ENDIF

If sentences can test whether a field is blank or whether data has been entered in the field. For example, you could have two address lines in the form on your order documents. If a customer has only used one of these, the blank line can be suppressed and not printed out.

Example: You select 7 - IF in the Element type field and type @Order(Address line 2)= in the Text/parameters field.

8 - ELSEIF

9 - ELSE

10 - ENDIF

11 - Company dependant picture 1

The selections 11 - Company dependant picture 1 and 12 - Company dependant picture 2 are used to show a picture which depends on the type of company that the printout has been prepared for.

The Text/parameters field is used to specify a variable name (without using the macro function) which refers to a row in the Text company variable table, where the same value is entered in the Variable name field. The picture file's path/file name is inserted in the Value 1 or Value 2 field for 11 - Company dependant picture 1 and 12 - Company dependant picture 2 respectively.

The Namespace field must also be filled out, with identical values in the Form element and Text company variable tables. Lookups in this column lead to the Namespace table.

Until further notice only BMP files will be used in forms.

By not specifying dx and dy for these form elements, the original width and height of the picture file will be used.

12 - Company dependant picture 2

13 - Image (Business NXT only)

The selection 13 - Image (Business NXT only) is used to print a company dependent image.

The image file is added from the Integer company variable table.

Additional setup needed for linking to the correct row in the Integer company variable table:

• The Namespace field - the same value as the Namespace field in the Integer company variable table
• The Text/parameters field - the same value as the Variable name field in the Integer company variable table

By not specifying dx and dy for these form elements, the original width and height of the picture file will be used.

The field shows the font family, style and size within square brackets. In the database there are three separate fields for font family, font style and font size. The field shown on the screen keeps the font size in the database.

The font size may be set as a percentage (e.g. 120) of the normal font size, cf. the Relative option in the Type drop-down list in the dialog box.

Is normally set with the Font command (in the Design group in the Home tab).

You can also specify the font size using the graphical editor. The graphical editor can be found using the processing Graphical editing from the Form table.

Only relevant if you want to change the foreground colour of the text.

Press * or double-click to select colour.

Must be specified to display the form element correctly on the paper printout.

1 - Left justified

2 - Centred

3 - Right justified

4 - Left justified header

5 - Centred header

6 - Right justified header

7 - Left justified footer

8 - Centred footer

9 - Right justified footer

Only relevant if you need lines in the paper printout e.g. when doing mathematical calculations.

The Namespace field is used to get the correct path to the picture file name.

The namespace value will be applied as a prefix to the local text found in the Text/parameters field.

Only relevant if form element is to be printed on a specified page.

1 - First page

2 - Not first page

3 - Last page

4 - Not last page

5 - Giro element on last page

Bold

Italic

Underline

Strike through

Must be specified to display the form element correctly on the paper printout.

Element no. is in the 1 - 12 range for integer and decimal variables and the 1 - 2 range for text variables. The parameter can be omitted and will then be given the value 1. Remember to specify Namespace on the rows.

In the macro function @GiroAmountAsText() you can enter the currency designation you require in brackets.

See Formula for more information about the macro functions.

Must be specified to display the form element correctly on the paper printout.

Must be specified to display the form element correctly on the paper printout.