Creating Custom Record and Report Types

Learn how to create custom record and report types for your community!

Custom record and reports are limited based upon your subscription version. For more information, please view our pricing page.

Sonoran CAD allows your community to create custom records and incident reports for police, fire, and EMS services. This tutorial will cover the basics of creating a new custom report or record and general usage of the system.

Video Tutorial

View our video tutorial on creating custom reports and records.

Creating a new Report or Record:

1. Navigate to the Record Editor

Navigate to Admin > Customization > Custom Records

2. Select the new Record Type

From the "New Record Type" dropdown, select the desired record type. Records follow the standard record editing and lookup system, and require a civilian or vehicle field to be searched. Reports can be searched in the unit's report center via number or identifier.

Sonoran CAD's Custom Record Types

3. Add Custom and Pre-made Sections

Add your desired custom and premade sections, edit fields, and more!

Select custom or premade sections from the dropdown buttons

If your section is a custom character or vehicle field, you can toggle on the search button. This allows the section to be filled via when creating a new one. Learn more about ensuring civilian and vehicle searches link to your custom record fields.

The enable duplicate button allows users to click and create a new copy of the section while filing the record.

Sonoran CAD: Custom Record Section Options

Field Types

Text

These fields are generic text boxes.

Select

The select field allows you to customize a dropdown box.

Text Area

The text area field allows you to create a large text area.

Checkboxes

The checkboxes type allows you to create multiple checkboxes.

Date

The date field allows you to specify a date field. You can also specify the formatting in the mask column.

When readOnly is selected, this field will auto-fill the current date for new records.

The time field allows you to specify a time field.

Image

The image field allows you to specify an image to be displayed.

Linked Records

The linked records field allows you to link and cross-reference other records and reports to this record.

Flags

Custom flag options can be added to every record template. When checked, these flags will show up as alerts on any lookup. Similar to a checkboxes section, you will need to expand the section and add options.

Label

Labels can display static text, along with color attributes.

Address

The address dropdown will auto-filter street address names that have been imported via CSV.

Unit Information

The UNIT_NUMBER, UNIT_NAME, UNIT_RANK, UNIT_AGENCY, UNIT_DEPARTMENT, UNIT_SUBDIVISION, UNIT_AGENCY_LOCATION, UNIT_AGENCY_ZIP, and UNIT_LOCATION field types will all automatically insert the unit's information when they create a new record.

Field Options

Preview

This will show the field label and value in the lookup table preview.

Supervisor

This will disable the field for all non-supervisor unit identifiers. Your unit's supervisor status can be set in the unit identifier editor.

Required

Required fields will require the unit to enter something into the field before the record can be submitted.

Unique

Unique fields enforce that no duplicate values for this field are stored in the database. These values are enforced for the specific record template only.

Unique fields can only be on non-DB Sync records and in custom sections.

Read Only

Read only fields prevent the user from entering new or modified text. This is used for auto-filled fields like unit information when a new record is created.

Note: The date and time fields will auto-fill with the current date/time if readOnly is toggled, based on the community's timezone.

Field Mask

The field mask allows you to specify a required format for the field.

• #: Number

• S: A-Z Letter

• X: Alphanumeric

Example: Numbers

Specifying ### allows the user to only enter 3 numbers in the field.

Example: Phone Number

Specifying (###) ### - #### formats the user's input into a phone number.

Field Size

The field size slider allows you to select a field size value between 1 and 12.Every row of a record has a space divisible by 12.

Dependencies

Dependencies allow you to make an individual field or entire section visible based on conditions.

Copy Parent Field ID

Expand a field and copy the unique Field Mapping ID.

Set Child Dependency

On a section or field, click the dependency button to open the editor.

Paste the unique Field Mapping ID from before. The box will light up green when a valid ID is entered.

Checkbox or Select fields as the dependency parent will allow you to select what values will display this section or field.

Text fields as the dependency parent will allow you to enter what text values will display this section or field.

Dependency Types

There are multiple options for dependency types.

• Equal

  • Dependency will display if the entered content are an exact match to the specified value(s)

• Not Equal

  • Dependency will display if the entered content is NOT equal to the specified value(s)

• Contains

  • Dependency will display if the entered content contains any of the specified values(s)

4. Save the Record

Be sure to set the record name, and press SAVE

Saving your new custom record

Using your new Record Type

In the police, dispatch, fire, or EMS page you can now add or search for the new record type.

Using your New Report

1. Accessing the Reports Center

In the police, dispatch, fire, or EMS page, select "REPORTS" in the top action menu bar From here, you can create a new report, search existing reports, and view reports requiring supervisor actions.

Sonoran CAD Reports Center

2. Creating a New Report

Select "New Report" and the desired custom report type from the dropdown button From there, you can fill out the fields and add the record.

If the "NEW REPORT" button, or actions on the report viewer are disabled, you are missing the permissions to do so.

3. Supervisor Panel

The supervisor panel shows all reports that have a blank field that requires supervisor permissions. If you do not have the supervisor panel enabled, you will need to have the supervisor permission granted on your account.

Updating Old Records with New Preview Fields

Many communities decide to enable a custom field for preview after many records of that type have already been created.

Ex: Adding a previewed field to show the license "Type"

Communities can process a manual updating of historical records in the custom records menu.

Resync Preview Fields

Resync Preview Fields - Confirm

How does the re-sync work?

Sonoran CAD will search for all records of this type and attempt to automatically update any historical records with the latest preview field preferences.

Because Sonoran CAD records are entirely customizable, changing the field UID (unique ID) from one revision to the next will result in a failure to match and update the preview field.

Database sync records do not have the option to re-sync, as they will always be up-to-date.

A re-sync is only available once per 10 minutes.

Linking Vehicle and Character Searches

Custom records allow the addition of a character and vehicle search button in sections. Clicking these allows the user to search and import a vehicle or character into the record section.

Custom Record - Vehicle and Civilian search sections

Character and vehicle searches will not fill out fields in your record if the record field UIDs are incorrect.

In order for these searches to properly place the vehicle and civilian record in your custom record fields, specific field uid values must match.

Civilian Field UIDs

The default Civilian record has the following field UIDs:

first last mi dob age sex aka zip occupation height weight skin hair eyes emergencyContact emergencyRelationship emergencyContactNumber residence

When creating your custom record section with civilian search imports, those field UIDs will also need to match. The image below shows a custom record with the civilian search section toggled with the matching field UIDs.

Vehicle Field UIDs

The default Vehicle Registration record has the following field UIDs

type plate make model color year

When creating your custom record section with vehicle search imports, those field UIDs will also need to match. The image below shows a custom record with the vehicle search section toggled with the matching field UIDs.