Understanding and using the Referential-Hierarchical list

• The items that will be part of the hierarchical list (all the text highlighted in blue in the picture above) should be separated by an anti-slash: . On your PC, you can add it by typing « Alt gr » + « 8 » and on Mac « Alt » + « Shift » + « : ». This part of the list will end with this character: |. You can add it by typing « Alt gr » + « 6 » on an azerty keyboard and typing «Alt gr » + « 1|& » on a qwerty keyboard. On Mac, type « Alt » + « Shift » + « l » on your azerty keyboard and type « Alt » +« 7 » on your qwerty keyboard.

The items that are highlighted in yellow in the picture above, which is actually the referential part of your list, will be separated by this character: |.

Example:

In our example above, when you select the state of California, three options of cities will appear: Los Angeles, San Diego and San Francisco. If you select Los Angeles, you will then have two options of counties: Long Beach and Pasadena. When you select Long Beach, the name of the customer located in that area ‘Barbara Wood‘ and all the contact detail of that person will appear automatically (reference fields).

NB : For technical reasons, some characters are not allowed, such as: » ; /.

Good job! You have done the hardest part!

Step 2: Insert your list in a form.

• Now go into the creation of your form and insert a list by dragging the List item into the blue box.
• Go into your List options by clicking on the blue pencil icon.

• Now select the Features tab of the List item, in the search bar select your External list.

NB: It is impossible to set a Hierarchical-Referential list as ‘multiple selection’.

/! Do not forget to Confirm your changes and save your form.

Step 3: Set the Reference field.

• Insert a Reference element in your form and go into its features by click the green pencil icon.

• Go to the Features of the Reference field, put the proper settings. First, you need to define which list will be linked to this field. Second, you need to mention which column of the referential list will be in this field.

• Repeat what we just did for each column your have in your document. In our case, we have 4 ref columns (5 including the label). Then, we need to insert 4 Reference elements into our form and put the correct settings for each one of them. The last element will look like this:

NB: The Modifiable entry option enables the mobile user to edit this field when inputting the data. By default, the Reference field is not editable.

/! Do not forget to Confirm your settings and save your form.

View from your mobile device.

Here is what you will see on your mobile device: