Hour

It is the tool that allows us to see the hour in the form.

Hour tool icon at Toolbox

How it looks like on the Canvas

Compatibility

Free Form	Responsive Form	Mobile

Remarks

It is a tool used to enter data into the fields that indicate the hour you use in your table. It has the datetime () data type. However, a field created by selecting the hour tool is registered to the database in the format DD.MM.YYYY HH: MM: SS (01.01.2019 10:56:14) as in the date-hour tool. If only the hour information is required in the field where the data will be used, a convert is required.

CONVERT (VARCHAR, Data to be converted (Field Name), 108)

The SQL query written above converts the data to be retrieved from the hour field to the format where the only hour is displayed. This is indicated by the 108 formats in the query

Properties

• Name: The name of the tool will be written here.

• Default Value: The value entered here comes into the tool l by default. If you want to enter data as the default value, you can write in the Default Value part. It fills the date area on the client screen.

• Text Size: Sets the size of the tool.

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

• Icon: Select the icon, color, and position to be added to the tool.

• Text Fonts: Allows you to change the font.

• Text Type: Adjust the type of text like bold, italic, underlined, and replaces the text as right-aligned, left-aligned, or centered.

• Color: Edits the color of inside the tool and/or the text inside the tool.

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

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

• Linked Object: Links to an object element created by action. When the object element runs, the information is filled in according to the object area.

• Linked Object Area: Selects the fields within the linked object area.

• Tab Order: Specifies the order of the tool within the form.

• Time Interval (Min.): Sets the minute interval of the time zone.

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

• Pin Right: Pins the tool to the right.

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

• Form Only: The information entered in the tool is not saved to SQL, but only in form.

Actions

• On Focus: Assign an “Action” as on focus handler. 

• On Blur: Assign an “Action” as on blur handler. 

• When the value changes: Assign an “Action” as on value changes handler. 

• Keyboard Input: Assign an “Action” as on keyboard input handler. 

• Validation: Assign an “Action” as on value tool handler. 

• Calculate: Assign an “Action” as a calculate handler for the grid tool. 

• Icon Clicked: Assign an “Action” as click handler for the icon.

Examples Used

When the form is opened you want to specify the first value, you can change the Default value area. For example; to make “00:00”  an hour, it is written in this area.

Client view on screen