The fields

In the Tiny ERP form, you can find fields of different colors (white, grey and blue).

The white fields are fields that we can call standard,
The blue fields are mandatory fields,
The grey fields are in mode read-only, they can't be modified.

If you forget to fill in a mandatory field or if it is not filled as expected by Tiny ERP, during the form recording, that one won't be saved and the omitted field will become red.

An error message will also appear in the right part ("Status" area) of the information bar peculiar to the record.

Maybe the mandatory field isn't located in the current tab of the form. When you have an error message in the information bar, think to verify all the tabs of the form.

The fields types:

There are eleven fields types in Tiny ERP. Here below is a list and a description of each one of them.

1. Text

Simple field to fill with one or more words. The size of this type of field is limited to a number of characters. If the text that you type into this field is longer than the maximum size, characters typed on the keyboard won't be added anymore to the screen.

2. Number

Simple field to fill with a number. We can notice on the right of the field two buttons (upward-arrow / downward-arrow). These buttons can be used to increase or decrease the number inside the field.

There are two types of number fields : integer and float.

We can also increase/decrease this number by positionning the mouse above the field and by using the wheel.

3. Date

Field to fill with a date. To fill that field, you can click on the button located on the right of the field and symbolizing a magnifying glass. Then a new window including a calendar is dispalyed. You just have to click on the wanted date and valide your choice.

The dates fields are differently represented from one country to another. The representation of the dates is defined by the configuration of your machine. Thus it is always preferable to use the calendar to fill the dates, if the correct format isn't known.

Three types of date fields are aivalable in Tiny ERP:

The simple dates, example: 04/05/1979
The dates with hours, example: 04/05/1979 06:43:36
The simple hours: 06:43:36

4. Selection

To fill this kind of field (combo box), you have to click on the button on its right and symbolizing a downward-arrow, then to select one element of the list box.

5. Check box

This field is represented by a box that you can check or uncheck.

6. Description

This is an equivalent to the field of text type, but larger. There is no size limit and the way to generate a CR/LF.

There is also a version of the field description with layout elements : bold, italic and underline.

7. URL/E-mail

Field being used for typing websites or email addresses. To go to the indicated address or to send an email using your mail application, you just have to click on the button on the right of the field.

The types URL and E-mail are defined by the programmer. They are not interchangeable by the user. If a field is related to an URL don't forget to indicate the protocol (http:// ou ftp://) at the beginning of the address.

8. Translatable

These fields (generally text or description) can be translated, you have to click on the flag on the right of the field to get a popup giving different translations of this field.

According to the user language, the value displayed in this field can be different. The same for the reports. Thus, an order form can display the english or french product name, depending on the language by default defined in the client form.

For a language to be available during a translation, it has to be added during the software instalaltion.

9. Multiple relations

This field specifies the relations between the current record and several other records. To add relations you can press the “add” button, which opens a search window. You can also add records by typing either the exact code or part of the resource name then press <ENTER> or click on the button “add”.

If Tiny ERP finds one and single result, the window of research isn't opened and the record is directly added.

Example of use of the type of field many2many: a customer can be part of one or more categories (he can be in the same time contractor and "good customer"). A category can be related to one or more customers.

10. Linked relations

This field too specifies a relation between the current record and several other record (of same or different types). You can directly create a record with which you want a link thanks to the “new” icon( ) on the top left of the field. If that record already exists, you can open it thanks to the “open” icon ( ). It is possible to navigate between the different linked records thanks to the navigation icons( ).

There is a “list” version of this field to which one you can move thanks to the “list” icon ( ).

An example of use of this type of field : A partner can have serveral addresses (a shipping address and an invoicing address). Each address only belongs to one partner. This field is also used, for example, to create different command lines in an order form.

11. Simple relation

This field specifies the relation between the current record and another record (of same or different types).

Yo can directly create a record with which you want a link thanks to the “new” icon ( ) on the right of the field. If this record already exists, you can search it thanks to the “search” icon ( ) on the extreme right of the field. Once the relation between the two records is done, the “search” icon ( ) switches to the “open” icon ( ).

While clicking on this icon, it will be possible to see and/or modify the linked record. It is also possible to seek a record by typing its exact code or part of its name then pressing <ENTER>.

Be careful, if you indicate the code or the name of the record and that you forget to press <ENTER>, the “search” icon won't be transformed into “open” icon and the field will be considered by Tiny ERP as not filled.

Example of use of the type of field many2one : a couple of orders has been placed by only one customer. Each order is so related to the same customer.

Generally, the fields with linked relations have their equivalent simple relation in the associated resource.