Skip to main content

Advanced Fields

Advanced fields cover specialized use cases that go beyond basic data entry. From currency formatting and file attachments to team voting and automatic translation, these field types add powerful capabilities to your boards.

Money​

The Money field stores numeric values and displays them with currency formatting. It supports multiple currencies and follows the same number formatting options as the Number field.

  • Value type: Number
  • Default behavior: Accepts numeric input and displays the value with the selected currency symbol.
  • Typical uses: Prices, budgets, revenue, costs, invoices, payments.

Supported Currencies​

CurrencySymbolCode
Brazilian RealR$BRL
US Dollar$USD
EuroEEUR
British PoundLGBP
Japanese YenYJPY
BitcoinBBTC
EthereumEETH

You select the currency when configuring the column. The currency symbol is displayed as a prefix on every cell value. All standard number formatting options --- decimal places, thousands separators, and abbreviations --- are also available for Money fields.

File​

The File field lets you attach one or more files to a row. Each attached file stores its name, MIME type, and size.

  • Value type: Array of file objects
  • Default behavior: Click to upload or drag and drop files into the cell.
  • Typical uses: Attachments, documents, images, receipts, contracts, design assets.

Key Behaviors​

  • Multiple files --- A single File cell can hold several attachments.
  • File information --- Each attachment displays its file name. Hover or click to see additional metadata.
  • Preview --- Supported file types (images, PDFs) can be previewed directly.
  • Download --- Click on an attached file to download it.
  • Cell display --- The cell shows the count of attached files when collapsed.

The Link Button field adds a clickable button to each row that opens a pre-configured linked row form. This is useful when you want users to quickly create or view related records in a linked table without navigating away from the current board.

  • Value type: Boolean (button)
  • Default behavior: Renders a button in the cell. Clicking it opens the linked row form.
  • Typical uses: "Add subtask" buttons, "Create invoice" shortcuts, quick-entry forms for related data.

Configuration​

When setting up a Link Button column, you configure:

  1. Label --- The text displayed on the button.
  2. Linked table --- The target table where the new row will be created.
  3. Link column --- The Linking column used to establish the relationship.
  4. Form fields --- Choose which fields from the target table appear in the form, set visibility, mark required fields, and define default values.

This field type is read-only in the sense that users interact with it only through the button. It cannot be sorted or grouped like other fields.

Password​

The Password field stores text that is masked by default, hiding the value behind dots or asterisks.

  • Value type: String
  • Default behavior: Text input where the stored value is hidden from view.
  • Typical uses: API keys, access codes, license keys, sensitive identifiers.

The Password field does not provide encryption --- it is a display-level mask. For security-critical secrets, consider using a dedicated secrets manager. This field is best suited for low-sensitivity values that should simply not be visible at a glance on the board.

Autonumber​

The Autonumber field generates an automatically incrementing numeric identifier for each new row. It is read-only and cannot be edited manually.

  • Value type: String (read-only, auto-generated)
  • Default behavior: Each new row receives the next sequential number automatically.
  • Typical uses: Ticket numbers, invoice IDs, order numbers, sequential reference codes.

Configuration Options​

OptionDescription
Start sequenceThe number from which the sequence begins (default: 1)
PrefixAn optional string prepended to the number (e.g., "TICK-", "INV-", "ORD-")

For example, with a prefix of "TICK-" and a start sequence of 1000, the first row would display TICK-1000, the next TICK-1001, and so on.

The current sequence value is tracked by the system and advances each time a new row is created in the table.

Voting​

The Voting field lets the people on your board cast a vote on each row, giving you a quick, lightweight way to gather opinions, prioritize work, or run a poll right inside your data.

  • Value type: Votes cast by board members
  • Default behavior: Each cell shows a positive and a negative reaction with a running count next to each. Click a reaction to cast your vote.
  • Typical uses: Prioritizing ideas or feature requests, approving items, gauging sentiment, deciding between options, surfacing the most popular rows.

How Voting Works​

Every Voting cell displays two reactions side by side --- a positive one and a negative one (by default a thumbs-up and a thumbs-down) --- each followed by its current count.

  • Cast a vote --- Click the positive or negative reaction to add your vote. The count next to it updates immediately.
  • One vote per person --- Each member can hold a single vote on a row. Clicking the opposite reaction switches your vote; clicking your current reaction again removes it.
  • See who voted --- Click a count to open the Voters list and see exactly which members voted positively and negatively.
  • Live updates --- Votes appear in real time, so a tally fills in as your team reacts.

Configuration​

When setting up a Voting column, you can customize:

SettingDescriptionDefault
Positive emojiThe reaction shown for a positive vote👍
Negative emojiThe reaction shown for a negative vote👎
Hide user votesKeeps individual voters private --- members see the totals but cannot open the Voters list to see who votedOff

Pick any emoji for each side from the emoji picker, so the reactions match what you are measuring --- hearts for favorites, check and cross for approvals, or anything else that fits.

tip

Turn on Hide user votes when you want honest, anonymous feedback --- people can see how the totals are trending without seeing who voted which way.

Voting in the Summary Row​

In the Grid view, a Voting column can show its results in the summary row. Choose between the total number of votes cast or an up-versus-down breakdown to see how the whole table leans at a glance.

Translation​

The Translation field automatically translates the text from another column into a language you choose, and keeps the translation up to date as the original text changes. It is read-only --- you never type into it directly. Instead, it mirrors a source column and shows that content in your chosen language.

  • Value type: Read-only translated text
  • Default behavior: Displays the translated version of a chosen source column's value.
  • Typical uses: Multilingual catalogs, translating descriptions or titles for international teams, localizing customer-facing content, side-by-side language columns.

Setting Up a Translation Column​

When you add a Translation column, you configure two things:

  1. Source column --- The text column whose content you want to translate. You can translate Text, Rich text, Formula, and Autonumber columns.
  2. Target language --- The language to translate into.

Once configured, Copera fills in the translation for each row automatically.

Supported Languages​

Language
English
Portuguese (Brazil)
Spanish
French
German
Italian
Japanese
Chinese (Simplified)
Korean
Arabic

Keeping Translations Current​

  • Automatic updates --- Whenever the source column's text changes, the translation regenerates on its own, so the two columns never drift apart.
  • New rows --- When you add a row, its translation is filled in automatically from the source value.
  • Translate in bulk --- You can translate a whole column or a selection of rows at once. Select rows in the Grid and choose Translate from the action bar, or trigger a translation for the entire column. This is handy when you add a Translation column to a table that already has many rows.
note

Translations are generated for you and are meant to give your team a fast, readable understanding of the original text. For high-stakes or legally binding content, have a human review the result.

Next Steps​