UX view type: Calendar view

The calendar view allows you to display data associated with dates and times in day, week or month formats. Additionally, you can display the calendar as a singular view or part of a dashboard view. 

Create a calendar view

  1. To create a calendar view:
  2. Create a view, as described in Create a view.
  3. Select calendar as the View type when configuring the view.

Calendar view example.

  • Calendar views have four required fields that are marked with a double asterisk.
  • All calendar views must specify a start (Start Date, Start Time) and an end (End Date, End Time). If you’re receiving an error in your calendar, a good place to start is by checking that these are all set.
  • If you only have one date value in your data, use it as the start AND end date (likewise, you can use a single time value as the start and end values).

Structure your data for calendar view

Because your data structure influences the interface and functionality of your application, it's important to ensure it's structured in a format that's easiest for AppSheet to read. Below are column header suggestions to help get you started. 

  • Date: Start Date and End Date
  • Time: Start Time and End Time

Integrate with Google Calendar

AppSheet currently supports integration with Google Calendar, but not other Calendar platforms. To integrate with an existing Google Calendar, add your Google Calendar as a data source via the Account > Sources > + Data Source > Google Calendar. Allow AppSheet to access your Google Account, and then create a calendar view. 

You can change the Google Calendar and it will sync across the app. You will need to create the blocks in Google Calendar for them to populate in AppSheet. 

Create recurring events

The calendar view does not directly support a way to create recurring events. However, there are workarounds that you can implement. For example, you could create an automation bot to add events after a certain condition is triggered. 

Customize the color of tasks in a calendar view

For tips on customizing the color of tasks in a calendar view, see this community article.


Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center