Custom Form Fields

The following fields are found on the Custom Form page.

NOTE: Some fields have visible character max limits. The first number is the current count of how many characters have been used. The second number is the max characters allowed in the field.

  • Table Name: File name used to identify the table in the Cityworks database.
  • Table Description: A brief definition of what the table contains or what its purpose is.
  • Column Name: The name used to identify a specific field created by the user. This identifier is used to locate the field data in the Cityworks database.
  • Data Type: Select to define the kind of information contained in the custom field. There are four data types:
    • Character: Select to allow the field to accept alphanumeric characters.
    • Integer: Select to allow the field to accept integer numeric values (both positive and negative values limited to whole numbers). Requires the TextBox input type.
    • Decimal: Select to allow the field to accept numeric values including integers and rational numbers (fractions in the form of decimals). Requires the TextBox input type.
    • Date: Select to allow the field to accept date values.
  • Input Type: Select the method by which users enter values into the field. There are eight input types:
    • TextBox: Used for fields where users enter a free-form value with their keyboard. Required for fields using the Integer and Decimal data types.
    • CheckBox: Used for fields that present predefined options in the form of check boxes.
    • DropDown: Used for fields that present predefined options in a drop-down format.
    • MultiLine: Used for fields that allow users to enter values in more than one line.
    • MultiSelect: Used for fields that allow users to select more than one predefined option.
    • Password: Used for fields that require the user to enter a specific sequence of characters or numerals.
    • RadioButton: Used for fields that present predefined options in the form of a number of option buttons.
    • Date: Used for fields that allow the user to enter or select a date value.
  • Length: Enter the maximum number of characters users can enter into the field.
  • Scale: Enter the number of significant figures allowed after the decimal if the field has the Integer data type.
  • Display Label: Enter the name of the field. This is the name users see on the case template.
  • List Item (Separated by commas): Used to define specific values available for users to select. Required for fields using the DropDown, MultiSelect, and RadioButton input types.
  • Default Text: Used to define specific values available for users to select. Required for fields using the TextBox, MultiLine, and Password input types.
  • Required: Used to make sure the user enters a value in the custom field before they can move on. This is useful for custom fields that capture critical information. For example, if the field is meant to capture a value that is used elsewhere to calculate fees, selecting this check box forces users to enter a value before they can move on.
  • Additional Template Items
  • Flag: Use this drop-down list to select the desired flags.
  • Conditions: Use this drop-down list to select the desired conditions.
  • Violations: Use this drop-down list to select the desired violations.
  • Fees & Deposit
  • Payment Type: Use this drop-down list to select the desired payment types.
  • Fees: Use this drop-down list to select the desired fees.
  • Deposit: Use this drop-down list to select the desired deposit.
  • People & Contractors
  • People Role: Use this drop-down list to select the desired roles.
  • Contractor: Use this drop-down list to select the desired contractors.
  • General Comments: Use this drop-down list to select the desired comments.
  • Template Setup
  • Case Template: Use this drop-down list to select the desired case templates.
  • Instrument Type: Use this drop-down list to select the desired instrument types.
  • Task: Use this drop-down list to select the desired tasks.
  • Case Type: Use this drop-down list to select the desired case types.