User Data Variables
User Data Variables describe how variables display and behave within the User Data grid. This page explains how different variable types render, how editing works, and how to customize the view.
Overview
When viewing User Data for a group session, variables appear as columns in a spreadsheet-like grid. Each variable type has specific display and editing behaviors.
Variable Display by Type
Text Variables
| Aspect | Behavior |
|---|---|
| Display | Plain text, truncated if too long |
| Editor | Text input field |
| Sorting | Alphabetical (A-Z, Z-A) |
Number Variables
| Aspect | Behavior |
|---|---|
| Display | Numeric value |
| Editor | Number input (supports decimals) |
| Sorting | Numeric (low to high, high to low) |
Boolean Variables
| Aspect | Behavior |
|---|---|
| Display | "Yes" or "No" text |
| Editor | Dropdown with Yes/No options |
| Sorting | Groups by Yes/No |
Datetime Variables
| Aspect | Behavior |
|---|---|
| Display | Formatted date and time |
| Editor | Date/time picker |
| Sorting | Chronological |
Enum Variables
| Aspect | Behavior |
|---|---|
| Display | Selected option text |
| Editor | Dropdown with predefined options |
| Sorting | By option value |
Grid Features
Column Headers
Each variable displays as a column with:
- Variable name as header
- Sort controls (click header to sort)
- Filter input below header
Cell Editing
Inline Editing:
- Click any editable cell
- The appropriate editor appears based on variable type
- Make your change
- Press Enter or click away to save
Modal Editing:
- Click the Edit button for a row
- All editable fields appear in a form
- Make changes to multiple fields
- Click Save to apply all changes
Read-Only Cells
Cells appear read-only when:
- The variable is marked as non-editable in the schema
- The session is closed
- The user lacks edit permissions
Variable Panel
The Variable Panel controls which variables are visible in the grid:
Showing/Hiding Variables
- Expand the Variable Panel section
- Each variable has a checkbox
- Check to show, uncheck to hide
- Changes apply immediately
Use Cases for Hiding Variables
- Focus on specific data - Hide irrelevant fields temporarily
- Reduce clutter - Show only what you need to see
- Export preparation - Show only fields you want to export
Mandatory vs Optional Variables
Mandatory Variables (Always Visible)
These typically include:
- First Name
- Last Name
Mandatory variables:
- Cannot be hidden from the grid
- Must have values for every user
- Appear first in the column order
Optional Variables
Custom variables you've defined:
- Can be shown or hidden as needed
- May have empty values
- Appear after mandatory variables
Data Validation
When editing values, the system validates:
| Type | Validation |
|---|---|
| Text | No validation (any text allowed) |
| Number | Must be a valid number |
| Boolean | Must select Yes or No |
| Datetime | Must be a valid date/time |
| Enum | Must select from defined options |
Invalid entries show an error message and are not saved.
Sorting and Filtering
Sorting
Click a column header to sort:
- First click: Ascending (A-Z, low to high, oldest first)
- Second click: Descending (Z-A, high to low, newest first)
- Third click: Remove sort
Filtering
Use the filter row below headers:
- Type text to filter that column
- Filters are case-insensitive
- Multiple column filters work together (AND logic)
Best Practices
Use the Variable Panel - Hide columns you don't need to reduce visual clutter
Sort by relevant fields - Sort by status or date to find records quickly
Filter before bulk actions - Use filters to isolate the records you need
Check after edits - Verify changes saved correctly
Export filtered views - Filters affect what gets exported
Questions?
If you have any questions, please don't hesitate to contact us. Alternatively, you can submit an issue on this platform.
Useful Links:
User Data - https://help.acenji.com/#/./shared-concepts/variable-center/user-data/index Global Variables - https://help.acenji.com/#/./shared-concepts/variable-center/settings/global-variables/index Group Session Variables - https://help.acenji.com/#/./shared-concepts/variable-center/settings/group-session/group-session-variables/index