Quick edit columns allows you to mark specific columns to be editable directly from the detail view. For example, quick edit is ideal for updating the Status field of a record without editing the full record.
The following columns cannot be set as quick edit columns:
- Key columns
- Read-only columns
- Columns computed by an AppFormula or sheet formula
- System columns like row number
Change
type columns- Columns with
Editable_If
expressions that disallow edits.
Other notes about quick edit columns:
- Changes to quick edit columns can cause other column values to change through formula dependencies.
-
Valid_If
andRequired_If
conditions will be applied. Changes that violate either theValid_If
orRequired_If
conditions will be rejected. - Each edit is a separate row update, so quick edit is best used together with the Delayed Sync option. You can set Delayed Sync when configuring offline and sync.
Add quick edit columns as described in the following sections:
Get started with an app template
The Quote Generator app template demonstrates a quick edit column.
When configuring the Customer Quotes_Detail view, the 10%Deposit Paid column is added to the Quick edit columns list.
When using the app, the value is editable in the detail view.
Add quick edit columns
To add quick edit columns:
- Open the app in the editor.
- Go to App > Views.
We've made some improvements to the app editor.
You are opted in to the new editor by default, but you can switch back to the legacy editor at any time.If you are using the legacy editor
Go to UX > Views. - Create a detail view for the table or slice you wish to configure as quick edit. The table or slice must allow edits.
- Expand the newly added view.
- Add one or more Quick edit columns.
- Set the view position to ref if you do not want to add a button for this new detail view.