Search, replace, and comment on data
Dataset search scans the rows currently loaded, filters the grid to matching rows, and highlights matching text inside cells. Load every row before relying on it for a whole-sheet review.
Search and navigate matches
- Press Ctrl/Cmd + F or select the search field.
- Enter at least two characters.
- Use Enter for the next match and Shift + Enter for the previous match.
- Clear the query to show every row again.
The active match receives a stronger highlight. Search understands text, numbers, booleans, colours, and Enum labels.
Use the search toggles when needed:
- Match case distinguishes uppercase and lowercase.
- Whole words only avoids partial-word matches.
- Regular expression accepts a bounded regex pattern.
- Fuzzy match finds characters in order when spellings are approximate.
Whole-word, regex, and fuzzy modes are mutually adjusted where their meanings conflict. Replace is unavailable in fuzzy mode.
Regular expressions are limited to 80 characters. Studio rejects invalid expressions and patterns with unsafe constructs rather than running them. If a regex is rejected, use a shorter literal search or simplify the expression.
Filter by column, colour, or comments
Search operators narrow the rows without changing the dataset:
column:title:dragon
rowcolor:teal
has:comments
has:open-comments
has:approved-comments
Right-click a coloured row or value to create the relevant filter without typing it. The search suggestions also show available colour and comment filters. Clear search before a sheet-wide review or if a row appears to be missing.
Replace values
- Search for the exact content first.
- Narrow the search with
column:when possible. - Turn on case or whole-word matching if partial replacements would be unsafe.
- Open the replace row with Ctrl/Cmd + H.
- Replace the current match, or review the confirmation before Replace all.
Replace works only after all dataset rows are loaded. It changes searchable scalar values, not comments. Use undo immediately if the result is wrong.
Comment on a cell
Right-click a cell (or press Shift + F10 on it) and choose Comment on cell. A comment stays attached to that row and column, so it is useful for a wording question, art direction, or a decision about one value.
In the comment panel you can:
- Add another comment to the thread.
- Edit or delete your own comment when permitted.
- Approve or unapprove a comment when permitted.
- See counts for open and approved comments.
Approval marks the comment complete; it does not change the cell. Use has:open-comments to collect unresolved work and has:approved-comments to review completed decisions. Dataset comments do not appear on the Designer canvas or in exports.