Mastering Appian Record Lists and User Filters

After setting up your data model, the next crucial step is determining how users will navigate and view that data. Let's return to our fictional company, Acme Auto, to explore how we can customize the default record list and apply user filters to make finding vehicles a breeze!

Configuring the Record List Grid The record list is the default grid that appears in sites and serves as the foundation for read-only grids. For Acme Auto, keeping the list style as a "Grid" is ideal since employees need to view data across multiple vehicle records simultaneously.

To customize this view, simply navigate to the List page and click "EDIT LIST". This opens a dialog that allows you to configure the grid, columns, and components while previewing the list on the right. From here, you can easily remove unwanted columns, rearrange them into a logical order for easy scanning, and update column labels for better formatting. You can even change how often the list automatically refreshes its data. If you ever make a mistake while updating your list, don't worry—you can simply click "RESET LIST" to restore the default configuration.

Enhancing Columns: Record Links and Images By default, Appian might place a record link on a column like the vehicle's "Year," but you might want to move it to a more intuitive field, such as the vehicle's VIN. To do this, you can clear the old link and go to the Display Options for the VIN column to configure a new record link using an expression.

This expression relies on a few key parameters and function variables:

• Label: Using fv!row, you can set the display data for each row to pull the specific vehicle's VIN field reference.
• RecordType: You must tell the grid exactly which record type the linked summary view belongs to.
• Identifier: By setting this parameter to fv!identifier, you ensure the grid uses the primary key of the row, so when a business user clicks the link, they are taken to that exact vehicle's summary view rather than a different one.

You can also upgrade your list visually. If your database stores vehicle images as document IDs, you can change the column's Display Option to "DOCUMENT IMAGE". By updating the expression to reference the image field using fv!row and setting the size to SMALL, users will see an actual picture of the vehicle instead of a meaningless ID number.

Empowering Users with Filters Finally, to help your users sort through the vehicles more easily, you should add User Filters. From the Filters page, you can choose between a guided configuration or entering an expression.

• Guided Configuration: This is perfect for standard filters, like filtering by vehicle Status (e.g., finding vehicles that are active, inactive, or in maintenance). By utilizing relationships to a lookup record type, you can ensure users see the actual text for the statuses instead of confusing status ID numbers.
• Expression Configuration: For more dynamic filtering, an expression can query the record type directly. For example, you can create a filter for vehicle "Makes" that queries the vehicle data and automatically generates a list of options based on the unique makes currently existing in your dataset.

By customizing your record lists and adding intuitive filters, you transform a simple data table into a highly navigable and user-friendly interface!