Blog: Posts from August, 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(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(179) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) 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 August, 2012
Tuesday, August 14, 2012PrintSubscribe
Working with Data Fields

Data fields are bindings of fields to views.

Form views organize data fields in categories. Data fields are placed directly under the root of other types of views.

Data fields selected under c1 category of editForm1 view in the Categories controller in the Project Explorer for web applications.

Creating a Data Field

Data fields are created by using the New Data Field context menu option. For grid views, the option is available on the view node.

New Data Field context menu option on a grid view in the Project Explorer.

For form views, the option is available on the category node.

New Data Field context menu option for a category in a form view.

Data fields can also be created by dragging a field node onto the target view or category node.

Dropping a field node onto a view node in the Project Explorer.     Data field CategoryID has been created in grid1 view.

Arranging Data Fields

Data fields can be rearranged using drag and drop operations. Dropping a data field on another data field will place it after the target.

Dropping a data field onto another data field in the Project Explorer.     The data field CategoryName has been placed after data field Description.

Dropping a data field on the right side of another data field will also place it after the target.

Data field Description dropped on the right side of CategoryName data field.     Description data field node placed after CategoryName data field node.

Dropping a data field on the left side of another data field will place it before the target.

Dropping Picture data field on the left side of Description data field.     Picture data field has been placed before Description data field.

Dropping a data field on a different category within the same view will move the data field to that category.

Dropping Picture data field onto category c2 in the same view.     Picture data field has been moved into category c2.

Dropping a data field onto a different view or category will copy the data field. If the data field is already present in the view, it will be moved to the bottom of the list.

Dropping data field Picture onto view grid1.      The existing Picture data field has been moved to last in the list.

Creating Master-Detail Relationships

Dragging data fields can quickly create master-detail relationships between data views. Simply drag the foreign key field from the child view onto the master view. The relationship will be automatically configured.

Dropping a primary key data field onto the master data view.      The data views have been configured with a master-detail relationship.

Deleting a Data Field

Data fields can be removed using the Delete context menu option.

Delete context menu option for a data field in the Project Explorer.

Tuesday, August 14, 2012PrintSubscribe
Working with Data Fields in Designer

Data fields are bindings of fields to views.

In the Project Designer, data fields can be found on the Data Fields tab of a view properties page.

Data Fields tab on View properties page.

Data fields in form views can also be found on the category properties page.

Data Fields tab on category properties page.

All bindings of a field to data controller views can be found on the Data Fields tab of a field properties page.

Data Fields tab on Field properties page.

A new data field can be created using the action bar option New | New Data Field.

New Data Field action bar option in the Project Browser.

The properties of a data field can be viewed and edited by clicking on the Field Name or using context menu option Open.

Open context menu option in the Project Browser.     Data Field properties page open in the Project Browser.

The Sync context menu option will select the relevant data field node in the Project Explorer.

Sync context menu option for a Data Field in the Project Browser.     Relevant data field node selected in the Project Explorer.

Data fields can be rearranged using drag and drop operations in the Project Explorer.

EmployeeID data field dropped on the right side of OrderDate data field.     EmployeeId data field placed after OrderDate in the list of data fields in the Project Explorer.

Remove a data field by selecting Delete context menu option in the Project Explorer.

Delete context menu option in the Project Explorer.

Use Navigate To window to quickly locate data fields by their property values.

LastName data field found using Navigate To window using the search terms 'lastname editform1'.

Tuesday, August 14, 2012PrintSubscribe
Overview of Data Fields

A data field is a binding of a field to a data controller view. Only one binding of a field can exist in each view. Data fields in form views are organized in categories. The data controller will automatically bind primary key fields and alias fields to a data view if the corresponding data fields are not explicitly defined.

If the value of a field is required for a business rule implementation but should not be displayed to the user, then the data field binding must be created and marked as hidden.

If the field has read roles specified and the user is not matched to the roles, then the data field will become invisible. If the field has write roles specified and the user is not matched to the roles, then the data field will be rendered as read-only.

Data fields can be dynamically rearranged with the help of data controller virtualization.

Data Field Properties:

Property Description
Aggregate Function Specifies a function that will be performed on the rows in grid view. The value will be displayed at the bottom of the grid.
Alias Specifies an alias for the field. The alias will be used to display values. The header text of the alias will be used.
Auto Complete Minimum Prefix Length Specifies the number of letters required for auto-complete to be displayed. If less than 1, auto-complete will be disabled.
Category Displays the category Id that the data field belongs to.
Chart Specifies the role the data field will play in the chart.
Code Filter Specifies the behavior of the filter expression.
Columns Specifies the width of the data field.
Controller Displays the controller that the data field belongs to.
Data Format String Specifies a string that will be used to format the field before presentation.
Data Type Displays the type of the field.
Field Name Specifies the field that the data field will reflect.
Filter Expression Specifies when records will be displayed based on field values.
Footer Text Specifies the text displayed under the field in the user interface.
Format On Client When disabled, the server will format the field using the specified data format string.
Header Text Specifies the text displayed as a label in the user interface.
Hyperlink Format String Specifies a format string that will be rendered as a link. Field names surrounded by brackets can be used to dynamically populate values.
Read Only When enabled, users will not be able to edit the value. The value will not be passed to the server.
Read-Only When Specifies a JavaScript expression that will allow editing on the field when the expression evaluates to true.
Rows Specifies the height of the data field.
Search Mode Specifies the behavior in the advanced search bar.
Search Options Specifies the options available in the advanced search bar. From here, you can also Disable Auto Complete, Disable Multiple Values, Disable Samples, Enable Auto Complete Anywhere.
Text Mode Specifies the method used to display text values. Available options are: Password, Rich Text, Note, Static.
The field is hidden When enabled, the data field will not be displayed in the user interface.
Tool Tip Specifies text to display when the user mouses over the field.
View Displays the view that the data field belongs to.
Visible When Specifies a JavaScript expression that will display the field when the expression evaluates to true.

Learn how to work with data fields in the Designer.

Learn to drag and drop data fields in the Project Explorer.

Common Tasks:

Task Description
Configure a Password Field Learn how to configure a password data field.
Enable Rich Text Editor Learn how to enable rich text editing on a data field.
Continue to Working with Fields