Track Anything and Everything Using Custom Fields

custom fields

This is an older blog. See the latest post on Custom Fields.

For efficient asset tracking and inventory management, EZOfficeInventory comes with a predefined set of fields. However, every business is unique and you may need specialized attributes for your specialized needs. For this we provide Custom Fields to track any data point with an asset/inventory.

Here are a few examples of how our customers in various industries make use of this feature:

Custom Field(s)
Media and Production

Recording the focal length of a camera lens, keeping tap on whether a flashlight is buzzed.

Service Providers

Tracking Job Numbers, condition of the equipment checked out, recording any damages on return, setting up maintenance alerts.

Health Care

Expiration date alerts on drugs, recording whether a tool has been sterilized after return.

Software and IT

MAC Address of devices, Installed OS, Installed programs.

Let’s dig a bit deeper!

Adding Custom Fields

You can add custom fields from More -> Custom Fields -> Items -> Add Custom Field. A custom field can be any field type e.g. radio buttons, text field, date field etc. When you’re adding a custom field, you can choose to associate it with groups of items:

  • All the groups i.e. all the items
  • All the groups that you’ll create in future
  • Only a few specific group (use shift+click or ctrl+click to select a bunch in a single go)

Customizing Assets and Inventory Details

All associated custom fields will start appearing on the relevant items’ details page. e.g. Focal length will appear on the Lens page details. See image below:

Custom Attribute shown on Asset detail Page

You can edit a single item to update the custom field values. Or you can select a bunch of items on Asset Listing (Items -> Assets) and from Actions -> Edit, edit custom fields for all of them in a single go. Same goes for inventory and asset stock listings. Say you have a stock of 10 camera lens that are 65mm. You can mass edit all of them to update their focal length to 85mm.

Mass EditCustomizing Items Listing

The best part is that you can edit the Asset, Inventory and Asset Stock listing tables to include columns that are more important to you. These columns can also include custom attributes.

Customizing Items Listing

Screenshot: Customizing Items Listing

Customizing Check-in/out and other events

You can add custom fields of your choice on Check-in/out forms. The Display on checkout and Display on check-in options are available under Preferences when you’re adding/editing a custom field.

Display on Check ins/outs

Here are some ways in which you can configure these settings:

  • Selecting Display at checkout will show this custom field on the checkout form. The user can enter a new value for this field.
  • If you select Only record with checkout…, the value entered by the user when checking out assets will NOT be updated with the asset. It’ll only get recorded in checkout events log (Asset Detail -> History -> Check-in/out history and Reports -> Checkout events).
  • Selecting Display at reservation shows the custom field on reservation form. The values recorded for the custom field(s) on reservations are also recorded in the checkout events log when you check out a reservation.
  • Similarly, you can configure how the custom field(s) will Display on check-ins
  • You can also make it mandatory for the users to add a value on check-in/out.

Enforce Value at Check in/outSet up Date Alerts

You can also enable date alerts using custom fields. For example, you may want to get an alert when a laptop battery expires. For scenarios where some equipment require regular servicing, you can set up recurring date alerts e.g. a Forklift Truck requiring inspection every 2 months.

Custom field for Date alertRecord History

Keep a history trail of how a custom field value is changing over time for a particular item. Make sure that the Save History option is checked under preferences for the custom field(s) for which you’d want to have a history record.

Say you have a custom field called OS for your Macbooks. You can track when was the OS updated to Yosemite from Mavericks, and who made that change.

You can also export the history trail to a CSV.

History trail of Custom Attribute value change

Other options

  • Any custom field can be printed on a Print Label.
  • You can also have a custom field shown when someone scans the QR code for an asset. Enable Company Settings -> Show on Public QR Code Page -> Custom Fields.
  • Make sure to have the relevant preferences selected.

Print Label & Public QR Code PageImporting Custom Fields

Data for all the custom fields can be imported to your EZOfficeInventory account from an excel sheet. The custom fields are available when you’re mapping columns during the excel import. Make sure to create all the required custom fields from More -> Custom Fields -> Items before importing data for them.

If you have more questions on this feature, do write to us at Log your suggestions at our User Community Forum and join in the conversation with us on twitter @OfficeInventory.