Fields
Fields are the columns on a table. Each field has a type that controls what you can store, how cells render, and which filters and sorts apply.
Text, number, date, and boolean fields store values you type. Enrichment fields store provider results with capability labels in the header.
Overview
Every row in a table shares the same fields. When you add a field, it appears on all existing rows (empty until filled). Appenda uses the word field in the product and in version history.
Most types come from + on the grid header. Formula fields compute their value from other fields (see Formulas). Enrichment fields come from the provider catalog and run against each row.
Field types
| Type | Stores | Add from + | Example use | Filter | Sort |
|---|---|---|---|---|---|
| Text | Plain string | Yes | Name, notes | Text operators (contains, equals, is empty, is any of) | Yes |
| URL | A web address | Yes | Website, LinkedIn profile | Same as text | Yes |
| An email address | Yes | Work email | Same as text | Yes | |
| Phone | A phone number | Yes | Mobile, direct dial | Same as text | Yes |
| Single select | One choice from a list | Yes | Stage, tier, owner | Is, is not, is any of, is empty | Yes, in choice order |
| Multi select | Several choices from a list | Yes | Tags, industries | Has any of, has all of, has none of, is exactly, is empty | Yes, by first choice |
| Number | Numeric value | Yes | Employee count, score, amount | Equals, greater/less than, is empty | Yes |
| Date | Calendar date | Yes | Close date, follow-up date | Is, before, after, on or before, on or after, between, is empty | Yes |
| Date and time | Date with a time (UTC) | Yes | Meeting start, last touch | Same as date | Yes |
| Boolean | True or false | Yes | Opted in, qualified, do not contact | Is true, is false, is empty | Yes |
| Formula | A value computed from other fields | Yes | Full name, score bands | Depends on the result (see Formulas) | Yes |
| Enrichment | Provider result for the row | Yes (Enrichment) | Email finder, company data, HTTP request | Filter on the displayed result like text | Yes |
Text
Use for names, domains, free-form notes, and any value you type or paste. Text fields accept filters such as contains, equals, is empty, and is any of (for a short list of values).
Common GTM labels (email, phone, company, job title, LinkedIn URL, location) also pick up matching header icons automatically.
URL
Use for websites and profile links. Appenda keeps only real web addresses:
values with a registrable domain, like acme.com or https://www.acme.com/pricing.
A value without https:// gets it added.
When you change a Text field to URL, you can clean the values at the same time:
| Option | Turns https://www.acme.com/pricing?utm_source=x into |
|---|---|
| URL | The address as typed, with https:// |
| URL, without www or tracking | https://acme.com/pricing |
| URL, domain only | acme.com |
| URL, LinkedIn profile or company | The canonical profile or company link |
Use for email addresses. Appenda trims the value, drops a mailto: prefix, and
lowercases the domain. A value that is not an email (no @, no domain) does
not fit and shows as empty.
Phone
Use for phone numbers. Appenda tidies spacing and dashes but never rejects a number, so extensions and local formats are kept as typed.
Single select and multi select
Use for a fixed list of options, like deal stage or tags. Each choice has a name and a color.
- Type in a select cell to pick a choice. Type a new name and pick Create to add it as a choice.
- In a multi select, separate names with commas.
- Sorting a single select follows the choice order, not the alphabet.
- Change a Text field to a select and every distinct value becomes a choice.
Dashboards group a select by choice name, in choice order, and color the chart with the chart palette. A multi select counts a row once for every choice it holds.
Number
Use for counts, scores, and amounts. Filters use equals, not equals, and greater/less than comparisons, plus empty checks.
Date and date and time
Use Date for close dates and follow-ups, and Date and time when the hour matters, like a meeting start. Times are stored in UTC.
Formats
Formats change how a Number or Date field looks. They never rewrite your values, so filters, sorts, and exports still use the stored number or date. Open the field header menu and point to Format.
| Field | Formats |
|---|---|
| Number | 1234.5 (as stored), 1,234.50, 1,235, 12.3%, 1.2K |
| Currency | $1,234.50, €1,234.50, £1,234.50, ¥1,235, CA$1,234.50, A$1,234.50, MX$1,234.50, R$1,234.50, CHF 1,234.50, ₹1,234.50 |
| Date | 2026-07-06, 7/6/2026, 6/7/2026, July 6, 2026, Monday, July 6, 2026, Mon, Jul 6, 2026 |
| Date and time | The same date formats, plus a 12-hour or 24-hour clock |
Dashboards show sums, averages, minimums, and maximums of a formatted Number field in its format. Counts stay plain.
Boolean
Use for yes/no flags. Cells render as true or false. Filters include is true, is false, and empty checks.
Enrichment
Enrichment fields call a provider capability per row (for example find email from domain). The header shows the provider logo and capability label, not just the provider name.
Results can be success, warning, error, or in progress. Run options live on the toolbar Run menu and in the Enrichments tab. Provider setup is under Integrations.
Add a field
- Open a table.
- Click + on the right edge of the grid header row.
- Pick a type. Most are created immediately.
- For Formula and Stacked formula, write the expression in the sidebar. For Enrichment, pick a capability from the catalog and finish config in the sidebar.
Rename, hide, reorder, or delete from the field header menu. Show all and Hide all live under toolbar Fields.
Change a field's type
Picked the wrong type, or imported numbers as text? Change the type in place. Appenda converts the values it can and tells you first what it can't.
- Open the field header menu.
- Point to Change field type and pick the new type.
- Read the confirmation. It says how many values convert and how many become empty, with a few examples.
- Click Change type.
Version history records one entry, for example "Changed field type of Revenue from Text to Number · 3 values emptied". Undo brings back the old type and every original value, including the ones that were emptied. See Table history.
Change field type is available on every type except Enrichment and Formula fields, which keep their type.
Values that don't fit
A cell can hold a value that doesn't fit its field's type, for example text in a Number field from an older import. Appenda shows that cell as empty everywhere: in the grid, filters, sorts, and dashboards. Appenda does not delete or rewrite the stored value.
Semantic header icons
Appenda assigns header icons from field labels when they match common GTM names. You do not configure icons separately.
| Label pattern | Icon hint |
|---|---|
| Email, work email | |
| Phone, mobile | Phone |
| Company, organization | Building |
| Job title, role | Briefcase |
| LinkedIn, website, domain, URL | Link |
| Location, city, country | Map pin |
| Name, contact name | User |
| Enrichment capability | Provider logo |
CSV import uses the same heuristics when you map columns.
Tips
- Pick the type before you paste data. If you pick wrong, use Change field type from the header menu.
- To clean up values in place, use Find and replace. To merge repeated rows, use Deduplicate.
- Enrichment columns count toward Hide all in the Fields menu like any other field.