Calendar

It is a form tool that allows you to see the calendar in daily, weekly, monthly, and calendar types when placed in the form.

c1.png

‘’Calendar’’ icon at Toolbox

 

  mceclip0.png

How it looks like on the Canvas

 

Compatibility

Free Form Responsive Form Mobile
icons8-check-circle-48.png icons8-check-circle-48.png icons8-cancel-48.png

 

 

Remarks

To use this toolbox, you must open form one more. Calendar edit form should be because there is an Edit Form area in the Calendar toolbox. Edit Form must have - person, start date, finish date, and heading - areas.

 

Properties

  • Name: The name of the field is written.

  • User List: Whether the user list is displayed horizontally or vertically is selected.

  • Edit Form: Which form to open in the calendar is selected.

  • User: The user field is selected in the selected form.

  • Heading: The title field is selected in the selected form.

  • Start: Start date is selected in the selected form.

  • Finish: The end date is selected in the selected form.

  • Start-Stop Hour: Its default value is week. You can leave it blank.

  • Time Interval (Min.): Specifies the time selection between the given start and end dates.

  • Help Text: It is the text that is entered for comment when the mouse is placed on the Calendar control.

  • Height / Width: Adjusts the height and width of the Calendar tool (The width field has been removed from Responsive Forms).

  • From Left / Top: Adjusts the distance of the Calendar tool from the left and top (This field has been removed from responsive forms).

  • User Query: You must write ID, name, and color for the user. You can use XPODA_CLIENT_USERS table. (as UserID, UserFullName and UserColor columns)

  • Data Query: For instance; if you want to use two users, this area is written a table with view or function.

  • Show All Day: If "Yes" is selected, it shows the entire 24-hour time zone.

  • Fit Horizontal: Fits the tool to the full screen on the user’s screen.

  • Display: Makes the Calendar tool not appear on the screen.

 

Actions

  • When the value changes: Assign an “Action” as on value changes handler. For more information please click here.

 

Example Used

To start changing the Calendar, a new form is opened as Edit. This contains elements for User, Heading, Start, Finish areas.

In below,  there are User, Start Date, End Date, and Topic areas in the form named CALENDAR_EDIT.

c3.png

Client view on screen

 

Now, go back to the form with the calendar. Change its properties.

c4.png


User SQL Query is written as UserID, UserFullName, and UserColor to see it on the calendar.

c5.png

 

As the last step, to see the modifications, trigger the Calendar toolbox with when the form is opened event and Update Value operation.

c6.png

mceclip1.png
Client view on screen

--------  --------  --------  --------  --------  --------  --------  --------  --------  --------  --------  --------

 

 

Appearance in Toolbox

Appearance in Free Form

 Appearance in Responsive Form

mceclip0.png

 mceclip1.png mceclip2.png

 

Compatibility

Free Form Responsive Form Mobile
icons8-check-circle-48.png icons8-check-circle-48.png icons8-cancel-48.png

 

Features of The Calendar Tool

Type: Indicates the field type of the added form tool. The value cannot be changed.

Name (): 

mceclip3.png

 

List users (): 

mceclip4.png

 

Edit Form (): 

mceclip5.png

 

User (): 

mceclip6.png

 

Heading (): 

mceclip7.png

 

Start (): 

mceclip8.png

 

Finish (): 

mceclip9.png

 

Start-Stop Hour (): 

mceclip10.png

 

Time-Interval(Min) (): 

mceclip11.png

 

Help Text(): 

mceclip12.png

 

Height (): 

mceclip13.png

 

User Query - Sql Server (): 

mceclip14.png

 

Sql Query - Xpoda Addon (): 

mceclip16.png

 

Data Query (): 

mceclip17.png

 

In the Data Query query, the calendar task can be colored according to the status in the edit table.

Example query;

SELECT CASE WHEN TaskType='new' THEN 'blue' ELSE 'green' END AS EventColor

Note: If datasource is used in the calendar, there must be UserTableID, FormTypeID, ProjectID in the data source section for the edit feature to be active and the table of the edit form must be in the same module as the calendar. In your query, the selected values in the User, Heading, Start and Finish fields must be added to the query with the same name.
If a datasource query is created from a form in a different database or application, the calendar edit feature cannot be used here. Only when it is in the same module or the datasource field is empty, the edit feature can be used.

select
UserTableID,
FormTypeID,
ProjectID,
User AS FormField_User,--it must be int and exists XPODA_CLIENT_USERS
Heading AS FormField_Heading,--it must be nvarchar value
Start as FormField_Start,--it must be date or datetime
Finish as FormField_Finish,--it must be date or datetime
from MASTERTABLE

UNION ALL

select
0 AS UserTableID,
0 AS FormTypeID,
0 AS ProjectID,
UserID AS FormField_User,--it must be int and exists XPODA_CLIENT_USERS
Description AS FormField_Heading,--it must be nvarchar value
StartDate as FormField_Start,--it must be date or datetime
FinishDate as FormField_Finish,--it must be date or datetime
from TEMPTABLE

 

Show All Day ():

Fit Horizontal :Fits the form tool horizontally to the full screen on the user's screen.

Display : Makes the form tool not visible on the Client screen.

 

There are no actions to use inside the calendar widget.