Manage custom fields and groups

The custom fields overview article explains the different types of custom fields and provides examples for each. This article shows how to create and populate a custom field on a meter.

You can always find the Custom Fields option in the module menu of the related object.

Example: How to create a meter custom field

  1. In the Sites and Meters module menu, choose Custom Fields for Meters.
  2. Click the plus (+) icon to a add a custom field.
    • Choose the type of custom field you want.
    • To upload a document, select an advanced custom field.
    • If no fields exist yet, use the Add a new field dropdown.


       
  3. Enter a label for the field. This is the prompt that appears in the application.
    If it's a list field, click Edit Options to add at least one list item.
  4. Save the custom fields.
  5. Add values for each meter on the Properties tab.
    Or use an update spreadsheet to update multiple meters at one time.

Note: Advanced custom fields support more complex data (like documents) and can only be added directly in the application.

Populate a custom field in the application

  1. On the Properties tab of the object click Edit.
  2. Enter the values for the custom fields.
  3. Save.

Populate a custom field with a spreadsheet

  1. Go to the Setup Spreadsheet Log, click Download.
  2. Download an update sheet for the object you want to update.

     
  3. (Optional) Apply filters to limit the data included in the spreadsheet.
  4. Open the spreadsheet.
    • Green columns show current values.
    • Enter updates in the white columns
  5. Save your spreadsheet.
  6. Return to the Setup Spreadsheet Log and click Import.
  7. Check the upload status:
    • If there are errors, download the error (kickout) spreadsheet.
    • Correct the errors and upload the error spreadsheet.

System custom fields

System custom fields are locked by the system to ensure their configuration cannot be changed. Most likely these fields are being used to support external automation, like a reformatter or API script.

Steps to create a group

  1. Create the custom fields first.
  2. Populate the custom fields for each object—either directly in the application or by using a spreadsheet.
  3. When creating the group, decide whether to:
    • Use an existing category, or
    • Create a new category for the group.
  4. Create an automatic group by applying filters based on the custom fields.

Example: Create a new group and new category 

  1. Go to the Groups and Benchmarks module.
  2. Under Site Groups, click the plus (+) icon to Add a New Site Group.
  3. In the form, you can:
    1. Enter the new group name, and
    2. Create a new category for the group.