Data Field Categories

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
Saturday, August 23, 2008PrintSubscribe
Data Field Categories

Data Aquarium Framework forces you to break down the data fields displayed in form views into categories. At least one category must be present in any form view.  A form view is displaying a single record at a time, when  users are viewing, editing, or creating a new record. Here is an example of the customer form view in application generated from Northwind database. A single category Customers includes all data fields.

image 

Let's create a few categories to better present the fields and make it easier to work with customer records.

Open ~/Controllers/Customers.xml file, locate view editForm1 and change the data field categories as follows.

<view id="editForm1" type="Form" commandId="command1" label="Review Customers">
  <headerText>Please review customers information below. Click Edit to change this record, 
    click Delete to delete the record, or click Cancel/Close to return back.</headerText>
  <categories>
    <category headerText="Customer Code and Name">
      <description>Customer number is a five-character long field. Please use upper case 
      letters only and try to create an abbreviation from the full customer company name.</description>
      <dataFields>
        <dataField fieldName="CustomerID" columns="5" />
        <dataField fieldName="CompanyName" columns="40" />
      </dataFields>
    </category>
    <category headerText="Contact Information">
      <description><![CDATA[Contact information including contact name, title, customer 
        phone number and fax must be entered. Please use our 
        <a href="http://company/policies" target="_blank">policies and procedures</a> 
        when verifying phone and fax number. It is <b>your responsibility</b> 
        to follow the company procedures in all interactions with customers.]]> </description>
      <dataFields>
        <dataField fieldName="ContactName" columns="30" />
        <dataField fieldName="ContactTitle" columns="30" />
        <dataField fieldName="Phone" columns="24" />
        <dataField fieldName="Fax" columns="24" />
      </dataFields>
    </category>
    <category headerText="Delivery Address">
      <description>Customer address, city, region, postal code, and country must be recorded 
        in this section. Please make sure to verify the customer address with atlas of 
        commercial deliveries.</description>
      <dataFields>
        <dataField fieldName="Address" />
        <dataField fieldName="City" columns="15" />
        <dataField fieldName="Region" columns="15" />
        <dataField fieldName="PostalCode" columns="10" />
        <dataField fieldName="Country" columns="15" />
      </dataFields>
    </category>
  </categories>
</view>

Select and edit the same record in customer grid view. Your form will look like the one below.

image

Data field categories provide a convenient tool to organize data fields in a form view and provide rich HTML instructions to application users.