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.

What are custom records and reports?

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.

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 Type
Field Options
Field Mask
Field Size
Field Type

Fields can be a set to text, select, textarea, date, time, label, address or checkboxes.

1. Text:

These fields are generic text boxes.

2. Select:

The select field allows you to customize a dropdown box.

The 'SELECT' field option
A 'SELECT' field shown in the record editor

3. TextArea:

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

The 'TEXTAREA' field option
A 'TEXTAREA' field shown in the record editor

4. Checkboxes

The checkboxes type allows you to create multiple checkboxes, similar to the premade flags section.

The 'CHECKBOXES' field option
A 'CHECKBOXES' field shown in the record editor.

5. Date

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

The 'DATE' field option
The 'DATE' field shown in the record editor

6. Time

The time field allows you to specify a time field.

The 'TIME' field option
The 'TIME' field shown in the record editor

7. Image

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

The 'IMAGE' field option.
The 'IMAGE' field shown in the record editor

8. Linked Records

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

Sonoran CAD - Linked Records

9. 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.

Sonoran CAD - Custom Flags

10. Label

Labels can display static text, along with color attributes.

Sonoran CAD - Custom Record Label

11. Address

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

Sonoran CAD - Custom Record Address Field
Field Options

1. Preview:

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

Input field with PREVIEW toggled
Previewed field shown in a lookup table

2. 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.

Input field with SUPERVISOR toggled
Supervisor field highlighted red

3. Required

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

Input field with REQUIRED toggled
Required field shown in the record editor

4. 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.

Sonoran CAD - Unique Field
Sonoran CAD - Unique Field Error
Field Mask

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






Letter A-Z



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.

Record fields with sizes 3, 3, and 8
Record editor with custom field sizes

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.