Doc explorer: adding column data to table list

The Doc explorer pack allows you to create sync tables showing all tables in a given doc. However, a standard "table" sync table does not contain information about what columns exist in the tables. This tip walks you through how to use the pack to go a step further and add information about what columns exist in each of those tables, including information about what each column is, formulas in each, and other column statistics.

Step 1: Install the doc explorer pack.

Watch the full instructional video, made by the pack maker himself, Scott Weir, here.

Step 2: Add “Doc tables” and “All column data” sync tables.

Check out this tip for instructions on adding the “Doc tables” sync table. You can apply the same instructions to insert the “All columns data” table.

Step 3: Connect the tables with a relation.

Add a column to the “doc tables” sync table. Name it “Columns”. Then, add the following calculation:

Was this helpful?

YesNo