Features

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
Features
Sunday, April 29, 2012PrintSubscribe
Feature: Automatic Denormalization

Code On Time application generator performs automatic denormalization when constructing application data controllers from tables of a normalized database.

Consider the following subset of tables from the Northwind sample.

Normalized tables Products, Categories, and Suppliers

Product information is stored in three tables. Normalized table Products replaces category and supplier information with ID of data rows stored in Categories and Suppliers tables.

If you run the sample application then the Products page will be presented in a denormalized user-friendly fashion.

Denormalized presentation of products includes category and supplier information

You can control the inclusion of fields in the data controllers with the help of denormalization field map.

Friday, April 13, 2012PrintSubscribe
Creating Permanent Links to Data Records

Application users have an easy way of exchanging links to data records in Code On Time web apps. This feature can be enabled in the project settings.

Start creating a sample Northwind web application. When you reach the Features page, switch to the Permalinks and History section using the box on the left side of the screen. Toggle the checkbox next to “Enable permalinks to allow bookmarking of master records selected by end users”.

'Enable permalinks to allow bookmarking of master records selected by end users' property enabled in Code On Time Project Wizard

Press Next until you reach the Themes page. Select “Ricasso” theme.

'Ricasso' theme selected in Code On Time Project Wizard

Continue configuring settings and generate the web application. When it loads in your default web browser, switch to the Products page. Select any product from the list.

Product selected on Products page in web application generated with Code On Time

In the top left corner of the page, click on Permalink.

Permalink link in top left corner of Code On Time web application

A textbox will appear to the right of the link, showing the permalink to the selected record. If you mouse over the link, it will show you the Product information also shown in the Summary on the side bar. You can email or instant message this link to anyone.

Activated permalink in Code On Time web application

The button immediately to the right of the textbox will add the link to your bookmarks.

Adding a permanent link to a data record to the web browser bookmarks

A user will be required to log in to the web application, when attempting to access the URL of the permanent link.

User is required to log in to view the data record referenced by the permalink

If the user logs in with a valid account, and the access control rules permit the user to view the record, then the record will be displayed.

Data record referenced by a permalink

Friday, April 13, 2012PrintSubscribe
Permalinks Feature

Often, multiple users may need to provide a link or bookmark to a specific record. Code On Time applications offer the ability to create permanent links for a record.

First, you need to select a record.

Selected employee record in Code On Time web application

In the top left corner of the page, click on the Permalink option.

Permalink option on membership bar of a Code On Time web application

A textbox will appear to the right side of the link, containing the URL (permanent link) for the record. If you mouse over the permalink, you will see information about the record matching the info provided in the Summary area on the left side of the page. You can copy this link to the clipboard and share it with anyone via email or an instant messaging service.

Permalink created for selected record in Code On Time web application

The icon immediately to the right of the textbox allows you to add the link to your Bookmarks.

Add Permalink to Favorites

You can close the permalink textbox by either clicking on Permalink again or selecting the the far right Close icon.

Closing the Permalink textbox in Code On Time web application

If you access the permalink via bookmark or click on one received from another application user, you will see the following prompt to log in to the web application.

Log in prompt in Code On Time web app

The application will automatically redirect you to the correct page and select the record, provided that you have permission to access the application and see the data.

Permalinked record displayed after log in to web application

You can enable Permalinks in the Project Wizard.