Add or remove attributes associated with an attribute table

Attributes are characteristics of assets, structures, and establishments. When you create an attribute table, you collect common attributes in one form.

You can associate existing attributes with an attribute table or create new attributes. When you create a new attribute, you automatically add the attribute data to the Civic Platform database.

Populate an attribute table by associating attributes with the table.

Example: You might have an attribute table named Street Light. You could populate the table with street light attributes, such as bulb type.

To associate an attribute with an attribute table

  1. From the Administration menu, select Assets > Attribute table.

  2. Select the attribute table in the Attribute table name column.

  3. Select the Attributes tab.

  4. Complete one of these steps:

    • To add existing attributes to the table:

      1. Select Look up.

      2. Complete the search criteria to find the attributes you want.

      3. Select Submit.

      4. Select the check box next to the attribute(s) you want to add to the table.

      5. Select Select.

    • To create a new attribute for the table:

      1. Select New.

      2. Complete the fields that display.

        Field name Field description
        Attribute group Use this field to organize the attributes. Choose a group for the attribute from the drop-down list.
        Attribute label

        (Required) Enter the label of the attribute the user sees when adding or editing an asset, structure, or establishment.

        Example: You can have an attribute called “District” for an asset, but different assets have different districts. You can create multiple district attributes, like DistrictWater and DistrictPark, but give them all the same label.
        Attribute name

        (Required) Enter a unique attribute name, such as "Commercial Establishment Capacity." The attribute name is a unique name for the attribute.

        Note: This name only displays for administrators.
        Value data type

        (Required) Set a default value for the attribute. When a user creates an asset, structure, or establishment that includes this value or attribute, the field has this default value, making the user experience more efficient. To apply a date, select the date picker.
        Description Enter a description for the attribute.
        Attribute length Enter the number of characters the attribute field allows.
        Default value

        Enter a default value. When a user creates an asset, structure, or establishment that includes this value or attribute, the field displays the default value, making the user experience more efficient.

        Note: If you are configuring a drop-down list, you can add values to the drop-down list so that a user has multiple values from which to choose.
        Unit type Use the list menu to choose the unit type to be attributed to this attribute.
        Value required flag Select Yes to require this attribute to be mandatory for the template.
        Display order

        Enter a number to determine the position of the first field.

        Example: If you want the field to display before any other fields, enter 1.
        Searchable flag Select Yes to display the field when a user begins a search for an asset, structure, or establishment. When searching, the search form displays the appropriate attributes when the user selects a Group and a Type.
        Is dropdown list? Select Yes if you want the attribute to have a drop-down list providing specific values for the user. These values display to the user when they create an asset with this attribute.
        Use shared drop-down lists

        Select this option to associate shared drop-down lists with an asset attribute. When you select this option, a search field enables you to search for existing shared drop-down lists.

        • If you search for a shared drop-down list that does not match any existing shared drop-down lists, then the Shared drop-down list search page opens. Use this page to search for existing shared drop-down lists.

        • If you search for a shared drop-down list that matches one existing shared drop-down list, then the existing shared drop-down list displays on the Attribute form.

        • If you search for a shared drop-down list that matches multiple existing shared drop-down lists, then the Shared drop-down list select page opens and you can select the desired drop-down list.

        Range search flag

        Select Yes to allow for range searches for this attribute.

        Note: The Range search flag field is only available for Date and Number value data types and is disabled when other value data types are selected.

      3. Select Submit.

You can delete an attribute from an attribute table. When you delete an attribute from a table, you also delete the link between the attribute table and any associated templates.

You can recreate the association between an attribute table and a template as required.

To delete the association between an attribute and an attribute table

  1. From the Administration menu, select Assets > Attribute table.

  2. Select the attribute table link in the Attribute table name column.

  3. Select the Attributes tab.

  4. Select the check box next to the attribute(s) that you want to remove from the attribute table.

  5. Select Delete.

  6. Select OK to confirm the deletion or Cancel.

Related Topics Link IconSee also