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:
Media and Production
Recording the focal length of a camera lens, keeping tap on whether a flashlight is buzzed.
Tracking Job Numbers, condition of the equipment checked out, recording any damages on return, setting up maintenance alerts.
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:
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.
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 attributes.
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.
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.
Set 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.
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.
- 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.
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.
If you have more questions on this feature, do write to us at firstname.lastname@example.org. Log your suggestions at our User Community Forum and join in the conversation with us on twitter @OfficeInventory.