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
Sunday, April 15, 2012PrintSubscribe
Automatic Display of Lookups

In some situations, you may want to streamline selection of lookup values when users are entering or editing data. For this purpose, lookup fields in Code On Time web applications have the “Activate If Blank” property. If this property is enabled, whenever a user opens an edit view and the lookup is blank, then the lookup window will activate automatically.

Let’s use an example. Create a sample Northwind application. Select the project name on the start page, and press Design.

In the Project Explorer, switch to the Controllers tab. Double-click on Orders / Fields / CustomerID node.

CustomerID field in Code On Time Project Explorer

Scroll down and toggle the checkbox next to “Activate If Blank”.

'Activate If Blank' property enabled in Code On Time Designer

Press OK to save the field.

Enable “Activate If Blank” for EmployeeID and ShipVia fields using the same method. Make sure to save each field. These fields will be activated in the order of the data fields in the view.

Select Browse on the tool bar to generate and open the application in your default web browser. Navigate to the Orders page. On the action bar, press New Orders.

The Customer ID lookup will automatically be activated, as the field is blank.

CustomerID lookup window activated when the field value is blank

Select a customer, and the Employee ID lookup will pop up right away.

Employee ID lookup window activated when the field value is blank

When you select an employee, then the Ship Via lookup will appear.

Ship Via lookup window activated when the field value is blank

This behavior will occur when you edit or create order records that have blank lookup fields, including inline edit or new modes in grid views.

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.