Fields turn a list of names into information your team can act on.
A record without fields is only a name. Fields add what your team needs to act on it: who owns it, when it's due, where it stands, and how it connects to other work. Choosing the right type also decides what you can do later, such as filtering by a person, grouping by a status, or adding up numbers.
Basic fields for every database app
These fields answer the everyday questions: what is it, who owns it, where does it stand, and when is it due.
Primary field: the title of every record, such as the task or the client name. You choose which field it is. Learn more about the primary field →
Single select: one option from a list, such as the priority or the type of request. You set up the options in the field settings.Multi select: several options at once, such as the skills of a candidate or the regions of a deal. Learn more about select fields →Status: where a record stands, such as Not started, In progress, or Done. Each option is either incomplete or completed. Learn more about the status field →Member: one or more people of your organization, such as the owner or the reviewers, so responsibility is clear. Learn more about the member field →Date: a date, with an optional time and end date, such as a deadline or a viewing. Learn more about the date field →
Tip: Group a Board view by a Single select or Status field, and each option becomes a column. For example, show all tasks by priority or all deals by stage. Learn more about board views →
Choose the field type that fits the information.
Fields for different kinds of information
When your records hold more than names and dates, use these:
FilesandImages: attach contracts, receipts, or photos of a property right to the record. Learn more about the files field →Single line textandMulti line text: a short summary, an address, or longer notes, so people don't have to open every attachment. Learn more about text fields →Number: prices, quantities, and percentages, with a currency or a unit. Learn more about the number field →Link,Email, andPhone: contact details for a CRM, or a link to a website. Learn more about link, email, and phone fields →Location: an address you can see on a map, such as a job site. Learn more about the location field →Task list: small steps inside a record, each with its own check mark. Learn more about the task list field →
Advanced fields for connected work
These fields connect your database apps and record what happened:
Relation: links records of two database apps, such as tasks to their project or deals to their company. Learn more about the relation field →Calculation: works out a value from other fields, such as days until a deadline, a total price, or the hours of all tasks of a project. Learn more about the calculation field →Unique ID: a number that counts up for every new record, such as an invoice or ticket number. Learn more about the unique ID field →Created onandCreated by: when and by whom a record was created. Useful to find old records or to filter by author.Last edited onandLast edited by: when and by whom a record was last changed. Learn more about created and last edited fields →
Show only the fields people need
A database app can have many fields, but not everyone needs all of them all the time.
In a view: in a table, click the icon with the tooltip Customize in the toolbar. Under Show in table, turn fields on or off as columns. To change all at once, select Hide all, or Show all when some fields are hidden. Each view keeps its own choice: changes show Unsaved view until you save them. Learn more about table views →
Turn columns on or off for each view.
On the record: open the app menu, select Customize record layout, click the handle (⋮⋮) of a field, and select Display options. Choose Always show, Hide when empty, or Always hide. Hiding a field doesn't delete its values. Learn more about field visibility →
Learn more
FAQs
Can I change the type of a field later?
Can I change the type of a field later?
Yes, for some types. Tape converts the values where it can. Learn more about changing a field type →
Single select or status: which one should I use?
Single select or status: which one should I use?
Use Status for the progress of a record, because Tape knows which options mean done. Use Single select for everything else, such as priority or type. A database app can have one status field. Learn more about the status field →
Can I add a checkbox to a record?
Can I add a checkbox to a record?
Yes. Create a Single select field. In Customize record layout, click its handle (⋮⋮), select Edit field display, and set Display as to Checkbox. For several steps to check off, use a Task list field. Learn more about select fields →
Still have more questions? Find answers and get help from community experts in the Tape community →.
