Referential list: Allows several fields to be linked to a list. During entry, when an item is selected from this list, the data linked to that item will be automatically inserted into the field provided for that purpose. The field for this automation is the Reference field (Calculation field always allows it). The goal is to prevent the application user from entering data already known by the company. This saves time and avoids entry errors.
This option is by far the best one when you want to create long lists. For more details on how to create a Referential list from an Excel file, please read this tutorial.
/! IMPORTANT /! The way you are going to write this list is important because it will define it. Write it this way:
Apple |Spain|2.20
Banana |Africa|1.49
Orange |France|2.10
Strawberry |France|3.10
Explanations: Consider the example of apples.
By selecting the apple, the origin as well as the price in kg, these will be put in the fields provided for this purpose (Reference or Calculation).
Reading will be by column: Column 1 is defined by the fruit, column 2 is defined by the origin and column 3 is defined by price per kg. A referential list may contain up to 49 'ref' columns.
Note: How do we generate this vertical bar, called 'Pipe', which separates each item in the list?
Note: It is impossible to set a Referential list as 'multiple selection'.
Do not forget to enable your settings.
Note: The Modifiable entry option makes the field editable during user entry. By default, the Reference field is not editable.
See the result below.
The objective here is to be able to enter a bar code and obtain the associated information that will automatically insert into the Reference field settings.
For example, you are selling bottles of fruit juice. Once the bar code is entered, you need to know the flavour and size of the container in order to inventory your stock.
To do this, you must create a referential list with bar codes in the label column.
Once your referential list is created and imported, under the Configuration tab, External Lists, go into the definition of your form and insert the Bar code item. Go into the options of your Bar code field by clicking on the pencil.
Under the Advanced tab of the Bar code item, select your external list from the drop-down list
Then insert a Reference field in your form. In the options of the Reference field, under the Properties tab, select the field corresponding to your Referential list and then select the column to which the Reference field is related.
In our example, we need to automatically display: flavour and size of the container. Therefore, we will retrieve two Reference fields.
/! Don't forget to confirm your settings and save your form.
You can scan an NFC tag and obtain the information associated with it in the Reference field settings. For example, you work in a clothing store and you want to scan the NFC tag on the label in order to obtain the size and price. You must create a referential list in the label column with the information contained in the NFC tag. In our example, it is the reference code of each garment.
Once your referential list is created and imported, under the Configuration tab, External Lists, go into the definition of your form and insert the NFC tag item.
Go into the options of your NFC tag field by clicking on the pencil. Under the Advanced tab of the NFC tag item, select your external list from the drop-down list.
Insert a Reference field in your form. In the options of the Reference field, under the Properties tab, select the field corresponding to your Referential list and then select the column to which the Reference field is related.
In our example, we need to automatically display: garment type, size and price. Therefore, we will retrieve three Reference fields.
/! Don't forget to confirm your settings and save your form.
