Designer

Labels
AJAX(112) App Studio(9) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(178) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(184) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(3) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Designer
Saturday, September 29, 2012PrintSubscribe
Changing the Number of Columns of a Radio Button List

Lookup fields configured as a Radio Button List will have a single column by default. In the example below, the Employee Last Name lookup is a single-column radio button list.

Employee Last Name lookup field configured as a single column radio button list.

Let’s configure Employee Last Name with multiple columns.

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.

EmployeeID data field node of 'editForm1' view in Orders controller.

Change the Columns property:

Property New Value
Columns 3

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

Navigate to the Orders page, and edit a record. The radio button list for Employee Last Name field will be rendered in three columns.

Employee Last Name lookup field configured as a three column radio button list.

Saturday, September 29, 2012PrintSubscribe
Changing the Width of a Data Field

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.

Employee Last Name 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.

EmployeeID data field node in 'editForm1' view of Orders controller.

Change the Columns property:

Property New Value
Columns 15

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.

Employee Last Name field takes less horizontal space.

Friday, September 21, 2012PrintSubscribe
Duplicate Action

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.

Duplicate action for context menu of a row in Employees grid.

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

New Employees form with values populated from the duplicated record.

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.

New Action context menu option for action group 'ag1' in the Project Explorer.

Assign the following values to the new action:

Property Value
Command Name Duplicate
Command Argument grid1
Header Text Duplicate in Grid

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.

New action 'Duplicate in Grid' under context menu for row in Employees grid.

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

New row created with values from the duplicated record.

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.

New Action context menu option on action group node 'ag8'.

Assign the following values:

Property Value
Command Name Insert
When Last Command Name Duplicate

Click OK, and create another action:

Property Value
Command Name Cancel
When Last Command Name Duplicate

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.

Duplicated row now has 'Insert' and 'Cancel' actions.