Use Custom Fields in EZOfficeInventory

asset tracking software

For efficient asset tracking and inventory management, EZOfficeInventory comes with a predefined set of fields. However, we understand that every business is unique and you may need some custom fields as per your specific needs. To customize your inventory data depending on your needs, we provide Custom Fields, which can be used to track any data point with an item, cart, or purchase order added to our asset tracking software.

Learn More about: Types of Items | Cart Management | Purchase Orders

CONTENTS:

Custom Field Use Cases
What Modules Can Have Associated Custom Fields?
Types of Custom Fields
Associating Groups to Custom Fields for Items
Different Preferences for Different Custom Fields: Items Only
1) Mandatory Custom Fields for new Items and reservations
2) Customizing check-in/checkout and other events
3) Setting date alerts
4) Editable by staff user versus restricting visibility to administrators
5) Saving history
6) Displaying on sale and displaying on add stock
7) More preferences
Deleting Custom Fields
Custom Fields View on Item, Cart, and Purchase Order Details Pages
Customizing Asset, Asset Stock, and Inventory Details
Customizing Items Listing
Alerts for Custom Fields
Importing Custom Fields
Reporting, API Calls and more
Utilizing Custom Fields ‘On-the-go’

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

Industry(s)

Custom Field(s)

Media and Production

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

Service Providers Tracking Job Numbers, the 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.

When using custom fields for carts, you can track data points like shipment number, special handling instructions, and delivery fee for Cart # 777 which has been checked out to Emily Rose.

For purchase orders, a custom field can be defined as to what kind of binding (e.g. saddle stitch) you would like for the next stock of company handouts or what paper size (e.g. A4 or A6) should be used.

Let’s dig a little deeper!

What Modules Can Have Associated Custom Fields?

  • Items
  • Carts
  • Purchase Orders
  • Members
  • Vendors

Types of Custom Fields

There are a few different types of custom fields in EZOfficeInventory. The options available will change depending on which module you’re on:

  1. Checkbox: choose between a number of pre-set values, making it easier to speed up processing times when dealing with high-volume items.
  2. Date Field (Alert): specify date alerts to receive reminders on the specified date. This custom field can also be set to a recurring alert.
  3. Dropdown: compress an extensive list of options and also set a default value.
  4. Multiple Choice: quickly choose through a shorter list of options with all of them displayed.
  5. Number Field: specify the quantity for a custom attribute and set a default value for it as well.
  6. Paragraph Text: allow users to add detailed comments and any other important details that may be out of the usual.
  7. Single Line Text: for attributes that can have several different values which cannot be listed or categorized.

A Note on Boolean Custom FieldsBoolean values are included in all custom field types except Items. They are great for providing quick insights into your workflows. Is an employee working with you full time? Do you have a discount code with a vendor? You can ask users ‘Yes/No’ questions and quickly process their answers.

You can, for example, use these insights to figure out whether a Cart is at its location of origin, or if it was inspected on the field. You can even run a Custom Report – using Carts as the primary module and the boolean as a column – and collate the responses for a better understanding of trends or bottlenecks.

It is important to note that the custom field has to be mandatory for the boolean value type. This is because users must choose either a Yes or No value; not filling in either checkbox provides data that ultimately isn’t meaningful.

Custom Fields for Items

For Items: You can add custom fields from More -> Custom Fields -> Items -> Add Custom Field

custom fields - types

Associating Groups to Custom Fields for Items

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)group association

Learn More: Assigning Groups to Custom Fields

For Carts: You can add custom fields from More -> Custom Fields -> Cart -> Add Custom Field. Unlike custom field for items, a custom field for carts can be of 4 different types only i.e. single line text field, number field, paragraph field, or a boolean type. They cannot be associated with groups. However, you can make this field mandatory for all carts under Preferences.custom field for cart

For Purchase Orders: You can add custom fields from More -> Custom Fields -> Purchase Order -> Add Custom Field. Custom fields for purchase orders can of 3 types, i.e. single line text field, number field, paragraph field, or a boolean type.custom field for purchase order

Note: These are only visible to admins.

Different Preferences for Different Custom Fields: Items Only

  1. Mandatory Custom Fields for New Items and Reservations

– Mandatory on Create/Edit: When you enable this option, you’ll get to have an additional field while creating or editing an item. For example, you want to record the color of every item whenever a new item is added to the system or being edited by a staff user. This way you can make it a compulsion for the users to fill in this field. See image below:mandatory on create or edit

Note: This custom field will only appear on item details pages that belong to the group associated with it.

– Mandatory on Reservation: On enabling this preference, a custom field will appear whenever you reserve an item for checkout. To enable this, you must first select ‘Display at Reservation’ under the ‘Display at Reservation’ preference. Useful when a user wants to reserve ‘white’ background sheets for an event.mandatory on reservation

Learn More: Item Reservation in EZOfficeInventory

  1. Customizing Check-in/Checkout 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 checkin and checkout

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.
  • Selecting ‘Mandatory on Check-in/Checkout’ will show this custom field on the checkout form. The user then cannot check-in/checkout an item without entering a new value for this field. Note: This field will not be pre-populated with the last value or default value defined by you when creating the custom field. Below image shows how the mandatory (*) and ‘display but optional to fill’ custom fields appear on check-in/checkout forms:mandatory vs optional fields
  • If you select ‘Only record with checkout event…’, 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. These logs appear under an Item’s Details Page -> History button -> Check-in/out History, and Reports -> Checkout eventsLearn more about Item Reports.
  • Selecting ‘Display at reservation’ shows the custom field on the 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.

Note: All above preferences can be used for any type of custom field for items only.

Quick FAQ: Tracking Job and Project Number using Custom Fields

  1. Set up Date Alerts

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

When creating a ‘date alert’ custom field, you can either set to receive a notification on a specified date or setup recurring date alerts e.g. every year for 3 times. An alert in advance can also be enabled for this type of custom field. Learn More about setting up date alerts.date alerts

Read More: Setting up Recurring Services and Maintenance Events in EZOfficeInventory

  1. Editable by Staff User Versus Restricting Visibility to Administrators

On enabling ‘editable by staff user’, all users in your company will be able to view and edit this custom field. This option will overlap the settings configured under user listings. Learn More about Items’ Visibility and User Listings.editable by staff

On the other hand, ‘restricting visibility to administrators’ will only allow the admins in your company to view this custom field or edit it. One of these two options can be enabled at a time.

Read More: Flavors of Arbitration in EZOfficeInventory

  1. Save 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.save history

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.history tab

You can also export the history trail to a CSV.

  1. Display on Sale and Display on Add Stock

Though the custom fields can be recorded and displayed on all types of items and check-in/checkouts. However, you can also choose to display a custom field on sale and add stock forms. Enable them under the preferences for custom field you’d want to display.display on sale and add stock

  1. 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 and qrcode

Deleting Custom Fields

You have the option to edit/delete any custom field under More -> Custom Fields.deleting custom fields

Warning: Deletion of a custom field will also delete the associated values for the items associated and recorded with it. This applies to custom fields for carts and purchase orders as well.

Custom Fields View on Item, Cart, and Purchase Order Details Pages

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

– Custom Fields on Cart Details Page (see image below):cart details page

On an action taken on a cart e.g. reserve, checkout or check-in, all the custom fields associated with the added items in that cart will show up (see image below):cart return page

– Custom Fields on Purchase Order Details Page (see image below):po details page

Customizing Asset, Asset Stock, and Inventory Details

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 lenses that have a focal length of 65mm. You can mass edit all of them to update their focal length to 85mm.mass edit

Customizing 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 fields.custom columns

Learn More: Filter Items using Custom Fields

Alerts for Custom Fields

Custom fields set as ‘date field’ under types when you create/edit a custom field receives an email alert on a specified date or recurring intervals.

Learn More: Types of Alerts for each User Level | Types of Email Alerts in EZOfficeInventory

Importing 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.

Reporting, API Calls and More

1. You can also get into more insights that involve custom fields from Reports -> Custom Reports -> Custom Fields Report. These reports can be filtered. You can export these reports to CSV format or upload them to your Dropbox account.

Learn More: Upload Images and Documents to your Dropbox Account

2. You can retrieve all your custom fields data and custom fields history recorded in our system via API calls. Get API for Custom Fields here.

3. Custom Fields can be searched through as part of the general search function. Learn More about search limit for custom fields.

Utilizing Custom Fields ‘On-the-go’

We believe in making our asset tracking software even better than yesterday. Custom fields for items can also be utilized using EZOfficeInventory’s mobile application. You can view custom fields on an item’s details page and edit custom fields while creating an item (asset, asset stock, and inventory) from the mobile app. They are also viewable/editable when taking actions like check-in/checkout on items.

Download Mobile Application: iOS | Android

ezofficeinventory mobile app

Share your queries regarding our Asset Tracking Software

EZOfficeInventory is the leading asset tracking software used by a diverse set of companies worldwide.

For more assistance, drop us an email at support@ezofficeinventory.com. You can also share your ideas with us or visit our knowledge base and blog for detailed support posts.

Follow/Join us: Twitter | Facebook | Linkedin