Custom Fields

freepik

From time to time, we publish in-depth articles on specific features of Easy-IP.

This month, we focus on creating your own Custom Fields.

You can define your own custom fields for specific information relevant to your network, such as Operating System, Circuit Number, Line Speed, Telco Supplier.

You can keep track of any kind of related information including, OSPF, VOIP, MPLS, VRF or VLAN Numbers.

Easy-IP supports six types of custom field:

  • String: Free-form text (up to 255 characters)
  • Timestamp: A date & time in the format (DD/MM/YYYY HH:MM:SS)
  • Float: Used to store single-precision floating-point numbers.
  • Currency: Displays your local currency (up to 2 decimal places)
  • Integer: A whole number (positive or negative)
  • Memo: This is a BLOB (Binary Large Object) Field. It could store a large chunk of data, document types and even media files like audio or video files.

Here's a screenshot showing the custom fields added to the Addresses table. You can add fields to the Subnets table too.

Supported fields types include, text string, timestamp, memo, boolean, and more.

Add a custom field via the Server Manager. This screenshot shows a field called VLAN_NUMBER added to the Subnets table.

Change the order of the fields with the Move Up/Down buttons.

Click the Edit Field Properties button to change the function or appearance of the field.

If you need to validate the data entry, for example to ensure that all phone numbers are entered in the same format (for search purposes), you can use the Edit Mask function.

This contains a number of predefined templates for telephone numbers and extensions, social security numbers, zip codes, dates, and times.  

The Field Lookup Tab lets you add your own values to a drop-down list which appears the Easy-IP Client.

For example,  you might want to add a list of Switch vendors to ensure that nothing is missed due to a typing error during data input.

Field Lookups

Checking Only allow values from the lookup list will force users to add values from the list of lookup items. No other values will be allowed.

You can import and export values to/from the lookup list via the Import and Export buttons. You can move lookup items up or down the list via the Move Up/Down buttons. You can also use the Sort button to sort the items into alphabetical order.

The Search Tab shows options for enabling the Search function.

Search

Index this field for Simple Searched and Queries
When this option is checked, the database field will be indexed. The index will be added/removed the next time the server is restarted.

Use this field in the Full Text Search index
When checked, the field will be used in the Full Text Search index. If you enable this option for a field that already has data you will need to Re-Index the database in order for the existing records to be included in the search results.