The different types of fields

Now that you have created your first data model, let's see together the different types of fields that you can define:

The “Text” fields

You can enter any information you want in this field, whether they are text or numeric. However, if you use it to store numbers or dates, for example, you will not benefit from the advantages of typed fields to store this type of data.

The “Number” fields

Fill this field with whole numbers. You can define how numbers are displayed (thousands separator).

Example :
Quantity in stock of a product : 1 400 or 1,400

The “Decimal” fields

Fill this field with decimal numbers. You can define how numbers are displayed in this column (thousands separator, decimal separator, number of decimals).

Example :
Invoice amount : 3 507.6 or 3,507.57

The “Currency” fields

This field allows you to enter monetary data. You can choose the formatting of the field, the symbol (€, $, USD,…).

Example :
Product price : 250 €, $ 175

The “Checkbox” fields

This field is a simple checkbox. In views, you can filter the data according to whether the box is checked or not.

The “Date” fields

This field allows you to enter a date. You can choose the date format from a list of predefined formats.

Example :
Billing date : 14/05/2025, 14 May 2025

The “Period” fields

Use this field to define a period. Unlike the date field which allows you to define a day, the period field allows you to choose a week, a month, a quarter, or even a year.

Example :
VAT declaration : February 2025, T1 2025

The “Choice” fields

Define as many options as you want. When editing a “Choice” field, you can only choose one value.

Example :
Type of contact : “Client” or “Prospect” or “Supplier”

The “Multiple choice” fields

Same principle as the “Choice” field, except that at the time of editing the field, you can select multiple values for this field.

Example :
Product characteristics : “Chair” and “Vintage”

The “User” fields

This field allows you to select a user from the Compozz users

Example :
Created by : Nathan Mercier

The “Percentage” fields

Use this field to enter percentages. Like for decimal fields, you can choose the formatting of the field.

The “Link to another object” fields

This field deserves a little more attention than the others. As you now know, your data models are based on the creation of objects. And all the interest of Compozz is to be able to link these objects to aggregate the data as you want and highlight the important data for your business.

This field will allow you to link your objects. First choose the field of the object you want to link.

Once you have selected the field you want to link, 3 information must be filled in :

Relation name: By default, it takes the name of the object you want to link, you can modify it if necessary. Naming the relation will serve if you want to link other fields of the same object: by reusing it, you will automatically apply the relation parameters to your new field. But you can also have two different relations that link the same objects.

Object 1 = Projects
Object 2 = Collaborators

Create a “Project Manager” field in the Project object. In this case, only one Collaborator will be assigned to the project as a Project Manager.

Create a “Team members” field in the Project object. In this case, several Collaborators can be assigned to the project as Team members.

Cardinality: Allows you to define more precisely the link that unites the two objects.

Pictograms help you make your choice. Let's see together how to read them.

The object you are currently on (Object 1) is represented on the left of the pictogram. The one you want to link (Object 2) is represented on the right of the pictogram :

You can assign the same Object 2 to several Object 1. An Object 1 can only have one Object 2.

Several Object 2 can be assigned to the same Object 1. An Object 2 can only have one Object 1

Several Object 1 can have several Object 2.

An Object 2 can only be assigned to one Object 1 and an Object 1 can only have one Object 2.

Aggregation : Allows you to define how the data will be displayed. Let's see the different possibilities in more detail with the following example :

Create a link between an “Collaborators” object and a “Projects” object from the “Projects” object. We decide to display the first names of the collaborators.

We assign the following collaborators to the Project A : Thibaut Rousseau, Léna Piton, Valérie Ledru and Thibaut Bordet.

• Concatenation
  The project A will be presented in a single line and in the “Collaborators” field we will have the following information: “Thibaut”, “Léna” , “Valérie” and “Thibaut”.
• Value
  The project A will be presented in several lines, namely one line for each value. Attention here, we might think that in our case we would have 4 lines, one for each collaborator. In fact, we only have 3, because we have 2 times the value “Thibaut” in our Collaborators field. So :
  • Line 1: Project A / “Thibaut”
  • Line 2: Project A / “Léna”
  • Line 3: Project A /”Valérie”
• Number
  The project A will be presented in a single line and we will have in the “Collaborators” field the number of collaborators assigned to the project. In our case, this will be “4”.
• No aggregation
  The project A will be presented in 4 lines, one for each collaborator. We will therefore have :
  • Line 1: Project A / “Thibaut”
  • Line 2: Project A / “Léna”
  • Line 3: Project A /”Valérie”
  • Line 4: Project A / “Thibaut”

We have covered the different types of fields that you can use in Compozz. If you need more information, please do not hesitate to contact us!