How to create extended value lists

1. Value lists are created and edited under Space setting. Navigate to the Space setting page and click Value lists in the left panel menu.

2. To create an extended value list, click on Create extended value list.

3. If you want to you can enter values manually or paste them from Excel in which case the interface understands what columns and rows each value goes in.

3. You can right click to add/remove rows and columns. You can rename columns by clicking the label and typing in a new name. This is used when referencing the values inside a form. 

4. You need to add a reference name to your list that will be used in forms to call upon the list.

5. You can automatically generate key values by ticking the checkbox.

6. By checking the box "External value list" you can manage the value list via an API or Barium integration Agent (BIA). It is possible to synchronize values from Excel, CSV, XML and MSSQL 

WARNING: If  "External value list"  is checked and the value list is saved. You will no longer be able to view or edit the value list from Barium Live. The Value list will only be reachable via API.

7. Value lists are exclusive to one space only. When you have one or more value lists in a space they will be presented like in the picture below. You are free to edit or remove lists using the buttons to the right. If the list is used however, a warning message will be issued and you will not be able to delete the value list unless you've freed up its connections.

How to use extended value lists

Extended value lists are mainly used in forms, where they show up as a searchable single select drop down list. Value lists helps you steer what data input end users can submit and can be used for instance to steer gateways in your processes. 

1. In order to reference an extended value list, select it from the left side panel and add it to your form canvas just like any ordinary field. The key value will be the default value to be displayed in the field.

NOTE: This can be altered by adding the attribute displayField and typing in the name of the column label that you want to display in the field. For example: A or B

2. In order to reference coresponding columns after making the initial selection in the main field, simply add as many fields as you wish and add the attribute valueFrom and type in the name of the field followed by the name of the column. For example: field1.A