Fields & field types

Updated 2026-10-30

Fields are a table's columns. Each field has a type, so DataWasi knows whether it holds text, a date, money, a link to another record, and so on.

Add a field

Open the table's settings — Settings beside the table's name, at the top of its pages, or the ⚙ at the end of its tile on the account's page — and click Fields.
Click Add field, beside the title, then choose the type that fits.
Give the field a name, adjust its options, and save.

To change a field later, click it in that list. Its page is titled the table's name › Settings › Fields › the field's name, with its type beside it; click Fields there to go back to the list.

Field types

Text — free text: names, notes, short answers.
Number — a numeric value you can total and sort.
Auto-number — a sequential number assigned automatically to each record, with an optional prefix: FAC-001, FAC-002… Good for invoices, orders, and folios; it can't be edited.
Date — a real calendar date to filter and sort by.
Date & time — a date with a time of day. You type it in your timezone and everyone sees it in theirs.
Date range — a start and end date, for stays, bookings, and projects. Leave the end empty for a single day.
Checkbox — a yes/no mark: done, paid, active. Filter by checked or unchecked.
Email — an email address, shown as a clickable link.
Phone — a phone number, with links to call and to open a WhatsApp chat. Include the country code so WhatsApp can find it.
Link — a web address, shown as a clickable link.
Location — a point on the map. Pick it by clicking a map, use your current position, or paste coordinates. Shortly after you save, the place's name shows over the coordinates — the street and number, or the shop or park there — as OpenStreetMap names it. It links out to OpenStreetMap and feeds the table's map.
Money — an amount in a chosen currency. Its code shows a little smaller than the figure, and amounts shown together line up: in a list, the codes down the left of the column and the figures down the right.
Options — a choice from a fixed list of up to 500 options. When a list is long, a box above it narrows it as you type.
Reference — a link to a record in another table. It can show more of that record too, like a customer's email.
Person — someone who can see the table: who a task is assigned to, who owns a deal. You pick them from a list of the people the table is shared with; share it with a group to add more. Search assigned_to:@me to see the records that name you.
File — one or more files or images. Each file uploads as soon as you pick it; Save waits until every upload has finished, and leaving the page mid-upload asks you first. If file storage is slow to confirm an upload, the file is kept and checked again shortly after; an upload that fails can simply be picked again.
Rich text — formatted text: headings, lists, and links.
Formula — a value computed from other fields. An amount of money it works out — a price times a quantity or an exchange rate — keeps two decimals.
Rollup — a total or count drawn from linked records.
Line items — a grid of rows inside a single record.

Remove an option

In an Options field's settings, the × beside an option removes it. When no record holds it, its row leaves the list and Save removes the option.

When records hold it — the ones in the trash too — the × opens a page saying how many and asking what goes in its place: another option, or nothing. Confirm, and the option leaves the list and those records change right away; if it was the default option, the one you picked becomes the default. This can't be undone. A field's last option can't be removed.

Duplicate a field

To have a copy of a field with its values — as the start of a variant, or to change its type — open its settings and click Duplicate…. The copy sits right after the original, in its section, and an admin-only field makes an admin-only copy.

Choose the copy's type. Beside each type you see how many of the values convert, and some that don't: text becomes a number when it's written as one — “1,500” is fifteen hundred —, a date when it reads like 2026-10-27 or 27/10/2026, and Options with one option per distinct text; any field becomes text as it reads. What doesn't convert stays empty in the copy.

The original never changes. Compare the two columns, fix what's empty by hand, and when you're happy remove whichever you don't need. Formulas, rollups, views and the table's label keep using the original until you change them.

A formula, a rollup or an auto-number duplicated as it is works out its own values; an auto-number numbers the records afresh, in the order they were created. To keep the values a formula has now, duplicate it as a Number. File fields, and fields shown from a reference, can't be duplicated. Records in the trash keep only the original's value.

Show more of a referenced record

A reference shows the record it points at by its name. To see more of it beside each record — the customer's email and phone next to every order — open the reference field's settings and, under Also show, tick the fields you want and save. Each one becomes a field of this table, named like “Customer · Email” and placed right after the reference.

These fields are read-only and always show the referenced record's current value: when the customer's email changes, every order shows the new one. Rename them, move them into a section, filter and sort by them, or mark them admin-only like any other field. Untick one to remove it; removing the reference, or the field it shows, removes it too. Someone who can't see that field on its own table doesn't see it here either.

Amounts in more than one currency

A Money field shows its amounts in one currency. When a table's records come in several — some orders quoted in dollars, others in pesos — add an Options field for the currency whose options carry the code, like “Dólares (USD)” and “Pesos (UYU)”. Then open the money field's settings and, under Currency, set Each record's currency to that field.

Each record then shows its amount in the currency picked on it, and on the form the code beside the amount changes as soon as you pick another. The currency above it covers the records where that field is empty or picks an option without a code. A line-items money column can follow it the same way, and so does a rollup that adds it up. A currency conversion leaves the amounts already in its target currency as they are, and totals from a connected app come per currency instead of adding dollars to pesos.

Typing numbers and amounts

Type numbers the way you always do: in English 15,000 is fifteen thousand and 15.50 has decimals, and in Spanish or Portuguese the other way round — DataWasi reads them in the language you picked. When a number has both marks, the last one is the decimal point, so 1,234.50 and 1.234,50 mean the same. When you edit a record, an amount opens as a plain number without thousands separators, ready to change.

Group fields into sections

A long record reads better in groups — the contact details together, the address together. Open a field's settings and type a Section name: fields that share it are grouped under that heading on the record's page and on its form, and on the record's page they edit together, from the Edit on the heading's line. The box suggests the sections the table already uses, and capitals don't matter — typing "address" joins "Address".

Fields without a section come first, as usual, and each section follows in the order of its first field — reorder the fields to reorder the sections. A section goes away when no field names it any more, and a table without sections looks exactly as before.

To put sections side by side, size a total or line amounts up on the right, see record layouts.

Some fields can be marked admin-only, so only people who manage the table see them — on screen and printed. The label field can't be hidden this way. A printed record leaves them out unless you add them — see full screen and print.

A field can also stay off records' public links: tick Not in public links in its settings, and whoever a link is sent to doesn't see it, while everyone with access to the table still does. Admin-only fields never show there anyway, and the label field can't be left out — it's the link page's title. A formula worked out from a field left out still shows, unless you leave it out too. The field's row in the table's list says not in links.