Columns & Fields

The Objects & Columns step is where you choose what data the grid shows: the primary object, the fields to display, and any per-column formatting.

Objects & Columns section

Choose the primary object

  1. In Primary Object, search for the object you want to show (standard or custom, for example Contact, Account, Opportunity, or your own My_Object__c).
  2. Select it.

You can only pick one primary object per grid. Related-object fields are added later as columns, not as a separate primary object.

Add fields as columns

Once the primary object is selected:

  1. Type a field name in the field search box, or browse the list.
  2. Click a field to add it to Selected Fields on the right.
  3. Drag selected fields up and down to change the column order in the grid.
  4. Click the X on a selected field to remove it.

Add related fields (up to 5 levels deep)

You can pull fields from parent records through lookup relationships — up to five levels of traversal.

  1. Click Add Related Field.
  2. Select the lookup to follow (for example, on Contact, select Account).
  3. Pick a field on the related object (for example, Name).
  4. Or continue traversing further — Contact → Account → Owner → Manager → Name is valid.
  5. The resulting column uses the full path as its identifier and an auto-generated label you can change.

Use related fields to avoid building custom formula fields just to display parent context.

Edit a column (field overrides)

Click the pencil (edit) icon on a selected field to open the Field Editor modal. Here you can:

Rename the column

Set a user-friendly Label (for example, rename Account.Owner.Name to Account Owner).

Override the column type

By default each column renders using the underlying Salesforce field type. Override Type lets you display the value differently without changing the data model:

Override Use when
Mini Chart You have a numeric value and want an inline bar or sparkline.
Progress Bar You want to visualize 0–100% completion.
Picklist You have a free-text field that should be constrained to a list while editing.
URL You want the cell to render as a clickable link.
Icon You want to render the value as a specific Lightning Design System icon.

Overrides are most reliable when the underlying data matches the target type (for example, numeric data for Mini Chart). Complex overrides on formulas may have limited editing support.

Add conditional highlighting rules

Conditional highlighting lets you color a cell — or the whole row — based on the record's values.

  1. In the Field Editor, open Conditional Highlighting Rules.
  2. Click Add Rule.
  3. Pick a field, operator, and value (for example, Amount > 50000).
  4. Choose a color/style for the cell (for example, green background).
  5. Save.

Rules evaluate against each row at render time. Multiple rules are evaluated in order.

Field Editor with Override and Highlighting

Which fields are editable?

A field in the grid is editable inline when:

  • Inline Edit Mode is enabled for the grid (see Grid Details).
  • The user has Field-Level Security edit access to the field.
  • The underlying field is not read-only (formula, rollup, system-managed).
  • The override type supports editing (for example, Mini Chart displays a value but is not directly editable).

Fields that cannot be edited will appear read-only even in Edit Mode.

Recommendations

  • Show the fewest columns users actually need. You can add more later via Column Settings at the user level.
  • Prefer related fields over custom formulas for showing parent context — it keeps the data model clean.
  • Use conditional highlighting sparingly; a few rules per grid is more useful than dozens.
  • Rename related-field labels to something human-readable (for example, Account Owner instead of Account.Owner.Name).
Phone

Office: +1 725 333 6699

Email

Office: admin@appcolab.com

Site: https://appcolab.com

Social
©2024 AppColab LLC · All rights reserved.