The single line text field is best for short, unique pieces of text, such as the names of your friends, the names of your cats, or the names of your friends' cats.Ī single select field is ideal when you want to be able to select a single option from a preset list of options.Ī URL field is intended to store a single URL in each cell. The rating field allows you to rate your records for the purposes of ranking or quality assessment.Ī rollup field performs calculations or formulas on an aggregate of inputs from another field based upon a linked record relationship. 75 in a percent field is represented as 75%.Ī phone number field will format a 10-digit string of numbers as a US/Canada phone number, in the form (XXX) XXX-XXXX. The values in a percent field are all represented as fractions of 100 with the percent sign e.g. The percent field type is a field type designed to hold numerical values formatted as percents. The number field type is a general-purpose field type for most numerical values, like the number of chairs of a particular type your furniture business has in stock, or the distance in kilometers from one city to another city. The number field type is a field type designed to hold numbers. Unlike a single select field, however, you can select as many options as you'd like per cell. If you need more styling options, you can enable rich text for the field.Īrray of numbers, strings, booleans, or objectsĪ lookup field allows you to look up a specific field in a linked record.Ī multiple select field is similar to a single select field it allows you to select predetermined options from a list. You can enter new lines into a long text field, and even a collaborator inside the text. Long text (With or without rich text formatting enabled)Ī long text field is great when you need to keep notes or multiple lines of text in each record. This is particularly helpful when you have multiple tables of related items or concepts-for example, if you have a table of contacts and a table of companies, you can use a linked record field to link each contact to the company that they work for. The last modified time field type returns the most recent date and time that a record was modified by a user in a non-computed fieldĪ linked record field allows you to represent the relationships between related records by creating links between them. The last modified by field displays which collaborator made the most recent change to a record.

Varied outputs (depending on the formula)įormulas allow you to compute a value in each record based on other cells in that same record. Clicking on an email address within an email field will open up your computer's native email client with the To: field addressed to the email you just clicked on. (If you want to store a time duration measured in days, weeks, or other larger units, use a regular number field.)Īn email field is intended to store a single email address in each cell. The duration field type is a numeric field type intended for use with time durations measured in hours, minutes, seconds, or milliseconds. When editing a date time, you will be presented with a calendar widget that makes it easy to select a specific date. The created by field will automatically show which collaborator created a record within the base.Ī currency field is a specific type of number field that formats the number as a currency amount.Ī date field allows you to easily enter a date and optionally a time into a cell. The created time field type will automatically show the date (and optionally, time) that a record was created. The button field adds interactivity to your record such as opening a URL.Ī checkbox field is useful for true/false values within a record.Ī count field lets you count the number of linked records in a record link column. If you use the mobile Airtable client, then you can use the camera in your mobile device to scan several types of barcodes and QR codes.

Autonumbers can be helpful when you need a unique identifier for each record, or when using a formula in the primary field.

You can check out our API documentation if you'd like more information on the data available for each field type.Īn attachment field is a type of field that allows you to attach one or more files directly to your Airtable records.Īn autonumber column automatically generates a unique, automatically incremented number for each record. All currently available field types are listed below in alphabetical order.

Zapier airtable multiple fields