Databases

A database is a table whose rows and columns you choose yourself. You can keep daily figures and ledgers in it. You can link a table you’ve made to a goal, or ask AI to write to it for you.

Opening and creating

• Open: On desktop, press “More” in the sidebar → “Other features” → “Store your data” → the “Databases” card. On mobile, press “Databases” under “More” in the menu (≡) at the top left. In a newly created organization, this feature may have a lock. You can use it once you finish the challenge “Learn about databases” or press “Skip and use it (no points)” (→ Challenges and feature locks).
• Create: Press “Create” on the list, enter a name, the name of the key column and the key type, then press “Create”. Whoever creates a table becomes its owner. The key is the column that tells rows apart. In a daily table, the date is the key. A table can’t have two rows with the same key. Add the other columns with “Column settings” in the opened table. Guests and external members can’t create tables
• “Addness creating a database” Press “Addness creating a database” on the list, and AI asks what you want to record, decides the unit of a row, the key and the columns, and builds the table. AI also writes the first figures. If it should write every day, you decide where it gets the data, which day it covers and when it runs, and those steps are left in the goal body (the way to hand it over is the same as Home: Addness it)

Writing and editing rows

• Add a row: Press “Add row” above the table, enter the key value and save. If a row with the same key already exists, that row is shown
• Edit a value: Press the value you want to change, type it and save. On desktop, Enter saves and Esc cancels. For a relation column, choose from the + next to the value to change it. Formula and rollup columns are calculated automatically, so you can’t edit their values
• Delete and restore: Press “Delete row” on the row. Within 30 days, check “Include deleted rows” above the table and press “Restore row” on that row to bring it back. You can’t restore a row if a row with the same key already exists

Only people with “Edit values” access or higher can edit rows and values (→ Visibility and permissions).

Defining columns

Press “Column settings” above the table and three sections appear: “Column names”, “Add column” and “Deleted columns”. Only people with “Edit structure” access or higher can open it. A column name is 1–64 characters long, can’t be the same as another column’s name, and can’t contain { }.

Type	What it holds
Text	Text (up to 2,000 characters and 8,000 bytes)
Number	A number (up to 14 integer digits, 15 significant digits and 6 decimal places). You can set the number of decimal places and the thousands separator
Yen / %	An amount of money and a ratio
Date	A date. Set “Include time” to enter a time as well
Select	Pick from options. You can give options colors, and “Allow multiple options” lets you pick more than one
Checkbox	On or off
URL	A URL that starts with http:// or https://
Relation	Points to rows of other databases, goals, customers or KPI definitions
Formula	Shows a result calculated from the values of other columns
Rollup	Counts or totals the items a relation points to and shows one value

A column’s type can’t be changed after you create it.

• Formula: Write other columns as {column name} to calculate with them. Example: {Ad spend} / {Registrations}. As you type, the screen checks the formula. When a referenced column’s value is empty, or when you divide by 0, the result is empty. A relation column can’t be used directly, so total it with a rollup
• Relation: Choose what to link to from “Record”, “Goal”, “Customer” and “KPI definition”. You can choose the target only when you create the column. One relation value can link up to 500 items
• Rollup: Choose in this order: “1. Relation column”, “2. Target column or attribute” and “3. Aggregate”. The aggregations you can choose depend on what the relation points to. Examples: for rows, count, sum and average; for goals, the number completed; for customers, the number per stage. Only targets you have permission to view are counted, and deleted targets are not
• Edit or delete a column: Choose a column from “Column names” to change its name, format and calculation settings. Deleting a column keeps its values, and within 30 days you can bring it back with “Restore column” from “Deleted columns”. Key columns, and columns that a formula or rollup refers to, can’t be deleted
• Change the key: Press “Key: ◯◯” in the table heading and choose “Change key”. A key can be 1–3 columns, of type text, number, date, URL or single choice. You can’t change it if there are duplicate or empty values

Filtering, sorting and summarizing

Above the table you’ll find “Filter”, “Sort”, “Group”, “Columns” and “Summary row”.

• Filter: You can set up to five conditions, and rows that match all of them are shown
• Sort: Rows are sorted by one value column. Empty values appear last. If you choose nothing, rows are in “Key order”
• Group: Rows are grouped by one column
• Columns: Drag a column heading to change the order. You can also choose to show or freeze columns
• Summary row: For each column you can choose sum, average, minimum, maximum, count or the number of nonempty rows. All rows that match the filter are included. Formula and rollup columns can’t be summarized

Filters and grouping only affect your own screen. What other people see doesn’t change. When someone with “Edit values” access or higher changes column order, width, visibility, freezing, sorting or the summary row, the change is saved as the table’s view and applies to everyone. A view changed by someone with “Member” access becomes “Only on your screen (not saved)”.

Finding and organizing from the list

The list shows each database’s name, number of rows, number of columns, last update (who updated it and when; when AI wrote it, ”◯◯‘s AI”) and your permission.

• Find: Search by name with “Find databases”. With “Filter” you can narrow down by owner and tag, and checking “Include archived” lists archived databases too. For sorting, choose from “Recently updated first”, “By name” and “Newest created first”
• Organize: From the ”…” on a row you can choose “Database permissions”, “Add or remove tags”, “Place or move to a folder” and “Archive”. Tags and folders are available to people with “Edit values” access or higher, and archiving to people with “Edit structure” access or higher
• Folders and archive: If you delete a folder, the databases in it move to the parent folder. If there is no parent, they have no folder. Put databases you aren’t using now in the archive. To use one again, restore it with “Restore from archive” on its row

Linking to a goal

Press ”＋ Add related data” → “Databases” at the right end of the “Details” heading in the goal details, choose the table to link and press “Link”. People who can edit the goal can do this. Once linked, the “Databases” section appears above the Resources section. After that, you can also add more with “Link a database” in the section.

• The section shows each table’s name, number of rows and last update. Up to five appear, the most recently linked first, and the rest are shown only as a count, “N more”. Press “Open” to open a table
• To unlink, press ”…” on the row → “Unlink”. Unlinking doesn’t delete the table
• Put it in the body: Press ”＋ Add widget” at the right end of the “Memo” heading in the goal details → “Databases”, choose a table and press “Add to body”. The first 20 rows of the table appear in the body. Press “Open in Databases” to open the table
• Linking a table to a goal doesn’t change who can view the database. People without permission to view see “You do not have permission to view” in place of the table in the body

Visibility and permissions

Open ”…” at the top right of the table → “Database permissions” to set the visibility and each member’s permission. Changes are saved as soon as you choose them.

• Visibility: Choose “Visible to the organization” (the default when you create a table) or “Selected members only”. When you make it visible to the organization, the default for organization members is “Edit values”
• Permission for each member: Choose from “Member”, “Edit values” and “Edit structure”. A permission you set for a person takes priority over the organization default. “Remove individual permission” returns the person to the default
• Guests and external members: The organization default doesn’t apply to them, so set their permission individually. Guests can only view
• Transfer ownership: In the permissions screen, choose “Transfer ownership” from the member’s actions

Permission	What you can do
Member	View the table. You can use filters and sorting on your own screen
Edit values	Add rows, edit values, delete and restore rows, save the table’s view, and work with tags and folders
Edit structure	Add, change and delete columns, change the key, and archive
Owner	Change visibility and permissions, transfer ownership, and delete the database. Organization administrators can do the same

Asking AI

• You can hand a table to AI with “Addness creating a database” on the list and “Addness this table” on a table. With “Addness this table”, you and AI decide the steps for the morning writing
• When you ask an MCP-connected AI, it can, for tables you have permission for, read the list and rows, create tables, change columns, write and delete rows, delete and restore, link to goals, and change visibility, permissions, owner, tags and folders (→ MCP integration guide)
• When an MCP-connected AI works on a linked goal, it reads that table’s name, number of rows, key, columns and the first five rows. For tables linked to a goal higher up in the tree, it reads only the name and number of rows
• When AI writes to this table each morning, values in rows with the same key are overwritten with AI’s values. AI can’t write to a table when someone with “Member” access asks

Detailed settings

What you can use in formulas

• How to write: Enclose text in "...". A formula can be up to 2,000 characters. The units for dateAdd and dateDiff are "days", "months" and "years", and the formats for formatDate are YYYY, MM, DD, HH and mm
• Math: + - * /, round (decimal places 0–6), floor, ceil, abs, min, max
• Text: &, concat, length, contains, replace, toText, format, toNumber
• Conditions: if(condition, value1, value2), coalesce, empty, and, or, not, = != < <= > >=
• Dates: today() (today’s date; until 4 a.m. it is the previous day), now(), dateAdd, dateDiff, year, month, day, formatDate

Limits and how long deleted items are kept

• Rows, columns and databases can be restored for 30 days after you delete them. After 30 days they can’t be restored. To delete a database, press ”…” on the table → “Delete database”. Only the owner can do this. To restore a deleted database, the owner or an organization administrator asks AI
• An organization can have up to 300 databases (archived ones included). A name is 1–64 characters. A table can have up to 100 columns, and up to 200 columns including deleted ones
• A table can hold up to 50,000 rows, including rows that were deleted within the last 30 days. A key value can be up to 256 characters, a column can have up to 100 options, and a database can have up to 50 tags

This article is written with the screens as of October 21, 2026.

Was this article helpful?

YesNo

← PreviousChallenges and feature locksNext →Customer journeys

Customers & Numbers

• Customer Lists (CRM)
• Analytics
• Forms
• Customer journeys