Guide
A Field is a way to store information of a certain kind for all Database Entities, such as text, number, relation, etc.
You can add as many Fields as you want for every Database.
You can also search Database fields in Space Setup and navigate to the fields quickly via keyboard.
Every database in Fibery always has four fields by default:
Name
Created By
Creation Date
Modification Date
What are the Field types?
Basic Fields
Text — a simple text field, typically not more than a single line of text, without formatting
Number Field — a number with formatting options.
Single and Multi-Select fields
Workflow Field — track the status of an Entity.
People field — assign people to an Entity.
(this is a special kind of Relations field, with Inbox and notifications automatically added)
Date field — a date or date range with an option to include time.
Checkbox — a single checkbox (= true or false).
URL — a link to some resource.
Email — an email address.
Phone — a phone number.
Location field — stores location as an address or coordinates.
Icon field — an emoji for a particular Entity.
Avatar — a custom avatar for every Entity (useful for Teams, Departments, and Customers).
Files — upload and attach files to Entity (PDFs, slides, and videos).
Comments — discuss Entity in a comments thread.
Complex fields
Rich Text — more sophisticated than a simple text field. Great for a Feature description or Article content.
Relations — connect Databases. For example, a Feature may have many Tasks, or many Teams can be assigned to a Feature.
Lookups — show a field from a related Database.
Formulas — calculate things. For example, a total effort of all Tasks related to the Feature.
Documents — allows rich text documents to be associated with an Entity.
Whiteboards — allows whiteboards to be associated with an Entity.
How to add a Field?
There are several ways to do that.
Add Fields from any Entity of the Database.
For example, open any Entity and find + New field or Relation action in the bottom right corner.
Add Fields from the Database setup screen.
Open the Database setup screen and add new Fields there.
How to delete and rename Field?
There are two ways to do it.
Delete or rename the Field from a Database setup screen.
Navigate to a relevant Database, and click … near the required Field:
Delete or rename the Field from any View.
Find … near the Field and click it to invoke the actions.
How to duplicate field?
It's possible to duplicate field. You can quickly duplicate basic fields (including single- and multi-selects) into another database.
Set Fields default values
You can set default static values for
Checkbox (Checked or Unchecked)
Basic text fields (Text, URL, Email, Phone)
Number fields and date fields. For example, you can set 19% default for VAT field or 0 for some number field, or 1 for Currency Rate field.
Single Select
Navigate to Database → Fields section, click on a field and find Default option setting
Convert fields
Convert Select field → Database
You can convert single- and multi-select fields to a proper database! There are some cases where select field limitation hit you hard and you want to expand it with some meta-data.
Navigate to select field and click Convert → Database action. As a result, new database will be created and all existing views, formulas and other things will remain intact (however, if you have services that accessed this field via API it can break).
Convert Field: single-select → multi-select
You modeled a field as single-select because, at the time, one value per entity was enough. Then reality drifts: a course ends up belonging to two programs, a client sits in two segments, a bug spans two components. Instead of building a new multi-select field from scratch and re-entering every value by hand, you can convert the existing field in place.
Where to find it
You can start the conversion from any of these:
the … menu on a single-select field → Convert to… → Multi-select
the Fields section of Database setup → Convert to… → Multi-select
right-click the column header of a single-select field, if your List or Table view is grouped by it
Before you convert
Converting a field resets everything built on top of it: views, filters, sorting, formulas, rules, reports, and smart folders that reference this field all get reset.
FAQ
Check Fields FAQ for popular questions and answers.