Sets
Summarize
Summary of Sets
Sets in ServiceNow CPQ provide a reusable and repeatable collection of fields designed to organize complex, repeatable configuration data such as multiple products or components. Each row in a set represents an independent instance of these grouped fields, enabling simplified configuration, reduced duplication, and support for tabular or list-based inputs. Sets enhance the end-user experience by presenting configuration options in intuitive, editable table-like layouts.
Show less
Key Features
- Simplified Repeatable Configurations: Define groups of fields once and reuse them multiple times instead of creating individual fields and rules for each repetition.
- Intuitive Tabular Data Entry: End users can add, remove, or edit multiple configuration items easily in a structured grid or list format.
- Dynamic Rule Support: Rules can reference values within the same row or aggregate data across all rows to control configuration logic.
- Advanced Reporting and Summaries: Aggregate functions like sum, count, average, maximum, or minimum provide summarized insights across all rows.
- Display Options: Sets can be rendered as tables (for detailed comparisons), lists (card-style selections), or repeaters (single record views) to suit different user interface needs.
- Field Relationship Constraints: Fields within the same row interact, but cross-row direct interactions are not allowed; external fields can influence set fields, while changes outside sets are managed via aggregates and product rules.
- Configurable Properties: Administrators can customize general layout settings, display type, inline controls, row-sizing methods, selection modes, search capabilities, and message displays in the UI.
- Data Management via CSV: Sets support importing and exporting data through CSV files, enabling bulk updates and downloads of visible columns with automatic rule execution on upload.
- Scripting Integration: Sets and aggregates can be accessed in business rules and scripts using specific syntax, allowing for advanced logic such as conditionally setting fields based on aggregate totals.
Practical Benefits for ServiceNow Customers
- Efficiently manage complex configurations involving multiple repeated items without redundant field creation.
- Enhance the end-user configuration experience with clear, editable, and structured interfaces.
- Leverage dynamic rules and aggregates for sophisticated validations, calculations, and conditional logic across multiple configuration instances.
- Facilitate data import/export workflows to streamline bulk data management and integration.
- Customize set displays and behaviors to align with specific business processes and UI requirements.
Learn how sets organize repeatable field groups, simplify complex configurations, and enable data aggregation across repeated elements in ServiceNow CPQ.
A set is a reusable, repeatable collection of fields that lets administrators define multiple instances of similar configuration data—such as multiple products, components, or options—in a single blueprint.
Each row in a set represents one instance of a repeated group of fields, and each field in that row behaves independently. sets streamline configuration design, reduce duplication, and support advanced use cases that require tabular or list-based inputs.
Administrators use sets to present configuration options in structured, table-like layouts that customers can easily edit in the end-user interface.
- Simplify repeatable configurations. Instead of creating multiple fields and rules for each repetition, define once and reuse many times.
- Provide intuitive, tabular data entry. End users can add, remove, or edit multiple product instances in a structured grid.
- Support dynamic rules. Rules can reference values in the same row or aggregate data across all rows.
- Enable advanced reporting and summaries. Aggregates summarize field values across rows (for example, total quantity or total rack units).
How sets work
A set groups several configuration fields together and repeats that group for each item in the list.
- Fields in the same row can affect other fields in that row.
- Fields in one row cannot directly affect fields in another row.
- Fields outside a set can influence fields inside it, but not vice versa.
To affect fields outside a set, use:
- Aggregates: Sum, count, average, maximum, or minimum values across all rows.
- Product rules: Define logic that sets external field values based on set data.
A set can contain up to 2,000 rows.
Display options
Sets can appear in the UI in several formats, depending on user experience requirements:
| Display type | Description | Example use case |
|---|---|---|
| Table | Rows, columns, and cells with headers; ideal for detailed comparisons. | Configure multiple network devices. |
| List | Each row shown as a card; can support single-select or multi-select. | Select delivery slots or service packages. |
| Repeater | Displays one record at a time with navigation controls. | Edit configurations one-by-one in smaller layouts. |
Administrators control layout, alignment, and scrolling in the layout editor.
Field relationships
| Relationship | Behavior |
|---|---|
| Inside → Inside | Fields in the same row can trigger each other through rules. |
| Inside → Outside | Not allowed directly; use Aggregates or Product Rules. |
| Outside → Inside | Allowed. Rules or field actions outside a set can change set field values. |
Key properties
Sets include several configuration categories that shape how users interact with the table or list:
- General settings: Orientation, maximum height, alignment, index labels.
- Display type: Choose between Table and List views.
- Inline settings: Show “Add Row” indicators, drop-down controls, or hover actions.
- Size settings: Manage how users increase or decrease set rows (numeric or slider field).
- Selection settings: Add single or multiple row selection with a Boolean selection field.
- Search settings: Allow users to search values in a set (for example, filter by available date).
- Message settings: Display validation messages or indicators in specific cells.
Managing set data
Sets support importing and exporting data in CSV format.
- Download set data: Exports only visible columns based on filters applied in the UI.
- Upload set data: Adds or updates rows in the set using a structured CSV file.
- Rules run automatically on upload.
- New rows are appended; matching rows are updated.
- System-enforced limits apply (25 visible columns recommended).
{
"uploadDetails": {
"uploadButton": { "label": "Upload CSV", "visible": true },
"downloadButton": { "label": "Download CSV", "visible": true }
}
}
Scripting with sets
To reference sets in rules or scripts, use the following syntax:
| Use case | Example syntax |
|---|---|
| Access the set | set.<setVarName> |
| Access an aggregate field | set.<setVarName>.<aggregateVarName> |
if (set.networkDevices.totalRackUnits > 50) {
field.requiresAdditionalCooling = true;
}