This is a NetX Labs feature! We couldn’t wait to get your feedback on it, so we are providing you early access, even though there is still room for improvement. Don't hesitate to let us know your thoughts about this feature in the NetX Ideas Portal .
It is common for assets to have attributes that are related, like city and state or company and address. In these cases, the metadata lookups feature can auto-fill certain attribute values based on specific criteria.
Key and target attributes
Key attributes act as triggers for the rest of the attributes in the lookup set. They are displayed with a keyicon. When a key attribute is edited with a lookup value, each target attribute in the set will update according to that key value. If you are uncertain what values constitute a valid lookup, type "" (double quotes with no space) into the key value's input field to see a list of value suggestions in a dropdown menu.
Target attributes have values which are triggered based on the key attribute value for the lookup. They are displayed with a targeticon. When a relevant key attribute is filled with a lookup value, every targeted attribute in the lookup will update with a value.
Using metadata lookups
Metadata lookups can only be used with text, text area, pulldown, and number type custom attributes .
Metadata lookups can be used in the grid editor – but unlike other editing contexts, the lookup targets will only populate if you select them while editing the key attribute. Targeted attributes can be selected by highlighting an entire row, or by holding the control (Mac) / ctrl (Windows) button and clicking on individual cells. If some of the target attributes are selected, only those attributes will be affected by the key attribute. If there are no target attributes selected, editing the key attribute will not affect any of its targets regardless of its value.
Configuring metadata lookups
Creating a dataset
Metadata lookups require a .csv or .xlsx formatted file uploaded to the dataset manager . If you would like to know how to properly format a .csv or .xlsx file for upload into NetX, see Uploading Attribute Data .
In short, a properly formatted metadata lookup has:
- Column headers which match an existing custom attribute . Note that each attribute name must match exactly, including casing.
- Values under each column header which correspond to the column header attribute.
Metadata lookups can only be configured for text, text area, pulldown, and number type custom attributes .
Each lookup consists of named custom attributes which already exist in NetX; these attributes act as either Key or Target attributes depending on which column they are assigned in the dataset.
- Key: The key attribute in a metadata lookup acts as a trigger for all other attributes in the set. If a user edits the key attribute in NetX with one of the values in that attribute's column, the values of the target attributes will update according to the other entries in that row of the dataset. The key attribute is always the attribute named in the first column of your dataset.
- Target: Every named attribute beyond the first column are target attributes. When the key attribute is updated in NetX with one of the values in its column, each target attribute will update according to that value's row in the dataset.
Below is an example of a data file configured as a metadata lookup:
- Product name is the key attribute.
- Description, Model number, and Status are all target attributes.
- An exact value match for a Product name will then populate the Description, Model number, and Status according to the value match's row.
The following property is required in order to enable metadata lookups:
If this property's value is true, the metadata lookup feature will be enabled for your NetX instance. If this property is set to false, you will not be able to use the metadata lookup feature.