Form Navigator

AJAX(112) Apple(1) Application Builder(242) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) 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(11) 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) DotNetNuke(12) EASE(20) Email(6) Features(99) Firebird(1) Form Builder(14) Globalization and Localization(6) Hypermedia(2) Installation(4) 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(15) OAuth(5) OAuth Scopes(1) OAuth2(6) Offline(14) Oracle(10) PKCE(1) PostgreSQL(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(163) Reports(48) REST(26) RESTful(21) RESTful Workshop(13) RFID tags(1) SaaS(7) Security(75) SharePoint(12) SPA(5) SQL Anywhere(3) SQL Server(26) Stored Procedure(4) Teamwork(15) Tips and Tricks(81) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(331) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(39) Web.Config(9) Workflow(28)
Thursday, October 28, 2010PrintSubscribe
Form Navigator

User interaction with a list of data records typically involves applying filters and culminates in a selection of a record. Next, user will either change the record or return to the original list of records to make another selection.

How many times have you felt the need to advance to the next or previous record while the form is selected? Do one really need to use a grid to make a selection of another record?

Most applications do not support record navigation in a form. The reason is simple enough. The grid view manipulates pages of records using record count and absolute page indexes. The form view is using the primary key of a selected record to retrieve the data.

Code On Time applications now offer form navigator to offer both navigation and key-based selection in form views.

You can see the live demo at Sign in as admin/admin123% and select a supplier record. Navigation buttons with arrow icons are displayed above and below the record.


Click on the buttons to advance to the next and previous records. Form navigator automatically uses the filters and sort order of the grid view that has activated the form. Any detail views in master-detail relationships are also automatically refreshed.

The feature works in modal forms as well. You can try modal form navigation at


The form navigator is activated automatically if more than one record is available in a grid view. Navigation arrows will disappear if a user is looking at a single record in a dataset or if a user is creating a new record.

If your application is using Override When, Filter, and Sort Expression view properties to create role-sensitive view filters then make sure that the same filter and sort expression is applied to forms that are used to edit data. Read more about role-sensitive views at /Documents/CB%20-%20Row-Level%20Security.pdf and