Columns setup

The command Columns setup command can be found in the Data menu. With this command, columns can be displayed, hidden, renamed or moved left or right in the various tables.

Display Tab

 

Header
This is the column header.

Header 2
This header is used by the program for only a few fields (e.g. Amount column).

Description
This is the description of the field. This description will be shown as a tooltip.

Format
This is the format to show numbers, date and time (see chapter at the end of this page).

Width
This section defines the horizontal size of the column.

Column Style
This is a drop-down menu that indicates the style to be used (Format, menu, see sub chapters). This style has priority over the style of the row.

Alignment
The user can choose whether to align the text right, left or center in this drop-down menu.

Wrap text
This option allows the user to view the input text on more than one line.

Protected
This option allows the user to protect the entire column so that no data can be input or edited.

Exclude from printing
When this option is activated, the field will be excluded from printing.

Visible
This option allows the user to make column visible.

The tables can be altered. Fields can be added, headers can be changed, and column sizes and the order in which they are shown can be altered.

Move up, Move down
The fields are listed in the order in which they appear on the table being used. The visible fields are the ones with a checkmark.
In order to alter the order in which they appear simply select the field you wish to move and drag it up or down.

Add
This button adds new fields (columns) to the current table. Field added by the user are just information fields; the program does not make any calculation on numeric data.

Delete
This function is used to delete a field (column) from the list. A system field, however, cannot be deleted.

 

Settings Tab

 

Field name
This is the name of the active field and it is automatically inserted by the program. It cannot be modified.

Field name Xml
This is the name of the active field in the Xml format and it is automatically inserted by the program. It cannot be modified.

Data type
It is possible to choose between the following predefined types: Text, Number, Amount, Date, Time.

Max and Min length
Maximun and minimum field length.

Max and Min Value
It is possible to enter minimum and maximum values (numbers or characters).

Decimal points
It is possible to define the field decimal points

Field number
This is a number automatically given to the field, and has uniquely a technical purpose.

All caps
By clicking this options all fields data will be shown in caps characters.

 

Date, hour and number format

When the format is modified, the way the date, time and numbers are shown, changes.

If no specific format is specified, the default format of your operating system will be used (date, time and numbers as indicated on the control panel).

In the Format area of the Set up fields/Edit attributes command (Data menu) the user can use other formats. Types of formats, with some examples, are listed below:

 

Date format

Examples for date

d mm yy

1 01 15

dd m yy

01 1 15

ddd mmm yyyy

Fri Jan 2015

dddd mmmm yyyy

Friday January 2015

The letter “d” (day) indicates the day, the “m” (month) indicates the month, and the “y” (year) indicates the year.

 

Time format

Examples for time

hh:mm:ss:zzz

04:04:36:089

h:m:ss:zz

4:4:36:89

Naturally the user can also invert the order of the elements making up the date or the time as desired (e.g.: mm dd yyyy).

As far as the separators are concerned, the user can choose between all of those available on the keyboard (for example: #, @, -, /, ., etc.).

 

Numbers Format

Example for numbers

0.

259

0.00

258.85

0.000

258.848

The number of decimal spaces in a number field can be edited according to the user’s needs. Actual calculations are made using all the inserted decimal numbers. Rounding is only done for what is shown on screen.

help_id
dlglistacampi

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | Email