The Scenario
The product ops lead is building a reporting template. The template needs a reference table — every status value currently in use across the 'Projects/Project' database — so she can drive a dropdown validation on the summary sheet and ensure the ops team enters consistent values. She knows the statuses exist in Fibery. She doesn't know all of them off the top of her head, because someone added a "Needs Review" state three sprints ago and she's not sure if it's still active or if there are variations in capitalization across entities.
The handoff from the last quarterly review left her with a reference table that's six months out of date. She needs the current ground truth.
The bad version:
- Open Fibery. Navigate to the 'Projects/Project' database. Sort by status. Scroll through the list manually. Write down each unique value as you encounter it. Hope you didn't miss any.
- Realize the list view only shows the status of visible entities — you'd need to load all pages to be sure. Fibery paginates. You load the next page. And the next.
- Find "Needs Review," "Needs review," and "needs review" as three separate entries on different entities. Decide which one is canonical. Go back and manually note the inconsistency. The reference table you're building now needs a note column.
She didn't set aside a morning for this. It was supposed to be a twenty-minute task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through its built-in Fibery integration, it can query a specific field across all entities in a database, deduplicate the values, and write the result into your sheet as a clean reference list — no pagination, no manual scrolling.
Fetch all distinct values for the 'status' field across all entities in my Fibery 'Projects/Project' type and write them into column A starting at row 2, with 'Status' as the header in row 1
What You Get
- One row per unique status value found across all project entities.
- Case-preserved exactly as stored in Fibery — so if there are capitalization variants, they show up as separate rows and you can see the inconsistency.
- The list reflects current live data, not a cached export.
What If the Data Is Not Quite Ready
You want distinct values for two fields — status and priority — side by side
Fetch all distinct values for the 'status' field in my Fibery 'Projects/Project' type and write them into column A — also fetch all distinct 'priority' values and write them into column B — headers in row 1
You want to normalize the list before writing it to the sheet
Fetch all distinct values for the 'status' field in my Fibery 'Projects/Project' type — normalize to title case — deduplicate after normalization — and write the cleaned list into column A
You need distinct values from two different entity types
Fetch all distinct status values from my Fibery 'Projects/Project' type and write them into column A — then fetch all distinct status values from 'Engineering/Task' and write them into column B — headers in row 1
Full reference table with counts in one shot
Fetch all distinct values for the 'status' field in my Fibery 'Projects/Project' type — write each value into column A and the count of entities with that status into column B — sort by count descending — write 'Status' and 'Count' as headers in row 1
One prompt. The reference table arrives with the frequency data already there so you can see which statuses are actually in use versus which ones exist but are empty.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you're using to build a reporting template or dropdown validator, then ask it to pull the current distinct values from any Fibery field. For related tasks, see how to export your full Fibery workspace schema as a data dictionary or export entity records to a sheet for analysis.