{"id":89381,"date":"2016-09-16T12:24:49","date_gmt":"2016-09-16T10:24:49","guid":{"rendered":"https:\/\/kizeoformscom.kinsta.cloud\/understanding-the-referential-list\/"},"modified":"2021-04-27T16:26:09","modified_gmt":"2021-04-27T14:26:09","slug":"understanding-the-referential-list","status":"publish","type":"post","link":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/","title":{"rendered":"Understanding and using the Referential list"},"content":{"rendered":"<p style=\"text-align: justify;\"><strong>Referential list<\/strong>: Allows several fields to be linked to a <strong>list<\/strong>. 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 <strong><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/the-reference-element\/\" target=\"_blank\" rel=\"noopener noreferrer\">Reference<\/a><\/strong> field (<strong>Calculation<\/strong> 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.<\/p>\n<h2 style=\"text-align: justify;\">Step 1 : Create your Referential list.<\/h2>\n<h3 style=\"text-align: justify;\">From an Excel file.<\/h3>\n<p style=\"text-align: justify;\">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 <a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/create-external-lists-on-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">this tutorial<\/a>.<\/p>\n<h3 style=\"text-align: justify;\">Manually enter your Referential list.<\/h3>\n<ul style=\"text-align: justify;\">\n<li>Go to the online platform and click on <strong>Create an external list<\/strong> under the external lists option<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-24118 size-full\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Create-a-new-list.png\" alt=\"Create a new list\" width=\"1000\" height=\"468\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Create-a-new-list.png 1000w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Create-a-new-list-300x140.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/12\/Create-a-new-list-768x359.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p style=\"text-align: justify;\">\/! IMPORTANT \/! The way you are going to write this list is important because it will define it. Write it this way:<\/p>\n<p>Apple<span style=\"background-color: #fff4cb; color: #000000;\">|Spain|2.20<\/span><br \/>\nBanana<span style=\"background-color: #fff4cb; color: #000000;\">|Africa|1.49<\/span><br \/>\nOrange<span style=\"background-color: #fff4cb; color: #000000;\">|France|2.10<\/span><br \/>\nStrawberry<span style=\"background-color: #fff4cb; color: #000000;\">|France|3.10<\/span><\/p>\n<p style=\"text-align: justify;\"><u>Explanations<\/u>: Consider the example of apples.<\/p>\n<p style=\"text-align: justify;\">By selecting the apple, the origin as well as the price in kg, these will be put in the fields provided for this purpose (<a href=\"\/\/kizeoformscom.kinsta.cloud\/fr\/element-reference\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Reference<\/strong><\/a> or <a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/the-calculation-element\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Calculation<\/strong><\/a>).<\/p>\n<p style=\"text-align: justify;\">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.<br \/>\n<strong>A referential list may contain up to 49 &#8216;ref&#8217; columns.<\/strong><\/p>\n<p><strong><span style=\"color: #95c01f;\">Note<\/span>:<\/strong> How do we generate this vertical bar, called &#8216;Pipe&#8217;, which separates each item in the list?<\/p>\n<ul>\n<li>On PC azerty keyboards, Alt Gr + 6; qwerty keyboards, Alt Gr + &#8220;1|&amp;&#8221;.<\/li>\n<li>On Mac azerty keyboards, Alt + Shift + I; qwerty keyboards, Alt + 7.<\/li>\n<\/ul>\n\n<p><strong><span style=\"color: #55C96B;\">Note:<\/span><\/strong><\/p>\n<ul>\n<li>Some characters are forbidden for technical issues, such as &#8220;; \/.<\/li>\n<li>If your list is going to evolve in a regular way, we advise you to add a code to your list (code: label | reference).<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-24394 size-full\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Codes-in-the-list.png\" alt=\"Codes in the list\" width=\"910\" height=\"200\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Codes-in-the-list.png 910w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Codes-in-the-list-300x66.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Codes-in-the-list-768x169.png 768w\" sizes=\"(max-width: 910px) 100vw, 910px\" \/><\/p>\n<h2 style=\"text-align: justify;\">Step 2: Insert your list.<\/h2>\n<ul style=\"text-align: justify;\">\n<li>Now go into the definition of your form (as shown in the example below, <a href=\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/first-use-first-steps-kizeo-forms-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">start with a blank form<\/a>) and insert a <strong>List<\/strong> item in your form.<\/li>\n<li>Go into your <strong>List<\/strong> options by clicking on the pencil<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-list-referential-list.png\"><img decoding=\"async\" class=\"aligncenter wp-image-104686 size-full\" title=\"Insert the list element.\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-list-referential-list.png\" alt=\"Insert the list element.\" width=\"1200\" height=\"673\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-list-referential-list.png 1200w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-list-referential-list-300x168.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-list-referential-list-1024x574.png 1024w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-list-referential-list-768x431.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Under <strong>Properties <\/strong>of the <strong>List<\/strong> item, search for your <a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/understanding-external-lists\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>External list<\/strong><\/a>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4081\" title=\"Select the list from the drop down menu.\" src=\"\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/select-the-list-in-the-drop-down-menu-1.png\" alt=\"Select the list from the drop down menu.\" width=\"738\" height=\"471\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/select-the-list-in-the-drop-down-menu-1.png 894w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/select-the-list-in-the-drop-down-menu-1-300x191.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/select-the-list-in-the-drop-down-menu-1-768x490.png 768w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>The <strong>List <\/strong>will call to column 1, the label: fruit.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #95c01f;\">Note<\/span><\/strong>: It is impossible to set a <strong>Referential list<\/strong> as &#8216;multiple selection&#8217;.<\/p>\n<p style=\"text-align: justify;\">Do not forget to <strong>enable<\/strong> your settings.<\/p>\n<h2 style=\"text-align: justify;\">Step 3 : Set the Reference field<\/h2>\n<ul style=\"text-align: justify;\">\n<li>Insert a <strong><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/the-reference-element\/\" target=\"_blank\" rel=\"noopener noreferrer\">Reference<\/a><\/strong><span style=\"color: #ff0000;\"> <span style=\"color: #333333;\">element<\/span><\/span> in your form and go into its properties.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-reference-referential-list.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-104693 size-full\" title=\"Insert the reference field.\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-reference-referential-list.png\" alt=\"Insert the reference field.\" width=\"1200\" height=\"673\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-reference-referential-list.png 1200w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-reference-referential-list-300x168.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-reference-referential-list-1024x574.png 1024w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/add-reference-referential-list-768x431.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Under <strong>Properties <\/strong>of the <strong>Reference<\/strong> field, make the proper setting. Select the field corresponding to your <strong>Referential list<\/strong> (here &#8216;List&#8217;) under &#8216;Fields&#8217;. Under &#8216;Column&#8217;, call the desired column. In our example, we want the column corresponding to the origin to be the second column. <strong>We then select 2.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4083\" title=\"Reference field properties.\" src=\"\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Reference-field-properties.png\" alt=\"Reference field properties.\" width=\"738\" height=\"326\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Reference-field-properties.png 893w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Reference-field-properties-300x132.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Reference-field-properties-768x339.png 768w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Repeat the operation for each of the columns that are present in your document. In our example, three columns. So we add a second <strong>Reference<\/strong> element and configure its properties.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4085\" title=\"Reference field properties selecting the third column to display.\" src=\"\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Reference-field-properties-third-column-1.png\" alt=\"Reference field properties selecting the third column to display.\" width=\"738\" height=\"343\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Reference-field-properties-third-column-1.png 627w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Reference-field-properties-third-column-1-300x139.png 300w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/p>\n<p style=\"text-align: justify;\">Note: The <strong>Modifiable entry<\/strong> option makes the field editable during user entry. By default, the <strong>Reference<\/strong> field is not editable.<\/p>\n<h2 style=\"text-align: justify;\">Results on mobile device.<\/h2>\n<p>See the result below.<\/p>\n<p><a href=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2020\/04\/referential-list-mobile.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-76252 size-full\" title=\"Results on mobile device \" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2020\/04\/referential-list-mobile.gif\" alt=\"Results on mobile device \" width=\"269\" height=\"500\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This is a simple example, but you can obviously imagine a more complex referential list.<br \/>\nFor example, a customer list with various fields that involve a phone number, address, email, etc. or a list of buildings with various items corresponding to each site.<\/p>\n<h2 style=\"text-align: justify;\">Associate a Referential list with a bar code field.<\/h2>\n<p>The objective here is to be able to enter a <strong>bar code<\/strong> and obtain the associated information that will automatically insert into the <strong>Reference<\/strong> field settings.<\/p>\n<p>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.<\/p>\n<p>To do this, you must create a referential list with <strong>bar codes<\/strong> in the <strong>label<\/strong> column.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4106 size-full\" title=\"Creation of an referential list assoociated with bar code field.\" src=\"\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Excel-file-for-barcode.png\" alt=\"Creation of an referential list assoociated with bar code field.\" width=\"354\" height=\"154\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Excel-file-for-barcode.png 354w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Excel-file-for-barcode-300x131.png 300w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/p>\n<p>Once your referential list is created and imported, under the <strong>Configuration<\/strong> tab, <strong>External Lists<\/strong>, go into the definition of your form and insert the <a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/the-barcode-element\/\" target=\"_blank\" rel=\"noopener noreferrer\">Bar code <\/a>item.<\/p>\n<p>Go into the options of your <strong>Bar code<\/strong> field by clicking on the <strong>pencil<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/barcode-referential-list.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-104700 size-full\" title=\"Insert a barcode field.\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/barcode-referential-list.png\" alt=\"Insert a barcode field.\" width=\"1200\" height=\"673\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/barcode-referential-list.png 1200w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/barcode-referential-list-300x168.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/barcode-referential-list-1024x574.png 1024w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/barcode-referential-list-768x431.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Under the <strong>Advanced<\/strong> tab of the <strong>Bar code<\/strong> item, select your external list from the drop-down list<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24147 size-full\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Bar-code-field-properties-for-list-selection..png\" alt=\"Bar code field properties for list selection.\" width=\"1000\" height=\"257\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Bar-code-field-properties-for-list-selection..png 1000w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Bar-code-field-properties-for-list-selection.-300x77.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Bar-code-field-properties-for-list-selection.-768x197.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p>The <strong>List<\/strong> will call to column 1, <strong>label<\/strong>:<strong>bar codes<\/strong>.<\/p>\n<p>It is possible for you to use the following options:<\/p>\n<ul>\n<li>\u201c<strong>Automatically take the location<\/strong>&#8220;: Automatically saves the GPS coordinates when you use the bar code field.<\/li>\n<li><strong>&#8220;Delete the paragraph in the custom-made Word if data is empty or invisible<\/strong>&#8220;: If you have not entered the Bar Code field, the particular paragraph will not appear in your custom-made Word document.<\/li>\n<li>\u201c<strong>Read only for modification or Push<\/strong>&#8220;: If you do not want it, you can modify the field once the entry is saved or when sending a pre-filled Push form.<\/li>\n<\/ul>\n<p>Then insert a <span style=\"color: #333333;\">Reference<\/span> field in your form. In the options of the <strong>Reference<\/strong> field, under the <strong>Properties<\/strong> tab, select the field corresponding to your <strong>Referential list<\/strong> and then select the column to which the Reference field is related.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4112\" title=\"Reference field settings.\" src=\"\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Rreference-field-settings.png\" alt=\"Reference field settings.\" width=\"738\" height=\"325\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Rreference-field-settings.png 893w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Rreference-field-settings-300x132.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Rreference-field-settings-768x338.png 768w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/p>\n<p>In our example, we need to automatically display: flavour and size of the container. Therefore, we will retrieve two <strong>Reference<\/strong> fields.<\/p>\n<p style=\"text-align: justify;\"><strong>\/!<\/strong> Don&#8217;t forget to <strong>confirm<\/strong> your settings and <strong>save<\/strong> your form.<\/p>\n<h2 style=\"text-align: justify;\">Associate a Referential list with a NFC Tag field.<\/h2>\n<p>You can scan an <strong>NFC tag<\/strong> and obtain the information associated with it in the <strong>Reference<\/strong> field settings.<\/p>\n<p>For example, you work in a clothing store and you want to scan the <strong>NFC tag<\/strong> on the label in order to obtain the size and price.<\/p>\n<p>You must create a referential list in the <strong>label<\/strong> column with the information contained in the <strong>NFC tag.<\/strong> In our example, it is the reference code of each garment.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4115\" title=\"Creation of referential list asscociated with a NFC Tag field.\" src=\"\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Clothes-Excel-list.png\" alt=\"Creation of referential list asscociated with a NFC Tag field.\" width=\"550\" height=\"117\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Clothes-Excel-list.png 550w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Clothes-Excel-list-300x64.png 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Once your referential list is created and imported, under the <strong>Configuration<\/strong> tab, <strong>External Lists<\/strong>, go into the definition of your form and insert the <a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/nfc-tag\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>NFC tag<\/strong><\/a> item.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/nfc-tag-referential-list.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-104707 size-full\" title=\"Insert a NFC tag field and set it up.\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/nfc-tag-referential-list.png\" alt=\"Insert a NFC tag field and set it up.\" width=\"1200\" height=\"673\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/nfc-tag-referential-list.png 1200w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/nfc-tag-referential-list-300x168.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/nfc-tag-referential-list-1024x574.png 1024w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2021\/01\/nfc-tag-referential-list-768x431.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<p>Go into the options of your <strong>NFC tag<\/strong> field by clicking on the <strong>pencil<\/strong>.<br \/>\nUnder the <strong>Advanced<\/strong> tab of the <strong>NFC tag<\/strong> item, select your external list from the drop-down list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24151 size-full\" src=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Advanced-tab-NFC.png\" alt=\"Advanced tab NFC\" width=\"1000\" height=\"279\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Advanced-tab-NFC.png 1000w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Advanced-tab-NFC-300x84.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/Advanced-tab-NFC-768x214.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p>The <strong>List<\/strong> will call to column 1, <strong>label<\/strong>: clothing reference codes.<\/p>\n<p>It is possible for you to use the following options:<\/p>\n<ul>\n<li>\u201c<strong>Automatically take the location<\/strong>&#8220;: Automatically saves the GPS coordinates when you use the NFC tag field.<\/li>\n<li><strong>\u201cDelete the paragraph in the custom-made Word if data is empty or invisible\u201d<\/strong>: If you have not entered the NFC tag field, the particular paragraph will not appear in your <a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/custom-made-word-pdf\/\" target=\"_blank\" rel=\"noopener noreferrer\">custom-made Word document<\/a>.<\/li>\n<li>\u201c<strong>Read only for modification or Push<\/strong>&#8220;: If you do not want it, you can modify the field once the entry is saved or when sending a pre-filled Push form.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Insert a <a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/the-reference-element\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #0000ff;\">Reference<\/span><\/a> field in your form. In the options of the <strong>Reference<\/strong> field, under the <strong>Properties<\/strong> tab, select the field corresponding to your <strong>Referential list<\/strong> and then select the column to which the Reference field is related.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4122\" title=\"Referece field linked with the NFC tag field.\" src=\"\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/reference-field-linked-with-NFC-tag-field.png\" alt=\"Referece field linked with the NFC tag field.\" width=\"738\" height=\"326\" srcset=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/reference-field-linked-with-NFC-tag-field.png 893w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/reference-field-linked-with-NFC-tag-field-300x132.png 300w, https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/10\/reference-field-linked-with-NFC-tag-field-768x339.png 768w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/p>\n<p>In our example, we need to automatically display: garment type, size and price. Therefore, we will retrieve three <strong>Reference<\/strong> fields.<\/p>\n<p style=\"text-align: justify;\"><strong>\/! <\/strong>Don&#8217;t forget to<strong> confirm <\/strong>your settings and<strong> save <\/strong>your form<strong>.<\/strong><\/p>\n<hr \/>\n<h3 style=\"text-align: justify;\">Go a little bit further\u2026<\/h3>\n<ul>\n<li><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/create-external-lists-on-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create your external list from Excel<\/a><\/li>\n<li><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/understanding-the-referential-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automatically fill different fields with the referential list. <\/a><\/li>\n<li><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/referential-hierarchical-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">The Referential-Hierarchical List<\/a><\/li>\n<li><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/code-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">Give a code to each item of your list! <\/a><\/li>\n<li><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/understanding-using-filtered-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sort your external list according to your users&#8217; profile.<\/a><\/li>\n<li><a href=\"\/\/kizeoformscom.kinsta.cloud\/en\/tags-help-customise-your-report-and-your-e-mails\/\" target=\"_blank\" rel=\"noopener noreferrer\">Learn more about the tags you can associate to an item of your list to customize your reports!<\/a><\/li>\n<\/ul>\n<hr \/>\n<div class=\"shortcode-block-quote-center\">\n<blockquote>\n<p style=\"text-align: center;\"><span style=\"color: #95c01f;\"> Feel free to comment this article!<br \/>\n<\/span>We would be glad to hear any question, comment or suggestion you may have !<\/p>\n<\/blockquote>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":89230,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[723],"tags":[798],"class_list":["post-89381","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-external-list-en-us"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A referential list allows several fields to be linked to a list<\/title>\n<meta name=\"description\" content=\"This article explains how to create a &#039;Referential&#039;. It does automatically display &#039;references&#039; on the user&#039;s mobile device to speed up the entry process.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A referential list allows several fields to be linked to a list\" \/>\n<meta property=\"og:description\" content=\"This article explains how to create a &#039;Referential&#039;. It does automatically display &#039;references&#039; on the user&#039;s mobile device to speed up the entry process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/\" \/>\n<meta property=\"og:site_name\" content=\"Kizeo Forms\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-16T10:24:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-27T14:26:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"306\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Beno\u00eet Raymond\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Beno\u00eet Raymond\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/\",\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/\",\"name\":\"A referential list allows several fields to be linked to a list\",\"isPartOf\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png\",\"datePublished\":\"2016-09-16T10:24:49+00:00\",\"dateModified\":\"2021-04-27T14:26:09+00:00\",\"author\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/9446eb7b20a12c6a0a72d669daecfd1e\"},\"description\":\"This article explains how to create a 'Referential'. It does automatically display 'references' on the user's mobile device to speed up the entry process.\",\"breadcrumb\":{\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#primaryimage\",\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png\",\"contentUrl\":\"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png\",\"width\":900,\"height\":306},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Understanding and using the Referential list\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website\",\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/\",\"name\":\"Kizeo Forms\",\"description\":\"Mobile Solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/9446eb7b20a12c6a0a72d669daecfd1e\",\"name\":\"Beno\u00eet Raymond\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f4e3683f199a97b3216f2eddc983db10?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f4e3683f199a97b3216f2eddc983db10?s=96&r=g\",\"caption\":\"Beno\u00eet Raymond\"},\"url\":\"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/author\/benoit\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A referential list allows several fields to be linked to a list","description":"This article explains how to create a 'Referential'. It does automatically display 'references' on the user's mobile device to speed up the entry process.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/","og_locale":"en_US","og_type":"article","og_title":"A referential list allows several fields to be linked to a list","og_description":"This article explains how to create a 'Referential'. It does automatically display 'references' on the user's mobile device to speed up the entry process.","og_url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/","og_site_name":"Kizeo Forms","article_published_time":"2016-09-16T10:24:49+00:00","article_modified_time":"2021-04-27T14:26:09+00:00","og_image":[{"width":900,"height":306,"url":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png","type":"image\/png"}],"author":"Beno\u00eet Raymond","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Beno\u00eet Raymond","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/","url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/","name":"A referential list allows several fields to be linked to a list","isPartOf":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#primaryimage"},"image":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#primaryimage"},"thumbnailUrl":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png","datePublished":"2016-09-16T10:24:49+00:00","dateModified":"2021-04-27T14:26:09+00:00","author":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/9446eb7b20a12c6a0a72d669daecfd1e"},"description":"This article explains how to create a 'Referential'. It does automatically display 'references' on the user's mobile device to speed up the entry process.","breadcrumb":{"@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#primaryimage","url":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png","contentUrl":"https:\/\/kizeoformscom.kinsta.cloud\/wp-content\/uploads\/2016\/09\/ES-tutorial-kizeo-forms-e1476106241105.png","width":900,"height":306},{"@type":"BreadcrumbList","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/understanding-the-referential-list\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/"},{"@type":"ListItem","position":2,"name":"Understanding and using the Referential list"}]},{"@type":"WebSite","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#website","url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/","name":"Kizeo Forms","description":"Mobile Solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/9446eb7b20a12c6a0a72d669daecfd1e","name":"Beno\u00eet Raymond","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f4e3683f199a97b3216f2eddc983db10?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f4e3683f199a97b3216f2eddc983db10?s=96&r=g","caption":"Beno\u00eet Raymond"},"url":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/author\/benoit\/"}]}},"_links":{"self":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/posts\/89381"}],"collection":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/comments?post=89381"}],"version-history":[{"count":0,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/posts\/89381\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/media\/89230"}],"wp:attachment":[{"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/media?parent=89381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/categories?post=89381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kizeoformscom.kinsta.cloud\/en-us\/wp-json\/wp\/v2\/tags?post=89381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}