Skip to main content

Database fields (new record)

Leo avatar
Written by Leo
Updated yesterday

Database fields add all kinds of context to your database records, like due dates, task owners, relevant URLs, last edited timestamps, and more. Use these fields to filter, sort, and search your data.

Types of database fields

We’re in the process of rebuilding all fields for the new record.
Check the list of fields currently available in the new record on the Tape's community →

Field

Description

Single line text

Best for short content, such as titles, names or keywords.

Multi line text

Add text that can be formatted. Great for summaries, notes, and descriptions!

Single select

Choose one option from a list of tags. Useful for categorization.

Multi select

Choose one or more options from a list of tags. Useful for tagging items across multiple categories.

Status

Track this record’s progress using status tags categorized by Completed or Incompleted.
Each app can include only one status property.

Files

Upload files and images for easy retrieval. Useful for storing documents.

Images

Display images in different layouts and sizes in your record.

Member

Tag a person in your Tape organization. Useful for assigning tasks or referencing relevant team members.

Date

Accepts a date or a date range (time optional). Useful for deadlines.

Number

Accepts numbers. These can also be formatted as currency. Useful for tracking counts, prices, or completion.

Checklist

Create subtasks to break up the work of a record into smaller parts.

Link

Accepts a link to a website and opens the link in a new tab when clicked.

Email

Accepts an email address and launches your mail client when clicked.

Phone

Accepts a phone number and prompts your device to call it when clicked.

Location

Enter the address of a specific location and see it on a geographic map. Learn more

Calculation

Run all kinds of calculations and functions based on other fields within an database app, as well as fields within referenced database apps.

Relation

Connect database apps. Useful for connecting records across your organization.

Unique ID

Automatically creates a numerical ID for each record. IDs are unique and cannot be manually changed.

Created on

Records the timestamp of an item's creation. Auto-generated and not editable.

Created by

Automatically records the person who created the item. Auto-generated and not editable.

Last modified on

Records the timestamp of an item's last edit. Auto-updated and not editable.

Last modified by

Automatically shows the user by whom each record was last modified. Auto-updated and not editable.

Create a field

To create your first field in a database,

  • Open any record. In tables and lists, hover over a row and click anywhere. In boards, click anywhere on the card.

  • Click the ••• button in the top right.

  • Select Unlock record.

  • Click + icon, appears in the left margin whenever you hover over a new line or just write / commands: The fastest way to add field blocks

  • Choose from the list a field

Edit fields

Every field block has a ⋮⋮ icon in the left margin - we call this the block handle. It appears when you hover over the field. Click it to open a menu of actions you can take on the field block:

  • Edit field: Change the field’s name, type, and settings. You can:

    • Toggle whether it’s Required

    • Set a Default value

    • Adjust field Access

    • Duplicate or Delete the field

  • Edit style: Control how your field looks. You can:

    • Choose a style set (Default, Outlined, Filled, or Custom)

    • Set the size, label position, and placeholder text

    • Show or hide the field icon

    • Customize label behavior

  • Display options: Choose when and how this field appears. Options include:

    • Required — synced with field settings

    • Always show

    • Hide when empty

    • View only

    • Always hide

  • Top and Bottom description: Add context above or below the field. Helpful for instructions or examples.

  • Turn into: Transforms the block into another type of block

  • Duplicate field: Makes an exact copy of the field.

  • Delete field: Pretty self explanatory.

  • Rules: e.g. show or hide blocks based on user input.

There’s so much more to explore in your field settings and you can use the block handle to drag and drop the field to a new position in your layout.

Edit field values

Any data put into a field is called a value. The way you edit values is different for each type of field. Here are just a few examples:

  • In Single and Multiple line text fields, you can add texts, numbers or special characters. In Multiple line fields, you can also format your text — just highlight it to open the formatting menu.

  • For Date fields, clicking to add data will bring up the date picker, where you can select the day relevant to the record - for example a due date or deadline.

  • For Single or Multiple select fields, you'll be prompted to add options by typing or by clicking on one option. Single allows you to select one option, multiple more.

  • In a Member field, you can tag yourself or members of your organization.

  • For Attachment fields, clicking on the field provided will prompt you to upload a file. You can also drag a file from your computer into the field to upload it.

  • Values automatically appear for these properties: Created on, Created by, Last modified on, Last modified by.

  • You can simply type (or paste) values for Link, Email, Phone, Number fields, just like you would for a text field.

  • Editing values for Relation and Calculation field requires multiple steps.

Did this answer your question?