Data Sheet View

Labels
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)
Archive
Blog
Monday, April 25, 2011PrintSubscribe
Data Sheet View

Code On Time applications now offer a new exceptional feature that allows spreadsheet-style presentation and editing of multiple records.

You can enable the data sheet view if you change the type of your grid view from “Grid” to “Data Sheet”. Start the web application generator, select the name of your project, click “Design” button, select a data controller, and activate “Views” tab. Change the type of view grid1 to “Data Sheet”.

image

Generate your application and navigate to the page that presents the data controller views. Click once on any cell in the data sheet view. The header of the column will get highlighted. You can now start using the keyboard to navigate between cells.

image

Press Down key until you reach the last visible row on the page. Press Down key one more and observe how the rows shift.

Start typing in any cell to edit the data, press F2 key to start editing, or click Del to clear the contents of the cell. The row will switch in edit mode. Any business rules that work with grid views will continue to work with the data sheet view. Use Tab and Shit+Tab keys to navigate between cells in the edit row. Use mouse to click on arbitrary cell in the edit row to active the cell.

image

Hit Enter key to save the row. Enter and Shift+Enter keys will navigate down and up in the data sheet view when not in edit mode.

Press Insert key to create a new row or simply navigate beyond the last row in the data sheet view.

image

Press Esc to exit edit/new mode.

Press Esc if you want to stop using keyboard with the data sheet view. The cell focus will disappear.

Conclusion

Data Sheet view will offer a new rapid data entry method for your end users. We are planning to offer a code generator option that will make the Data Sheet view a default presentation for grids of data.

Excellent cross browser support will bring Microsoft Excel and Microsoft Access desktop experience of interacting with data to the web.

Data Sheet view is available only in Premium and Unlimited editions. View Code On Time product edition pricing at http://codeontime.com/buy.aspx.  The upcoming updates will include new additional view types such as tree view and calendar view.