Free cookie consent management tool by TermsFeed

About Record Types

This page describes the record type object. If you're already familiar with the record type, learn how to create a record type in your application.

What are record types?

A record type is a design object that allows you to structure and model your enterprise data so you can easily build data-centric applications.

Each record type represents a major business concept or process in your organization. For example, in an order fulfillment organization, you could have record types for Products, Inventory, Order Submissions, and Customers since these are primary concepts and activities involved in the organization.

You can have as many record types as you need to represent your data model. In our order fulfillment example, this means that you could have numerous record types, as illustrated in the image below.

Once you've configured your record types, you can use them to reference data throughout your applications—in interfaces, expressions, process models, and more.

Synced and unsynced record types

When you create a record type, you can choose whether or not to enable data sync on the record type. Record types with data sync enabled are called synced record types, while record types without data sync enabled are called unsynced record types.

Based on your application requirements, you may use a combination of synced and unsynced record types to build your application.

For example, let's say the Appian Retail company needs to create an application to track and manage orders. This company has over 7 million rows of order data. To build their application, the Appian Retail company could create synced and unsynced record types to manage order data and use throughout the application.

The sections below provide examples of where you could use these record types in your applications.

Example: Active orders record type

The core requirement of the Appian Retail application is to allow employees to process orders. This includes tasks like verifying customer details and product availability, processing payments, and sending order confirmations.

Since these tasks only apply to active orders, you could create a synced record type called Active Orders and only sync orders that are currently in progress. Then, you can use this record type to build review forms, process models to process payments and send confirmations, and build a report that allows employees to monitor the status of their active orders.

Since the record type has data sync enabled, you can also leverage features like record-level security to easily ensure that employees can only see orders they're assigned to, and add relationships to other record types so you can display related data (like customers associated with each order).

Example: Closed orders record type

Another application requirement is to allow managers to review how many orders their direct reports completed each month, so they can assess employee performance at the end of the year.

Since this task only applies to closed orders, you could create a synced record type called Closed Orders and only sync orders that are complete within the last year. Then, you could use this record type to build a company-wide report on orders completed by month and share with all managers.

Since this record type has data sync enabled, you can also show this record type in data fabric insights so managers can build their own custom reports that focus on their specific employees.

Example: Orders record type

In addition to managing and monitoring recent orders, the company also wants to analyze how overall order trends have changed over the years.

Since this task relies on orders from the last few years, you could create an unsynced record type called Orders that displays all 7 million rows of data. Then, you could use this record type to create a report on order trends for the last five years.

Since you're querying a large volume of source data, you may need to create additional indexes, views, caches, or other tuning to optimize query performance in the source system. By syncing subsets of the data in the Active Orders and Closed Orders record types, you can take advantage of automatic performance tuning and sync-enabled features in targeted areas of your application.

Example: Dashboard using all record types

One of the final application requirements is to provide executives with a comprehensive overview of the company's sales and order performance over different time periods. Using all of the record types above, you could create a dashboard that displays an analysis of orders from the last five years, year-to-date order sales, key performance indicators (KPIs) of new orders, and even a breakdown of orders by customer.

Elements of a record type

Each record type contains the following elements:

Element Description
Record data The data available in the record type, including your source data and any custom record fields. This data can be unified, filtered, secured, and referenced using the record type object.
Records Each row of data in the record type. For example, in a Customer record type, a single record would be John Smith.
Record views One or more interfaces that displays information about a single record. You can use a combination of interface components and data to create a comprehensive view of the record. By default, each record has a summary view.
Record list A single, drillable list that users can search and filter to find records.
Record actions Links to process models that a user can start directly from a record or from the record list. This allows users to create, update, or delete data while viewing the data.

Feedback