Date Time and Check Box in User Defined Tables

Date, Time and Checkbox

· User can define Date, Time and Checkbox options while defining the table.

· Follow the same steps to Define Table as in this Example

Step 1: Defining in User Defined Table

· Click on Add icon to include columns.

· User can add columns both in Form View or Grid View. Gird View helps users to add multiple columns at a time.

· Fill in the fields as shown below.

· Give a check box to the Status column. To give a check box, the Data type should be nvarchar. Fill Drop Down Value as ‘checkbox’ [all small letters]. Column Length should be 1.

· For the Order Date column, select cas Data Type and fill Drop Down Value as ‘DateTime [all small letters]. In this option, the user can add both the Date and time.

· User can enter only Time by filing ‘time’ in Drop Down Values. The data type remains the same as DateTime.

· For the Sellable column, Select data type as nvarchar and fill Default Value as False. In the actual Table, the Sellable column will fill ‘False’.

Add the values and save the changes.

Step 2: View Result

· Clear Cache after any changes made in the User Defined Tables.

· Go to User Tables --> Sample Table Name.

· Click Add Icon to add new Items to the Table.

· Fill in the fields, tick the checkbox of Status, select the date and time of Order Date and Sellable is False by default. Add it.

· Similarly, add a few more Items to the Table.