This article covers how to use checkbox fields and formulas to streamline your team's and organization's work. Plan availability All plan types Platform(s) Web/Browser, Mac app, and Windows app Related reading Getting started with formulas Using checkbox fields in formulas in Airtable Using checkbox fields in formulas NOTE When working with checkbox fields and formulas, "= 0" means that a checkbox is deselected, and "= 1" means that a box is selected.  Checkbox fields can also be extremely useful in Automations . They are of particular value when using the “ When a record matches conditions " trigger. So, to make a formula field which returns A when a box has been checked, and B otherwise, you would need to set the formula for the formula field as: IF(Checkbox = 1, "A", "B") NOTE If you'd like to see how to use a Rollup field to count all the checkboxes

Plan Availability Paid plans only Required permissions Owner / Creator - Can add, delete, duplicate, rename, and customize fields Platform(s) Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) Understanding date dependencies in Airtable This article covers using date dependencies to streamline your team's and organization's work. Date dependencies are a project management feature that allow automatically cascading updates of datetimes between dependent records. These updates work by allowing the base creators to designate specific fields for a table(s), such as start date, end date, duration, and predecessor fields. Once those fields are designated, Airtable automatically updates any/all dependent record(s). NOTE Date dependencies differ from the Gantt view date dependency behavior because date dependencies use the data layer for all view types and interfaces . The following date dependency behavior is supported within Airtable records: Supported behavior within records : Automatically recalculate start

Plan availability All plan types Platform(s) Web/Browser, Mac app, and Windows app Related reading Getting started with formulas Formula foundations This article covers how to count records in linked record fields to streamline your team's and organization's work. Using the count field in Airtable Using the count field NOTE To count the number of linked records in a field, you can create another field using the "Count" field type. This will automatically provide the number of records that have been linked to a particular record in a designated field. For a basic overview of the count field type, see " Guide to Formula, Lookup, Count, and Rollup Fields. " Let's suppose that you have a table of team members, and a table of tasks that need to be completed. Using a linked record field, we can link employees to the tasks to which they've been assigned

Plan Availability Business and Enterprise Scale plans only Required permissions Admin - Can access admin panel and modify settings for their organization. For organizations using Enterprise Hub, there are additional admin roles. Learn more about these roles in our Enterprise Hub article. Super admin  - Can access admin panel and modify settings at the organization-wide level. Org unit admin  - Can access admin panel and modify settings at the individual org unit level Platform(s) Web/Browser, Mac app, and Windows app Accessing admins in the admin panel  Anyone with access to the admin panel can add new admins by navigating to the "Users" page. Visit your Airtable homepage . Click your account menu icon in the top-right corner. Select Admin, then click Users . From the "Users page", admins can search, filter, sort, and scroll to find users they would like to have admin access. Managing individual admins If you need to

Plan availability All plan types Platform(s) Web/Browser, Mac app, and Windows app Related reading Supported field types in Airtable overview   Airtable field actions  Airtable terminology Field - A field contains details or metadata for each record in a table. Fields come in a variety of types, storing data in the form of text, single- or multi-selects, images, checkboxes, numbers, user tags, and more. Field type - A field type specifies the kind or format of data stored in a given field. Checkbox fields in Airtable In Airtable, fields allow you to organize all the details for any record in your base, so they can easily be sorted, managed, and analyzed. In this article, learn specifically about Airtable's checkbox field and how to use then. Adding checkbox fields in Airtable Checkbox fields are helpful for true/false values within a record. For example, a task tracking base might have

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'zh-tw'), 'LLLL') => 2016年6月8日星期三晚上8點22分

Plan Availability All plan types Required permissions Owner / Creator - Can add, delete, duplicate, rename, and customize fields Platform(s) Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) Applying emojis using IF statements in Airtable overview This article covers how to incorporate emojis into text strings using the IF statements in formula fields to streamline your team's and organization's work. How do I access the emoji keyboard when in Airtable? To access the emoji keyboard on a Mac: Press Ctrl + CMD + spacebar. To access the emoji keyboard on a Windows-based computer: Press the Windows logo key + “. “ (period key). How can I use emojis with conditional formulas in Airtable? In this example, you want a "Status" field that automatically marks tasks when they are “Overdue”. You also have a "Due Date" column with dates and a checkbox column titled "Completed." In this example

sync considerations After a sync is created, users have the following options for every source field. These options can be found in the “Update sync configuration” window. Select a new synced field in dropdown Change the destination synced field for the source field of your choice. The type of the destination synced field will also change based on the primary source field. Uncheck a field This option will stop syncing data from this source to the mapped field. If this source was the primary source, then the synced field will also be destroyed. Select 'Sync to new field' in the dropdown If the field was previously mapped to a destination: If the source was primary - the synced field will be destroyed, and the data will be mapped to a new field instead. If the source was not primary, the data from this source will be mapped to a new field

Plan Availability All plan types Required permissions Owner / Creator - Can add, delete, duplicate, rename, and customize fields Platform(s) Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) DATETIME_DIFF() in Airtable overview The DATETIME_DIFF() function allows you to calculate the difference between two different datetimes in specified units. Each specifier has a corresponding abbreviation that works like the long-form version of the specifier—. DATETIME_DIFF(Date, Date2, 'y') —resulting in same output as DATETIME_DIFF(Date, Date2, 'years') . Note The output will default to seconds if no unit is specified or the function does not recognize the specifier. The output will default to milliseconds if the unit specified is not recognized. The DATETIME_DIFF() function allows you to calculate the difference between two different datetimes in specified units. Each specifier has a corresponding abbreviation which will work the same as the longform

Plan availability All plan types Permissions Consult the view actions section of the base actions in our permissions article . Platform(s) Web/Browser, Mac app, Windows app, and iOS and Android apps Creating grid views in Airtable The grid view is the default view created whenever you create a new table in Airtable. Every table must contain at least one grid view. To create a grid view: Open your Airtable home screen . Select the table where you want to add a grid view. Click Create new … Click Grid . A pop-up window opens where you can name the new grid view and set the editing permissions( collaborative , personal , or locked ). Click Create new view . From here you can configure the view by hiding fields, filtering records , grouping records , sorting records , and more. Grid view tips and tricks Adjusting row height in the grid view By default, a grid view displays

sync has access to. What happens to the sync if the Jira account used becomes deactivated? The sync will stop working if the connected Jira account is deactivated. How is data transmitted from Jira? The data that we retrieve from Jira’s API is transmitted securely via HTTPS and is not used for any purpose other than syncing data to the table. Can custom fields in Jira be used in the Sync? Custom fields that are based on Jira's built-in field types are supported, but other types of custom fields may not be supported. Are there any limitations to be aware of? Yes, there are a few limitations to be aware of when using this sync integration type: The maximum number of issues synced is 10,000. This is a limit that we impose to ensure reasonable performance. This Jira sync integration only fetches fields from issues if

Plan Availability All plan types Required permissions Owner / Creator - Can add, delete, duplicate, rename, and customize fields Platform(s) Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) Understanding rollup fields in Airtable A rollup field performs calculations, creates aggregates leveraging formula functions on specific cells from records that are linked together. A simple example in Airtable would look like this: Records from a marketing campaign table tracking a percentage of email open rates are connected via a linked record field to a table tracking different marketing campaign project types. In the campaign project types table, all of the email marketing campaigns are linked to a single “Email campaign” record. Other marketing campaign type records are also present. A rollup field is added in the campaign project types table to roll up the values in the email open rate field. The rollup aggregation formula is

This article details best practices for building and enhancing bases. Plan availability All plan types Platform(s) Web/Browser, Mac app, and Windows app Related reading Understand your Airtable bases home screen Creating, duplicating, and deleting bases Troubleshooting Airtable base performance Using views to section out related data Understanding linked record relationships Airtable terminology Base - a collection of data in Airtable, designed to contain all of the information a user needs for a project or workflow. Bases can have multiple tables, each containing data; within each table, there are records, with data for each record stored in fields. How can I improve base performance in Airtable? Create individual views that use filters and hidden fields that only display individual collaborators and associated information. Delete any unused records. Remove non-essential formulas , linked records , or rollup fields . Reduce API usage or insert pauses between calls, when possible. What base design behaviors

will see an "All changes saved" message when the sync has finished successfully. Field sync settings From the sync configuration window, you can choose to sync all fields from the view or just some: If you choose to sync all fields, then new fields added in the sync source will show up in the synced table when the next sync occurs. If you choose to sync just some fields, then any new fields added in the source table will not sync until you have toggled them on as visible from the sync configuration window. Note If you do not see a table that you are expecting as an option, then you may need to check (or have a collaborator check) the settings in the source table/view. Record retention You can also choose how to handle records that are deleted or hidden in the source view. You can either

This article defines the different types of relationships between lists of entities and provides examples so you can learn to identify them yourself. It also explains how to represent many-to-many relationships using a technique called "junction tables." Introduction Plan availability All plan types Related reading Linking records in Airtable Connect your data with linked records guide Relationship types Airtable is a database. In databases, there are a few different ways to describe the relationships between different lists of entities. One-to-one The simplest kind of relationship is a one-to-one relationship. Suppose you have a list of people’s names, and a list of social security numbers. Each person has only one social security number, and each social security number is linked to one person. In the context of an Airtable base, a one-to-one relationship is usually best represented by consolidating the two lists

Plan availability All plan types Platform(s) Web/Browser, Mac app, and Windows app  Related reading https://airtable.com/forgot Adding and managing Airtable account details   Resetting your password  NOTE Verify the email address associated with your account before requesting a password reset. To reset your password after losing access to your account: Open airtable.com/forgot . Enter the email address used to create your Airtable account. Check your email and open the message titled “Airtable password reset.” Click the included link, and enter your desired password. Click Save and Continue . Updating your password To update your Airtable password while logged in: Open your Airtable account overview . Click Update password . Enter your preferred new password and then your current password. Click Save new password . Adding a password for the first time  In addition to using your email address, Airtable allows users to create an account using their Google credentials, Apple

visit the community ideas page to provide product feedback. Thanks for helping us to contually improve the Airtable product.