Start and End Dates on Database Calendars

Modified on Fri, 23 Oct at 5:00 AM

The Database Calendar view allows you to view records against a calendar. Alongside this is the ability to display a record according to start and end date(s) or ranges. These dates can be taken from any date field within the form (excluding those with conditional or duplicable related logic), with each record rendering based on the data entered by the user within those fields.

2019-07-22_13-23-25.png

Users can also set multiple start and end dates, allowing them to view records multiple times as they progress through the various stages of a project. To find out more about how multi date selection works, click here.

To Create Start and End Date Defaults

  1. Go to Database Settings
  2. Find the field called Default Calendar Date(s) and click on the Configure button.
  3. In the popup that appears, select the date or date range that you want all users to see as the default value.
    • If adding a start and end date, then the records will appear as a range between those 2 dates.
  4. Save the Database Settings page to update your view.

Once you've saved the defaults, the calendar view will automatically update to display the records as a range, according to those date fields selected.

You can view a demonstration of how to enable default start and end dates below:

2019-07-22_13-27-35.gif

Changing Start and End Dates

The date fields at the top left of the calendar view allow you to change dates on the fly. Once you choose a new field in the dropdown, the record display will automatically update to reflect your new selection. You can also choose to view via Date Created or Last Updated from within this dropdown.

2019-02-19_17-30-47.png

If you have Multiple Date Ranges enabled, you'll see a button called Calendar Date(s) instead of the dropdowns above.

Viewing Date information on the Record

Dates are indicated on the record display (except on the Quarterly and Annual views) and when you hover over the Info icon (as below).

2019-02-19_17-34-12.gif

Adding a Record via the Start Date

In addition to adding a record via the Add button at the top right of the screen, you can also click on any day within the calendar to create a record. Once a start date is enabled on the calendar view, then whichever day you click on will be automatically populated within that start date field on the record.


To read more about calendar view, click here.

Please note that the 'Database' and 'Records' terminology referenced above may appear differently in your platform as these are customisable terms.

If you have any further questions please contact your Customer Success Manager.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article