A calendar view is used to display multiple records from your database.
How Calendars Work
Calendars display multiple records from one of the objects in your database in a graphical calendar interface.
Calendars can be displayed in multiple formats, like month, week, or day views:
Clicking on a calendar event can display more details in a popup. Each record’s details can be linked to a child page to edit or view more details about that record:
You can add a calendar to display records on any entry page in your pages by selecting the Calendar option from the views toolbar at the top of the page:
Select the object you want to display records from, and click the "Add calendar" button:
Note: only objects that have at least one Date/Time field will give you the option to display records in a calendar.
Then you can select additional options to add links to view or edit each list record in a new page. Last, click the "Add view" button:
You can add links to edit each record with a form or view more details about each record.
You'll also have options to display any connected records, if the calendar object has any connections to other records.
New calendars will use the first date/time field to display records in the calendar, the first short text field as the label by default, and the first six fields for displaying popup details.
Click directly on a calendar in your pages to edit it:
The calendar will open in "edit" mode where you can use the menu on the left to edit different aspects of the calendar.
The Data Source section is used to control the records the calendar will display:
Data: the table will display all the object's records by default. Use the data section to add rules to limit which records will be displayed.
Limit: show all the available records or limit to a specific number.
The Calendar section is used to control how the calendar works with your object to display events:
Title & Description: optional copy you can display above the calendar to add any necessary instructions or explanation.
Display: Calendar or List. Calendar is the default using a typical graphical interface. The list option lets you display as rows of text but still lets you navigate by different ranges (days/weeks/months).
Starting Range: the calendar has options to display in multiple date ranges: by month, by week, and by day. The user will be able to change which range they display the calendar in. This selection sets the starting range.
Date Field: select a field that the calendar will use as the date to place each event on the calendar. This field must be Date/Time type.
Label Field: select a label field the calendar will display with the date. Choose a title, name, or other field that can easily identify the whole record.
Week Start: select if you want the week on your calendar to start on Sunday or Monday.
Exclude Weekends: check this option to remove weekends from the calendar.
Starting & Ending Time: limits the time range in week and day views.
Event Options: Event Options give the user options when clicking on a date/time on the calendar:
Show Event Details: when activated, the user can click on each event to view more details about that event in a popup window. See the Event Details section below for formatting this popup.
Allow Event Adding: when activated, the user can click on a day in the calendar to add a new event. The date field will default to the day that was clicked. See the Add Event Form section below for formatting this form.
Allow Event Dragging: when activated, the user can drag an event and move it to change the date, time, and duration.
Feeds: Feeds give the user options to download feeds that include all the events the calendar is displaying:
RSS: an RSS feed can be subscribed to and will automatically update events in an RSS feed reader.
iCal: a downloadable format that can be used to import existing events.
The iCal download/URL of your calendar events will include only the upcoming and previous six months of events, based on the date you download the events. The iCal format will also not update with new events automatically from your App to the secondary calendar.
Note: Neither feed option will work if the calendar is meant to show records connected to the logged-in user, or similar.
Knack Tip: You can sync Knack calendar events to a Google calendar by right-clicking the iCal download link (on your Live App calendar view) and selecting the "Copy Link Address" option. You can then paste that URL into the “Add by URL” option in the Other Calendars section of your Google Calendar.
If you get an error, "We could not parse the calendar at the URL requested.", it likely is due to the file size of your iCal .ics file. Google recommends a file size of less then 1MB, so number of records or other filters may need to be applied to keep the file size under that limit.
Event Colors: add rules to display events in different colors based on criteria you add.
Record Filters: filters give the user tools to further refine which records the calendar will show. You can add filters as options for the user to add, or as a menu.
User filters: enabling user filters presents options for a user to add any filters they'd like to the calendar. This will then display an "add filters" link above the calendar:
The calendar will update as soon as a filter is added. Multiple filters can be added as needed.
You can determine if the fields available to filter are limited to the calendar details or all the object fields. You can add preset filters that will initially filter the records.
Filter Menu: Enabling a filter menu will present links above the table the user can click that will filter the records based on the rules you create.
If your calendar is configured to show more details about a record when you click on it in the calendar, you can manage that details popup here. This follows the same model as the Details view.
Add Event Form
If your calendar is configured to allow new records to be added when the calendar is clicked, you can manage the form inputs here. This follows the same model as the Form view.