Use Custom Fields in EZOfficeInventory

custom fields banner

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:
1. Use cases
2. Custom field types
3. Modules
3.1. Items
3.2. Carts
3.3. Locations
3.4. Purchase Orders
4. (Items only) Different preferences for different Custom fields
4.1. Mandatory Custom fields for new items and reservations
4.2. Customizing check-in/checkout and other events
4.3. Setting date alerts
4.4. Editable by Staff user vs. restricting visibility to Administrators
4.5. Saving history
4.6. Displaying on sale and displaying on add stock
4.7. More preferences
5. Deleting Custom fields
6. Customizing Asset, Asset Stock, and Inventory Details
7. Customizing Items Listing
8. Alerts for Custom fields
9. Importing Custom fields
10. Reporting, API calls and more
11. Utilizing Custom Fields on-the-go

1. Use cases

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

Industry

Custom Fields

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 post-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!

2. Custom Field types

Here’s a list of all possible Custom field types that you can create for the various modules. The available options change depending on the module.

  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.
  8. Boolean: for attributes that have either a Yes or a No value.

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.

3. Modules

  • Items
  • Carts
  • Purchase Orders
  • Members
  • Vendors
  • Locations

3.1. Items

Add custom fields from More –> Custom Fields –> Items –> Add Custom Field

custom fields - types

All associated Custom fields will start appearing on the relevant Item Details Pages.  item details page

Associating Groups with Custom Fields for Items

When you’re adding a Custom field, you can choose to associate it with

  • All groups (therefore, all items) 
  • All future groups 
  • Only a few specific groups (use shift+click or ctrl+click to select a bunch in a single go)group association

Learn More: Assigning Groups to Custom Fields

3.2. Carts

Cart Custom fields are of the following types:

  • Single line text
  • Number field
  • Paragraph text
  • Boolean

Add custom fields from More –> Custom Fields –> Cart –> Add Custom Field.  custom field for cart

Here’s a look at the created Custom field in the Cart Details Page.

cart details page

Custom fields for Carts cannot be associated with groups. However, you can make this field mandatory for all carts under Preferences.

Furthermore, for an action taken on a Cart e.g. reserve, check out or check in, all Custom fields associated with the added items in that cart will show up.cart return page

3.3. Locations

Custom fields for Locations can be of 5 types:

  • Number field
  • Single line text
  • Paragraph text
  • Boolean
  • Dropdown

To create, head to More –> Custom Fields –>  Locations –> Add Custom Field.

custom fields for locations

For this example, we’ve created a mandatory boolean field for Instore Pickup Availability by location.

Once saved, all new Locations will require you to specify this attribute at the time of creation. All old Locations will require you to specify this attribute whenever you choose to edit them.

custom field instore pickup location

3.4. Purchase Orders

Custom fields for Purchase Orders can be of 4 types:

  • Single line text field
  • Number field
  • Paragraph field
  • Boolean
  • Date field
  • Dropdown

Create a Custom field from More –> Custom Fields –> Purchase Order –> Add Custom Field. custom field for purchase order

Note: These are only visible to admins.

Here’s a look at the Purchase Order.po details page

4. (Items Only) Different Preferences for Different Custom Fields

4.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 editNote: 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

4.2. 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. The image below 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 set a value on check-in/out.

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

FAQ: Tracking Job and Project Number using Custom Fields

4.3. 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 set up 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 update alerts.date alerts

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

4.4. Editable by Staff User vs. 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 Item 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

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

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

4.7. Other Options

  • Any custom field can be printed on a Print Label. For the custom field to appear on the label designer as an element, you have to open the relevant field, click on ‘Edit’ and select the “Make available for print label” option.
  • 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

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

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

7. Customizing Item Listings

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

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

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

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

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