Database normalization enforces data integrity by structuring data and relationships to prevent anomalies.
It minimizes data redundancy by ensuring each piece of information is stored only once, reducing duplication.

Create new users upon sign in - provisions new Appian users automatically when they first authenticate through SAML.
Reactivate deactivated users upon sign in - automatically re-enables an Appian account if the user returns after being deactivated.
Update user attributes upon sign in - refreshes profile details (e.g., name, email, custom attributes) each time the user signs in.

A real-time custom field in the Customer record type can aggregate and count related open cases.
A sync-time custom record field using a!relatedRecordData() can filter and count open cases, making the count available as a synced field.

Passing local!query.totalCount (from a dataSubset with returnTotalCount: true) into a rule input allows rule!
pagingComponent() to accurately display total items for pagination.
Managing paging state (such as ri!pagingInfo) as a local variable in the main interface and updating it when arrows are clicked ensures that pagination is controlled centrally, maintaining state across the UI and allowing the component to function as intended.

Enabling activity-chaining between all nodes on the main process model ensures the wizard steps flow seamlessly for the user.
Using a subprocess to call the second process model allows the main process to incorporate its user input task as part of the wizard flow with activity-chaining support.