If you have at least one date field in your table, you can create a calendar view. Calendar views (as you might guess) allow you to look at your records on a calendar.
IN THIS ARTICLEIntroduction
Creating a calendar view
Using different view modes
Creating and editing records
View events in a record list
Users on Pro plans have access to a set of advanced calendar features, designed so that teams with calendar-intensive workflows can get extra insights from their records and design extra-powerful calendars. These include the ability to define date ranges, as well as the ability to plot multiple date fields from the same table on a calendar. Record coloring, another Pro plan feature, is also particularly useful in calendar views.
For more information on Airtable Pro plans, please see our pricing page.
To create a new calendar view, open the view sidebar, then underneath the "Create" heading click the "Calendar" option. If your view creation section is collapsed, you will need to first expand it.
You will then be prompted to select one of the table's date fields to use to place dates on the calendar.
(Note that in order to create a calendar view, you must have a date field in your table. If you do not already have one, you will be required to create a new one using the "Create a new date field" option.)
Once a date field has been selected, your calendar view will populate with the records from the selected date field.
To change the calendar view's associated date field (or date fields, if you have a Pro plan), click the calendar icon in the view bar. This will bring up the date field picker again.
If you have a Pro plan, the date field picker will let you select two date fields in order to define ranges. To define a date range, click the Set an end date field option next to a date field that has already been plotted. This will bring up a dropdown menu of date fields from your table. (You can also create a new field, if you'd like.)
Records with values in both fields will show up on the calendar as ranges.
You can click and drag on ranges to move them around, or click and drag on the edges of the ranges to lengthen or shorten them as desired.
If you have a Pro plan, you'll see the option to Use an additional date field in the date picker. Click on it to bring up a dropdown menu of the other date fields in your table.
You can plot up to 20 date fields (or date ranges) onto a single calendar view.
To remove a date field or range, click the X next to the date field or range you wish to remove.
If you have multiple date fields or ranges on your calendar, you have the option of giving each field or range a label to help differentiate them. Something short and sweet is usually good. (We also recommend trying emoji.)
Alternatively or in addition to labels and emoji, you can give each of the multiple date fields or ranges on your calendar a different color using the record coloring feature.
Certain tasks require you to look at the big picture, while others require that you take a more granular view. Accordingly, you can adjust your calendar view to one of several modes by clicking the toggle in the upper right corner of your calendar. You can choose from:
- Month (default)
- 2 week
- 3 day
Note that if you're in week, 3 day, or day mode, and the date field on which the calendar view is based also contains time values, the calendar view will show a timeline on the left hand side of the screen.
We do not have an annual / yearly view mode at this time.
By default, your calendar view will show weekend dates (Saturdays and Sundays). You can minimize the width of weekends in your calendar view to give additional space to your calendar's weekdays. To collapse weekends on your calendar view while in month, 2 week, or week mode, click the Collapse weekends button visible over the Saturday and Sunday columns.
You can return the weekend dates to their original appearance by mousing over the Saturday or Sunday column headers and clicking (a popup that says "Expand weekends" should appear).
To add a new record on a particular date in Month or 2 week mode, you can click the + button that appears when you mouse over a date, or double-click on the date to which you want to add a record.
To add a new record at a particular time in Week, 3 day, or day mode, double-click on the date/time to which you want to add a record.
If you have one date field for the calendar, the date field for the new record will be automatically be set to the date that was clicked. If you are on a Pro plan and have multiple date fields and/or date ranges plotted on the same view, clicking the + button or double-clicking will bring up a menu allowing you to specify which date field you want the record card to be plotted to. (The menu will use the labels you defined for your different fields and ranges.)
If you add a record with a date range, the date you clicked will set the start date.
You can edit records directly from the calendar by clicking on a card. This will bring up a mini-editor from which you can edit the primary field or the associated date field being used for scheduling. Clicking on the "Edit details" button will bring up the expanded record view; clicking on the "Delete" button will delete the record.
You can also edit a record by clicking on a card in the side bar, which will open up that record's expanded view.
TIPCurrently, only the primary field is displayed when in calendar view. There is no way to display other fields in calendar view other than expanding each individual record. If you need a way to display additional information from other fields on your table, one workaround you can consider is to reconfigure the primary field as a formula field to include that information.
Clicking and dragging a card on the calendar will also reschedule the event, editing the value in its date field. Dragging a record card from the sidebar onto a date on the calendar will also change an event's date. If you drag a record to the sidebar, that will clear the value in the date field, "unscheduling" it.
Please note, that like all changes made in any view, the changes you make on a calendar view will also be reflected in the date field in all other views!
If you have a Pro plan and have plotted any date ranges, you can click and drag on them to move them around just like the single-field cards, or click and drag on the edges of the ranges to lengthen or shorten them as desired.
As mentioned in Changing record dates, you can use the sidebar listing your records to schedule or reschedule events by clicking and dragging records to and from the sidebar. You can also use the find record box to search through your records—it'll search through all fields for your query, not just the names of the records.
You can also click the dropdown arrow next to "All records" to instead view only records with dates (arranged in chronological order), or to view only records without dates.
You can also use the record list to jump directly to a record's position on the calendar by right-clicking on a card and selecting the Go to date option.
To hide the record list and just see the calendar, you can click the X button in the top right corner of the record list. To bring the record list back, you can click the Show record list button.
You can integrate an Airtable calendar view with your favorite third-party calendar app by getting an iCal link from a shared calendar view. For more specific instructions on how to do this, please see this article on integrating Airtable with external calendar applications.
To delete a calendar view, simply click on the ellipsis button in the view bar and select the "Delete calendar" option.
Can I reorder the way records are displayed on a day/week/year within the calendar view?
Records in the calendar view are always displayed by age, with the oldest record on top. We do not currently support the ability to change this ordering.