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

To create a calendar view:

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

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. 

  1. Date: Start Date and End Date
  2. Time: Start Time and End Time

Calendar view example.

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. 

Important notes

  • Calendar views have four required fields that are marked with a double asterisk (see below image and exclude the category field)
  •  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).
  • 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.
Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center