Database Design Documentation
Database Design Documentation
When a sheet contains Date/Time or Recurring Date fields, you can use the Calendar in Ragic Reports to manage schedules or set periodic reminders. For example, you can manage meeting schedules, client visits, or equipment maintenance reminders.
After creating the Calendar report, the following page will appear. You can adjust the settings in the top section.
The settings for the Calendar are explained below:
First, select the "Start Date" field and, if needed, the "End Date" field. Then, choose a field to be used as the Title displayed on the Calendar.
Clicking on an event in the Calendar will display detailed information for that record on the right side.
You can also select a Selection field from the sheet (e.g., Selection, Select User, Select Group, Cascaded Selection, Linked Fields, etc.) as the Color code.
It helps users view and differentiate Calendar events.
Note: The category colors are preset and cannot be changed. If there are more than "9" items, the colors will repeat.
In the upper right section, you can choose to view the Calendar in "Day", "Week", or "Month" mode. When using "Day" or "Week" mode, it is recommended to select Date fields that include hours in their format.
Day Mode: Suitable for quickly overviewing tasks for an entire day.
Week Mode: Suitable for viewing weekly work or schedules.
Month Mode: Suitable for planning and arranging tasks or activities that span several days.
For "Day" and "Week" modes, you can adjust the view to either a "12-hour" or "24-hour" clock. Click the gear icon next to it to set the starting day of the week.
After selecting "Day" or "Week" mode, the third row in the upper left corner will appear, allowing you to configure "Time" display settings.
You can choose the time interval as "hourly", "30 minutes", or "15 minutes" and set the start and end times.
When selecting a time interval of "30 minutes" or "15 minutes", an option to Show Hourly Lines will appear on the right. You may check this option to make the Calendar easier to view.
After creating the Calendar, it will automatically display the current date. You can select a chosen date to jump to a specific date, which helps in quickly locating the record.
In addition to regular Date fields, the Calendar also supports Recurring Date fields. When selecting a Recurring Date field, the "End Date" option will not be displayed.
1. No Date Fields: If the sheet does not contain Date fields, the following message will appear when creating the report.
Additionally, if there is only one Date field in the sheet, the "End Date" option will not be available.
2. Displaying Only Time Format in Date Fields: For example, if the date and time are in separate fields and the Time field format shows only HH:mm, the Calendar will not display time correctly.
This field cannot be used as the "Start Date", resulting in all-day events without time-based display.
3. Cannot Select Subtable Fields: Since fields in Subtables cannot be selected, if you need to analyze Subtable data, consider creating a new sheet from the Subtable.
If you frequently use this type of report, you can save it for easy access later. Additionally, you can export the report as a PDF file or print it.
When your sheet has Shared Views or the Fixed Filter applied, you can filter the report based on those views.
You can embed the report into your website or share a link with others.
You can adjust the report’s style settings, including font, font size, boundaries, etc.
