Explore

V2

What's new in v2?

1. ListColumns/ListTables/ListDocs - Dropdowns everywhere! 📋

This is the big one. Three new helper formulas that make the pack actually usable for non-technical folks:

=ListDocs()

=ListTables(docId)

=ListColumns(docId, tableId)

Here's how it works:

Create Select List columns, set these formulas as the Options source, and boom - users get friendly dropdowns instead of hunting for cryptic IDs.

Real workflow:

Column A: ListDocs() → user picks "Q4 Client Data"

Column B: ListTables([Column A]) → user picks "Revenue Table"

Column C: ListColumns([Column A], [Column B]) → user multi-selects "Status, Amount, Owner"

Column D: FetchCodaData([Column A], [Column B], [Column C], ...) → data appears

No typing. No memorizing grid-pqRst-U or c-f928331. Just... clicks.

This was the missing piece. Makes the pack accessible to way more people. Thanks for pushing on this @Agile_Dynamics - seeing the names question made me realize dropdowns were the real unlock here.

⁠

FetchCodaData Pack - v2 Release Notes

New Features

ListDocs(), ListTables(), ListColumns() - Helper formulas for populating Select List dropdowns. Users can now click to select docs/tables/columns instead of manually entering IDs.

Table/Column names now supported - Accept human-readable names (e.g., "Revenue", "Clients") in addition to IDs (e.g., "c-abc123", "grid-xyz"). Names are URI-encoded automatically. IDs remain recommended for stability.

ListMetadataOptions() - Granular control over metadata inclusion. Returns all available metadata field IDs for user selection via Select List columns.

Configurable relation output - Relations default to name string only. Select relationName, relationId, or relationUrl metadata fields to include specific properties.

Improvements

Smart metadata unwrapping - Single-property objects automatically unwrapped to avoid nested JSON clutter.

Enhanced CSV formatting - Metadata expands into sub-columns (e.g., Chapter_columnId, Chapter_type). Pipe-delimited arrays, proper boolean/currency handling.

Better null handling - Omits null/empty metadata fields (formula, defaultValue) from output.

Authentication Changes

Pack default authentication changed from Required to Optional

API-calling formulas explicitly require authentication

ListMetadataOptions/ListDocs/ListTables/ListColumns work without authentication

Known Limitations

Duplicate column names produce unpredictable behavior

Names break if columns/tables renamed (IDs don't)

Max 5,000 rows, 50-second timeout

Want to print your doc?
This is not the way.

Try clicking the ··· in the right corner or using a keyboard shortcut (

CtrlP

) instead.