show / hide menu

Calendar

A calendar serves as a method for organizing time units to track duration over extended periods. This involves assigning names to time intervals, usually days, weeks, months, and years. A date represents a particular day within this framework. Additionally, a calendar can refer to a schedule of scheduled events. 

Working 

The calendar control enables users to view and select dates. Users can switch between different views such as month, week, and day. Additionally, the selected date can be displayed on other controls within the form, such as Textbox or Label. Activation of the calendar control can occur either by selecting a date directly on the control or by setting a value through a rule. 

Properties 

Here is the list of properties that are available.

S.noProperty nameData typeDescription
General
1Date FormatStringAllows a user to select the different date formats.
2Display Event Time Displays event time.
3Calendar NavigationStringSets the value to the control in the navigated form.
Style
4WidthStringSets the suggested width or thickness of the control.
5HeightStringSets the suggested height of the control.
6MarginStringSets the edge or outer margin to the control.
7FontStringSets the font face\style.
8Custom Font Enables custom font.
9Font ColorStringSets the Text color of the control.
10Background ColorStringSets the Background color of the control.
11VisibleBooleanSets the visibility of the control while rendering.
12Border StyleBooleanSets the border style.
13BorderBooleanSets the border.
14PaddingBooleanSets the padding for the calendar.
15Column SpanStringTo merge the number of columns specified.
Rules
16Rules

After selecting the control, if the user clicks on the Rules tab, it will expand and display a Rules property. The “Create Rule” option can be selected from a drop-down list. Clicking on the “Create Rule” link button will navigate the user to the Rules Engine. The same control will be added as a trigger by default to execute the Rule.
 DataSource
17Items

Clicking the Browse button for the items will open a data source window.
Reports
18Control Report

Selecting the Control Report option will redirect to the Reports tab, which will display all configurations, rules, and data source details associated with the selected control.
Template
19Inherit Template

To set templates with styles, users can select one template at a time.
Custom Style 
20CSS Class

Users can apply CSS classes.
  

Quick Action Menu 

The Calendar control will include three Quick Action menus: Control, DataSource, and Rules/Attributes.

Rules

Here is the fundamental list of properties that can be utilized from rules.

Action –        This displays the last action performed on the calendar trigger.

                       For instance: “MessageBox(Calendar1.Action)”

Month –       To display the month of the selected date.

                       For instance: “MessageBox(Calendar1.Month)”

Year –           To displays the year of the selected date

                       For instance: “MessageBox(Calendar1.Year)”

Date –          To displays the date selected in the calendar control

                      For instance: “MessageBox(Calendar1.Date)”

Event Id –    To displays the event id of the selected event in the calendar control

                      For instance: “MessageBox(Calendar1.EventId)”

Event –        To displays the event selected in the calendar control

                      For instance: “MessageBox(Calendar1.Event)”

DataSource

Step:1 To configure the data source on the calendar, follow these steps:

1. Click on the calendar control.

2. Select ‘New DataSource Configuration’.

Step:2 Choose any data source type. In this case, I am selecting the item source as ‘MS SQL’.

Step:3 Select the DataSource. For instance, here ‘AppformsQA_Resh’ is selected, then click the Next button.

Step:4 After clicking ‘Next,’ a list of all tables available in the selected database will be displayed. Select the table or tables from the list, then click ‘Next’.

Step:5If multiple tables are selected, establishing relationships is mandatory. The selected tables must be available for relationship configuration. Then, click the ‘Next’ button.

Step:6Choose the columns to be displayed from the selected tables, and then click ‘Next’.

Step:7 If necessary, you can set the criteria for populating the search by clicking ‘Add.’ The first dropdown will contain all the column names from the selected list, the second dropdown will contain a list of applicable operators for criteria satisfaction, and the third autocomplete field will display the control name from which the list value is to be obtained. Click on the ‘+’ icon to add more criteria. After setting the criteria, click on the ‘Next’ button.

Step:8If required, you can sort the results (ascending/descending) by selecting the column. After sorting, click the ‘Next’ button.

Step:9Click on ‘Add Trigger’ to automatically create a rule for initiating the fill of the calendar control based on the provided criteria. Select a trigger and click on ‘Create Rule’ to generate a rule with a specific trigger.

Step:10Click on ‘Finish’ to complete the calendar configuration. The created rule can be viewed from the ‘Rule’ tab, along with the provided trigger.

Step:11Go to form preview.

Calendar Navigation

Step:1 Navigate to the ‘Property’ section; here, you can observe calendar navigation options.

Step:2 Click on the settings icon; this will display the calendar navigation form.

Step:3 In the Calendar Navigation form:

1. Choose any form.

2. Select the Target Field Name and Source Field Name.

3.  After selecting the Target Field Name and Source Field Name, click the ‘Add’ button to include    multiple Target Field Names and Source Field Names.

4. After adding them, click the ‘OK’ button to preview.

Step:4 In the preview, if any value is selected in the calendar, that value can be seen in the target field of the selected form for navigation.