Loading Tables from Boards via Board-ID

Insert tables from any board into your document by loading them via the Board-ID

In addition to loading items from the current board, you can also pull data directly from other boards by using their Board ID.

This is especially useful if you want to combine information in tabular format from multiple boards or reference board data that is stored elsewhere.

Using the Board ID in Table Placeholders

All item data in tables is wrapped using these placeholders:

{{TableStart:Items}}
   Your placeholders like {{Column Title}}
{{TableEnd:Items}}

Now, if you want to load data in tabular format from a different board, you need to wrap the whole table between those two placeholders:

{{TableStart:Board[123456789].Groups}}
{{TableStart:Items}}
   Your placeholders like {{Column Title}}
{{TableEnd:Items}}
{{TableEnd:Board[123456789].Groups}}

The number inside the brackets—123456789 in this example—is the Board ID of the board you want to output.

Full examples

Download Microsoft Word template with example snippets:

15KB

TESTLoadBoardIDs.docx

Open

All Items from Board ID 123456789 grouped:

{{TableStart:Board[123456789].Groups}} {{Name | GroupColor}} -> Name of Group incl. Group Color {{TableStart:Items}}

Item Name: {{Name}} Date: {{Due Date}}

{{TableEnd:Items}} {{TableEnd:Board[123456789].Groups}}

All Items from Board ID 123456789 group by a status column (Column Title) If you want to group by another column, replace “GroupByStatus” with “GroupByColumnTitle”

{{TableStart:Board[123456789].GroupByStatus}} {{Name | GroupColor}} -> Name of Group incl. Group Color {{TableStart:Items}}

Item Name: {{Name}} Date: {{Due Date}}

{{TableEnd:Items}} {{TableEnd:Board[123456789].GroupByStatus}}

All Items from Board ID 123456789 grouped and filtered

{{TableStart:Board[123456789].Groups(Filtercondition)}} {{Name | GroupColor}} -> Name of Group incl. Group Color {{TableStart:Items}}

Item Name: {{Name}} Date: {{Due Date}}

{{TableEnd:Items}} {{TableEnd:Board[123456789].Groups(Filtercondition)}}

Link to article: Advanced Filtering

Where to Find the Board ID

You can find the Board ID in multiple places, for example:

• In the URL of your board

• In the board details menu, where the ID is also displayed

Using Filters and Groups with Board ID Tables

Board-ID-based placeholders fully support the use of filters as well as grouping. This means you can apply the same filter conditions even when loading tables from another board.

To use filters and groups, extend your placeholder like this:

{{TableStart:Board[123456789].Groups(FilterCondition)}}

or

{{TableStart:Board[123456789].Items(FilterCondition)}}

Make sure to close the table with the matching placeholder:

{{TableEnd:Board[123456789].Groups(FilterCondition)}}

or

{{TableEnd:Board[123456789].Items(Condition)}}

This is an example of what the structure (including groups) could look like:

Download Microsoft Word template with example snippets:

15KB

TESTLoadBoardIDs.docx

Open