|
|
Fields and Properties |
|
|
|
|
||
|
Fields and Properties |
|
|
|
|
|
Fields and Properties
|
|
|
Fields and Properties |
|
|
|
|
||
|
Fields and Properties |
|
|
|
|
|
|
|
||
To view the database default table structure, click the 'Tables' tab:
The table whose fields are displayed can be changed via the "Table name" drop down box.
Table fields can be modified here to reflect your company's own administrative and reporting needs.
By default, only the fields that are visible to the user are displayed. To display all table fields, check the "Show hidden fields" check box.
Add Field/Alter field size/Delete field
Up to 255 fields in total can be added to a table. Custom fields may be defined to meet the unique needs of your organisation.
User defined fields can be added to the both the Subnet and Address tables.
Clicking Add Field will display the Add field dialog box.
The Field Size property is only displayed for Text fields.
When editing a field, only the Field Size can be changed and it can only be changed to a value greater than the current size. This is a limitation imposed by the underlying database.
To remove a field from the database, select it and click Delete Field.
Unlike previous versions of Easy-IP field changes do not take immediate effect. Instead the changes are added to a list of changes that will take effect the next time the Easy-IP Server is restarted.
This has several advantages:
| 1. | You can add and edit fields with users still connected to the Easy-IP Server. |
| 2. | You can 'undo' changes in the list until the server is restarted. |
| 3. | The changes can be made when the least number of users will be affected. |
Once you are happy with your changes you can restart the server. This can be done immediately, by clicking the restart the server now link or by scheduling the server to restart at a convenient time.
|
In previous versions of Easy-IP the Default Value setting was found in this dialog. It can now be found in the Field Properties dialog. |
Selecting a field and clicking Edit field properties will display the field propertied dialog.
Display Name |
The name displayed in the header of the column or card |
Font Colour |
The default colour of the font used to display the field values. Note that this value can be overridden by lookup field values |
Background Colour |
The default background colour used to display the field values. Note that this value can be overridden by lookup field values |
Bold/Italic/Underline |
These check boxes allow you to change the style in which the values are displayed. |
Hidden |
When checked, the field will be hidden by default. |
Display as URL |
This option display the value of the field as a URL. When clicked, the URL will be displayed in the default application. |
Fixed Column |
If this option is checked the column will be fixed to the left hand side of the grid. |
Read Only for Users |
Check this option if you don't want the field to be editable in the grid or card view. |
Read Only for Host Discovery |
Check this option if you don't want the field to be writable via host discovery. |
Mandatory Field |
Forces users to enter a value for the field when it is edited in an Easy-IP client (both Windows and Web clients). Note that the field is not mandatory when added via a Subnet/Host Discovery. |
Default Value |
Sets the default value for the field. |
Edit Mask |
Edit masks can be used to force the user to enter text in a particular format. For example, you may wish the user to enter a telephone number in the format "(345)234-12-07". To do this, you would use the edit mask "(\(\d\d\d\))? \d(\d\d?)? - \d\d - \d\d". for more information about edit masks, see Using Edit Masks |
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 and Move Down buttons.
To add a new field lookup item to the list click the Add button.
Value |
Enter the value of the lookup item. For example, if the field name is "Device Type", the value name could be "PC" |
Description |
Enter a descriptive name for the value. For example, if the value is "Y", but you would like "Yes" to be displayed in the grid or card view, enter "Yes" in the description box. |
Font Colour |
The colour of the font that will be used to display record fields whose value matched the lookup value. |
Background Colour |
The background colour that will be used to display record fields whose value matched the lookup value. |
Bold/Italic/Underline |
The font style that will be used to display record fields whose value matched the lookup value |
