Designer

The Columns property allows specifying the width of a data field.

For example, the Employee Last Name field in Orders edit form has been configured as an Auto Complete lookup. Note that the field takes up a lot of horizontal space.

Let’s reduce the width of the field.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab and double-click on Orders / Views / editForm1 / c1 – Orders / EmployeeID data field node.

Change the Columns property:

Press OK to save the data field. On the toolbar, press Browse.

Navigate to the Orders page and edit an order. The Employee Last Name field will take up the specified number of logical columns.

The duplicate action allows the user to create a new record using the values of an existing record.

Duplicate in Form

Applications generated with Code On Time will have the Duplicate action available in the context menu of a row in grid view.

When the action is selected, createForm1 will be activated. Values from the duplicated row will populate the fields.

The default Duplicate action is configured to use createForm1 view as an argument.

Duplicate in Grid

Let’s create a Duplicate action that will create a new row in grid view.

Start the Project Designer. Switch to the Controllers tab in the Project Explorer. Right-click on Employees / Actions / ag1 (Grid) action group node and press New Action.

Assign the following values to the new action:

Press OK to save. On the toolbar, press Browse.

Navigate to the Employees page and activate the context menu for a row. Click on Duplicate in Grid.

A new row will be created with the same values as the selected row.

Note that there are no Insert or Cancel actions available. You will need to add these actions with When Last Command Name of “Duplicate” in order to allow the user to save or cancel the record.

Adding Insert and Cancel actions

In the Project Explorer, right-click on Employees / Actions / ag8 (Row) node, and press New Action.

Assign the following values:

Click OK, and create another action:

Press OK to save. On the toolbar, press Browse.

Navigate to Employees page, and select the Duplicate in Grid action from the context menu. The new row will now have Insert and Cancel actions underneath.