Blog: Posts from April, 2012

Labels
AJAX(112) App Studio(7) 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(177) 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(183) 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(2) 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
Posts from April, 2012
Tuesday, April 17, 2012PrintSubscribe
Configuring Row Selection Mode for the Entire Application

The default configuration of a Code On Time web application is to allow a selection of a single data row on all pages. The screen shot below demonstrates a single row of Suppliers selected in the Northwind sample.

Data row 'Selection Mode' is set to 'Single' in the data view of suppliers in a Code On Time web application

You can enable a multiple row selection on all application pages as follows.

Select the project name on the start page of the application generator and choose Settings.

Select Features in the menu of settings. Activate feature group Grid Properties.

Toggle “on” the option Enable multiple selection in all grid views and click Finish button.

Enabling multiple row selection in all data views on a Code on Time web application

Select Refresh option to refresh the project settings. Click Refresh button without selecting any data controllers.

Press Generate to have the application reconfigured with the new feature. The default web browser will display the application.

Now you can select multiple data rows in all application data views presenting lists of records.

Multiple row selection mode enabled in a data view of a web app created with Code On Time web application generator

Note that only intrinsic Delete action and batch update support multiple row selection.

You can create custom business rules or an SQL action to implement business logic applicable to multiple selected data rows.

You can also enable multiple row selection on individual page data views.

Monday, April 16, 2012PrintSubscribe
Opening a Lookup Window in Search Mode

Lookup windows can display the first page of data, or present search options instead upon activation.

In a sample Northwind application, navigate to Orders page. On the action bar, press New Orders. Click the (select) link in the first data field, Customer Company Name.

Customer Company Name lookup link on New Orders form

The lookup window will show the first page of data rows. The default page size is ten.

Default Customer ID lookup window in Code On Time web application

A user can perform Quick Find or activate the advanced search bar to narrow down the list of available data rows.

Advanced search bar in the lookup window

Let’s activate the search mode immediately when the lookup window is displayed for the first time. This will be useful if the number of lookup records is large. The display of the first page of data has little use in such cases.

Start Code On Time web application generator, click on the project name, and select Design. In the Project Explorer, switch to Controllers tab. Double-click on Orders / Fields / CustomerID node.

Scroll down to the Lookup section. Toggle the checkbox next to Search On Start property.

'Search On Start' property enabled for CustomerID field in Code On Time Designer

Press OK to save the field. On the tool bar, press Browse to generate the application and open it in your default web browser.

Navigate to the Orders page, and create a new order. Activate the Customer Company Name lookup, and you will see the lookup window open in advanced search mode.

Lookup window opened in advanced search mode

Enter the search parameters and press Search to find a record. Alternatively, you can just press the Search button without entering any search parameters, and a full list of customers will appear.

List of records pulled in Customer ID lookup window

Monday, April 16, 2012PrintSubscribe
Giving Instructions on a Lookup Window

Lookup windows have descriptive text that can be used to explain to end users what is supposed to be selected.

Let’s use a sample Northwind web application. Navigate to the Orders page. On the action bar, press New Orders. In the first data field, click on the (select) link.

Customer Company Name lookup activation link in New Orders form

A lookup window will open. The generic description for this lookup is “This is a list of customers”.

Customer ID lookup window with default description text

Let’s change this description to be more specific and understandable for the end user in this lookup context.

Start the web application generator, click on the project name, and press Design. In the Project Explorer, switch to Controllers tab. Double-click on Orders / Fields / CustomerID node.

Customer ID field under Controllers tab of Code On Time Project Explorer

Scroll down to the Lookup section. In the Lookup window description property, enter:

Please select the customer placing this order.

Lookup window description property populated

Press OK to save the field. On the tool bar, press Browse to generate the application and open it in your default web browser.

Navigate to the Orders page. Create a new order, and open the lookup for Customer Company Name data field. The lookup window description is now matching the text provided earlier.

New lookup window description displayed in lookup window