🧐How To: Reference Data Records from Cases
How to link a data record to a case
Last updated
How to link a data record to a case
Last updated
A Case record in Cubu can reference data records in custom data tables. This is useful when allowing agents to select a value from an extensive list of options.
This article will guide you through the process of making the necessary configuration to allow agents to select data records for their cases easily.
Use the Text field with options for selecting from a list. Use Data Record Fields for long lists, items with additional data, or frequently changing data.
Referencing a data record from a case is done using a Data Record Field. These fields are linked to a specific data table and allow the agent to search for records.
The following diagram depicts a Case with a Data Record Filed referencing a data record:
Create a data table using the Data Tables tool.
For details, see: Managing Data Tables
For this demo, we've created the Courses table. This table contains data about courses provided in Evergreen College.
The following screenshot depicts the Courses data table and its fields:
The data table contains course information, as shown in the following screenshot:
Go to Admin Tools / Metadata / Fields and click New Field to open the New Field dialog.
Give the field a unique name and slug.
From the Data Type dropdown, choose Data Record.
From the Data Table dropdown, choose the table you have created.
In this step, we add the Data Record Field to a Service Category, so cases created in this category will contain the field.
In this example, we've added the Major field to the Course Registration service category.
For more information, see: Managing Service Categories
When you create a case in the Course Registration field, the Major field will appear on the case form:
To choose a data record, click on the Find (🔍) button to open the Find dialog:
The data record is now visible on the case record:
