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.
Where does the calendar view live?
- To find the calendar view, open your app editor by selecting the app you’d like to work on.
- The navigation bar on the left side displays a tab titled “UX”. Click this tab.
- Once you’re in the UX tab you’ll find a navigation bar along the top of your editor. The first tab is your “Views” section.
- Once you’ve found the “Views” section, scroll to the “Primary Views” section.
- From here you can modify or add your calendar view.
Structuring 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
Integrating 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 in the UX window.
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.
Creating 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 a workflow to add events after a certain condition is triggered.
- 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.