Skip to main content

Widget Configuration

This section covers how to configure the Worksheet widget with step-by-step visual guides.

Basic Widget Setup​

Configure the essential widget properties to enable worksheet functionality.

Basic Widget Configuration

Key Settings:

  • Widget Type: Set to "Relation"
  • Relation Direction: Choose "To" or "From"
  • Widget View: Select "Worksheet"
  • Name & Display Name: Provide clear identifiers

Visibility and Access Control​

Control who can see and access the worksheet widget.

Visibility Configuration

Configuration Options:

  • Visible to Roles: Select specific user roles
  • Everyone: Check to make visible to all users
  • Display Condition: Set conditional display rules

Relation Filters​

Configure which data to display in the worksheet based on selected relationship.

Relation Filter Configuration

Set up CSV export & Link instances functionality for worksheet data.

Export Configuration

Configuration Options:

  • CSV Export: Enable data export capability
  • Link Options (rows of the worksheet):
    • Create: Enable creation of new instances and insert new rows via context menu
    • Search: Enable linking existing instances to the worksheet

These options apply to the worksheet's rows. Reference columns have their own link options, see Reference Column Link Options.

Row Reordering​

Enable drag-and-drop reordering of worksheet rows.

Row Reordering Configuration

Reordering Settings:

  • Enable Reordering: Toggle drag-and-drop capability
  • When reordering is enabled, column filtering and column sorting are disabled in the worksheet.

Filtering Configuration​

Configure filters to pre-filter data based on lifecycle state or attribute values.

Filters Configuration

Filter Options:

  • Lifecycle State Filters: Filter records by lifecycle states
  • Attribute Filters: Filter based on specific field values
  • Data Reduction: Limit dataset before loading into worksheet

Field Configuration​

Customize which fields appear as columns and their behavior.

Fields Configuration

Field Settings:

  • Visible Fields: Choose columns to display
  • Column Order: Arrange fields logically
  • Edit Permissions: Control field-level editing
  • Column Width: Set appropriate sizing

An editable Reference column has its own Link Option in Column Settings. It controls how a value can be set in the column's cells.

Link OptionSearch in the cell dropdown"+" (create a new instance)
Both (default)YesYes
Search OnlyYesNo
Create OnlyNoYes
  • Allow link only on mobile scan (Search Only / Both): existing instances can be linked only by mobile scan. On the web, the cell dropdown does not search.
  • Create Template (Create Only / Both): the page template opened by "+". When none is selected, the related type's create templates are used.
  • A Reference cell always uses a dropdown to search; there is no search popup in the worksheet.
  • Link Options only narrow what users can do: searching still needs permission to link, and "+" still needs permission to create the related type.
  • Columns without a configured Link Option behave as Both.

Freeze Columns​

Keep key columns visible on the left while users scroll sideways.

Freeze Columns configuration

Freeze Settings:

  • Freeze from the Cards: Click the lock on a column card, or on a header group card for the whole group, in the Column Designer
  • Freeze Column: The same switch is in a column's settings, under Column Behavior
  • Up to the Column: Freezing a column freezes every column to its left too; unfreezing it unfreezes every column to its right too
  • Last Column: The last visible column can never be frozen, so the worksheet can still scroll
  • Reordering: Frozen and unfrozen columns, or frozen and unfrozen header groups, can't be swapped; drag them only among frozen or only among unfrozen ones
  • Re-added Columns: A column removed and added back later comes back unfrozen, unless it is added to a frozen group, where it is frozen with the group

For the full rules, see Freeze Columns.

Conditional Formatting​

Set field-specific formatting rules to highlight cells based on their values.

Conditional Formatting

Formatting Options:

  • Field Rules: Set conditions for individual fields
  • Color Coding: Apply background/text colors/font style based on values
  • Data-driven Styling: Highlight cells when conditions are met

Configuration Tips​

Quick Setup​

  1. Start Basic: Configure widget type and view first
  2. Add Fields: Select essential columns only
  3. Set Permissions: Configure visibility and editing rights
  4. Test Functionality: Verify configuration with sample data

Performance​

  • Limit Columns: Show only necessary fields
  • Use Filters: Pre-filter large datasets
  • Optimize Page Size: Balance performance vs. usability

User Experience​

  • Logical Order: Arrange columns by workflow
  • Clear Labels: Use descriptive column headers
  • Enable Auto-save: Prevent data loss