Add, Edit & Delete Custom Fields

Custom fields are a Roadsoft feature that replace existing user-defined fields. Custom fields are available in the Road, Culvert, Sign, Sidewalk, and Drainage Structure Modules. There are several field type options including Date, Decimal, Long Note, Lookup (drop-down list), Short String, Whole Number, and Yes/No Flag. Custom fields provide agencies with an opportunity to fulfill specific data collection needs that are not present within the available standard Roadsoft fields. There are no limits to creating custom fields; however, it is advisable for agencies to discuss the value-added and expected data return results for a new custom field prior to creating one.

Add a Custom Field

With an applicable map layer visible and active:

Select an asset on the map.

Select View Module from the map options.

Select the Add/Edit Custom Field link will vary depending on the module and may be located either directly in an information panel in the module or within a Custom Fields tab.

Select the Add button.

Select the Custom Type drop-down list to select a field.

Date – Calendar date in month/day/year format. Defaults to 1/1/1900.

Decimal – A numeric field that includes a decimal with no rounding. Acceptable values are positive or negative numbers with or without decimal places.

Long Note – An unlimited length field that accepts alphanumeric and special characters.

Lookup – A drop-down list field with agency defined list values.

Short String – A field limited to 80 characters that accept alphanumeric and special characters.

Whole Number – A numeric field without a decimal. Acceptable values are positive or negative numbers that do not include a decimal place.

Yes/No Flag – A drop-down list that provides a single selection of a ‘Yes’ or ‘No’ value.

Select the Label field to enter a name for the field.

Select the Abbreviated Name field to enter an abbreviation for the field’s name.

Select the Description field to enter a description of the field.

Select the Save button to create the field, or select the Cancel button to exit without saving.

For lookup field types (drop-down lists), add list values.

Select the Tools option from the main menu.

Select View/Edit Lookup/Defaults.

Select the asset drop-down, and select the applicable asset.

Locate and select the custom field in the Lookup Table list.

Select the Add button.

Enter a list value in the Description field.

Enter an abbreviation of value name in the Abbreviation field.

Select the Save button to save the value for the lookup (drop-down list), or select the Cancel button to exit without saving.

Edit Custom Field Lookup Values

Select the Tools option from the main menu.

Select View/Edit Lookup/Defaults.

Select the asset drop-down, and select the applicable asset.

Locate and select the custom field in the Lookup Table list.

Select the Edit button.

Edit the value name (Description) or the value abbreviation.

Select the Save button to save the value for the lookup (drop-down list), or select the Cancel button to exit without saving.

Delete a Custom Field

With an applicable map layer visible and active:

Select an asset on the map.

Select View Module from the map options.

Select the Add/Edit Custom Field link will vary depending on the module and may be located either directly in an information panel in the module or within a Custom Fields tab.

Select the Plus button next to the desired custom field.

Select the Delete link.

Select the Yes button to delete the field, or select the No button to exit without deleting.

Selecting ‘Yes’ deletes the field and all associated data for all assets using that field. This cannot be undone.