Finding Board, Table, and Column IDs

Every piece of data in a Copera Board — every table, every column, every option in a dropdown — has a unique identifier. When building with the @copera.ai/sdk, you connect your application to specific tables and columns by providing these IDs in your config.ts file. This guide explains where to find each one.

Why IDs Matter

Copera uses 24-character hexadecimal IDs to uniquely identify every resource in your workspace. When you configure the SDK, you are telling it:

• Which board to connect to — via the Board ID
• Which table within that board holds your data — via the Table ID
• Which column in that table stores each field — via the Column ID

The SDK uses these IDs to route every read and write operation to exactly the right place. If any ID is incorrect, the SDK will not be able to find your data.

tip

IDs never change, even if you rename the board, table, or column later. You only need to find and copy them once.

Finding Your Board ID

The easiest way to find the Board ID is from the browser address bar.

1. In Copera, open the Collaborate section in the sidebar.

2. Click on your Board to open it.

3. Look at the URL in your browser. It will look similar to this:

   https://app.copera.ai/workspace/boards/6978de1a2d60e272dda083a1/...

4. The Board ID is the 24-character segment that appears after /boards/. In the example above it is 6978de1a2d60e272dda083a1.

Alternatively, you can find the Board ID through the Board Settings dialog:

1. With the Board open, click the Settings icon (gear icon) in the board header, or right-click the board name in the sidebar.
2. Open Board Settings.
3. The Board ID is shown in the settings panel.

note

Every ID in Copera is exactly 24 hexadecimal characters (digits 0–9 and letters a–f). If what you copied looks shorter or longer, check that you selected the full segment.

Finding Table IDs

Each Board can contain multiple tables. The tabs at the top of the board area correspond to each table.

To find a Table ID:

1. Open your Board and click the tab for the table you need.

2. The Table ID appears in the URL immediately after the Board ID:

   https://app.copera.ai/workspace/boards/6978de1a2d60e272dda083a1/697a1f0bc3e42b8911f204d3/...

   In this example, 697a1f0bc3e42b8911f204d3 is the Table ID.

3. You can also right-click the table tab and open Table Settings to see the ID there.

tip

If your board has two tables — for example, Users and Tickets — open each table in turn, copy its ID from the URL, and label them clearly in a text file before moving on.

Finding Column IDs

Column IDs are found through the column settings panel, which opens when you click on a column header.

1. With a table open, click on the column header of the column you want to identify.
2. A context menu or settings popover will appear.
3. Click Column Settings (or the gear icon if visible in the header).
4. The column settings panel opens. The Column ID is displayed there — it is the same 24-character hexadecimal value used everywhere else in Copera.
5. Copy the Column ID and paste it into your config.ts.

Repeat this process for every column your application needs to read or write.

Finding Select Option IDs

When your application needs to filter rows by a specific dropdown or status option — for example, showing only tickets with status open, or matching a user's role to admin — you also need the Option ID for that specific value.

To find Option IDs for a Select or Status column:

1. Click the column header to open the column settings panel.
2. Look for the Options or Status Options section within the settings.
3. Each option (for example, "Open", "In Progress", "Closed") has its own ID displayed next to its label.
4. Copy the ID for the specific option your application needs to reference.

note

Option IDs are also stable — they do not change if you rename the option or reorder it. If you add new options to a column later, you will need to return to this panel to find their IDs.

Understanding Column Types

When you add Column IDs to your config.ts, it helps to know what each column type is intended for. The table below describes the column types most commonly used in custom applications built with the SDK:

Column Type	Purpose	SDK Notes
Text	Free-text fields: title, name, description, notes	Reads and writes plain strings
Select / Status	Dropdown options: status, priority, type, role	Writes an option ID; reads the selected option
Link	Relationships between tables (e.g., ticket linked to a user row)	References a row in another table by its row ID
Password	Secure credential storage; values are hashed on save	The SDK handles hashing automatically via authenticateTableRow
Number	Numeric data: price, quantity, score	Reads and writes JavaScript numbers
Date	Date fields: due date, created date, resolved date	Reads and writes ISO date strings

tip

For Select and Status columns used in filters or automations, you will need both the Column ID and the specific Option ID of the value you are matching against.

Setting Up config.ts

Once you have collected all your IDs, open src/config.ts in your project and fill them in. The file acts as the single source of truth for how your application connects to your Copera Board.

Here is a complete example for a support portal with a Users table and a Tickets table:

// apps/base-application-api/src/config.ts

export const COPERA_CONFIG = {
  boardId: "6978de1a2d60e272dda083a1",

  usersTable: {
    usersTableId: "697a1f0bc3e42b8911f204d3",
    nameColumnId: "697a1f0bc3e42b8911f204d4",
    identifierColumnId: "697a1f0bc3e42b8911f204d5",
    passwordColumnId: "697a1f0bc3e42b8911f204d6",
    roleColumnId: "697a1f0bc3e42b8911f204d7",
  },

  ticketsTable: {
    ticketsTableId: "697b3a2dc4f53c9a22e315e4",
    titleColumnId: "697b3a2dc4f53c9a22e315e5",
    detailsColumnId: "697b3a2dc4f53c9a22e315e6",
    userColumnId: "697b3a2dc4f53c9a22e315e7",
    statusColumnId: "697b3a2dc4f53c9a22e315e8",
    requestTypeColumnId: "697b3a2dc4f53c9a22e315e9",
  },
};

Replace each placeholder ID with the actual IDs you copied from your Copera Board.

tip

Keep a reference document — such as a text file or a notes app — with all your IDs labeled clearly. This makes it easy to update your config when you add new columns, and helps AI coding assistants understand your data structure when you share the file with them.

What Happens When You Add New Columns

Your Copera Board can evolve over time. If you add a new column in Copera after the initial setup:

1. Open the new column's settings panel and copy its Column ID.
2. Add the new Column ID to the relevant section of src/config.ts with a descriptive key name.
3. Update the API controller or service that handles that resource type to read or write the new column.

The SDK will automatically pick up the new column the next time it interacts with a row. No schema migrations or database changes are required — your Board handles the structure, and config.ts is the only file that needs to be updated.

Related Pages

• Getting Started — Set up the Starter Application locally with your Board configuration.
• Using AI to Build — Share your config.ts with AI coding assistants to accelerate feature development.
• Boards Overview — Learn more about how Boards, Tables, and Columns work in Copera.