Blog: Posts from June, 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 June, 2012
Sunday, June 3, 2012PrintSubscribe
Configure Notes

When a text field contains many lines of information, the value will be truncated in read mode, such as the Notes field in the picture below.

Notes field of Employees edit form string data truncated in read mode.

The entire text can be displayed if the Text Mode property of the data field is set to “Note”.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Double-click on Employees / Fields / Notes field node.

Notes field of Employees controller in Code On Time Project Explorer.

At the top of the Designer window, switch to the Data Fields tab. Make the following changes to each data field:

Property New Value
Cols 100
Rows 10
Text Mode Note

Notes data fields with '70' columns, '10' rows, and Text Mode of 'Note'.

Save the data fields, and click Browse on the tool bar.

When the web application opens in your default browser, navigate to the Employees tab and view an employee record. The entire text of the field is displayed.

Notes field of Text Mode 'Note' not truncating string data in read mode.

Press Edit. The text will not immediately become editable – instead, two links will appear underneath.

When the form is in edit mode, a Notes field will display two links to edit and delete.

If you click on the edit link, the text will become editable. If you click on the delete link, the field will be cleared.

Clicking on edit under a Notes field will allow the user to edit the note.

Sunday, June 3, 2012PrintSubscribe
Configuring a Rich Text Box

Memo (long text) fields are presented as a simple multi-line text box by default. For example, Categories.Description field is rendered as a multi-line text box in the image below.

Description field on Categories edit form rendered as a simple text box.

Rich text editing can be enabled when necessary.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Double-click on Categories / Fields / Description field node.

Description field of Categories controller in the Project Explorer.

At the top of the Designer window, switch to the Data Fields tab. Change the Text Mode property of all data fields:

Property New Value
Text Mode Rich Text

Change all Categories data fields to Text Mode of 'Rich Text'.

Save your changes, and click Browse on the tool bar.

When your default web browser opens, navigate to the Categories page and edit a record. Now rich text can be entered into the field. The application client library uses ASP.NET AJAX Rich Text Editor when rendering rich text fields.

Rich Text editor enabled on Description field of Categories edit form.

Make some “rich” changes to the field value, and save the record. The field value will be displayed in grid view with the styles preserved.

Description field value rich text styling preserved in grid view.

On the action bar, select Report | PDF Document option, and open the downloaded file. The styling will be preserved in the generated report as well.

Description field value rich text styling preserved in a PDF report.

Friday, June 1, 2012PrintSubscribe
Configure a Static Text Box

In some situations, it may not be wise to allow the user to change certain fields, even though they are updatable. For example, when creating an order detail in a Northwind web application, the Unit Price should be copied from the selected Product. Users should not be allowed to alter the Unit Price.

Order Details create form in Code On Time web application.

If you mark the field as read-only, then it will not be written to the database when the record is saved. Change the Text Mode property of the field to “Static” if you don’t want the users to edit the value but still want the field value saved to the database.

Start the Project Designer. Double-click on Customers / Order Details / container1 / view1 / createForm1 / c1 – New Order Details / UnitPrice data field node.

UnitPrice data field in createForm1 on OrderDetails page of Project Explorer.

Change the following property:

Property New Value
Text Mode Static

Press OK to save the data field. Next, we’ll need to copy the Unit Price from Products to Order Details.

In the Project Explorer, double-click on Customers / Order Details / container1 / view1 / createForm1 / c1 – New Order Details / ProductID / ProductID field node.

ProductID field from the Order Details controller in Project Explorer.

Make the following change:

Property New Value
Copy UnitPrice=UnitPrice

Press OK to save the field. On the tool bar, press Browse.

When the web application opens in the browser, navigate to Order Details page and create a new record. The Unit Price data field is no longer editable by the end user.

Unit Price field on New Order Details form is not editable.

Select a Product using the Product Name lookup. The Unit Price will be copied over into the order detail.

When Product is selected on New Order Details form, the Unit Price is copied over.