Blog: Posts from May, 2013

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 May, 2013
Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Actions

This is a typical view of actions in a project.

Typical view of actions in a project.

Consult the following table when entering property values:

Property Description
Action Group The ID of the action group that the action belongs to.
Causes Validation When Causes Validation is enabled, the form will be validated when the action is activated.
Command Argument The Command Argument is used to modify the command. For standard Select, Edit, Update commands, specifying a view Id will perform the action in that view. For other actions, the argument can be used as a tag.
Command Name The Command Name determines the behavior that will occur when the action is activated. If command name is not specified then the action is presented as a break line in the action group popup menu.
Confirmation When not blank, Confirmation will display a confirmation window with the specified text. It may also used to call a modal form.
Controller Displays the parent controller.
CSS Class Specify a CSS class to assign to the action.
Data

Specify Data for the SQL, Report, or or Custom action. Application framework will use this information when processing the action.

Description The Description will be displayed under the Header Text on actions in a menu on the action bar.
Header Text The Header Text will be displayed on the action. If not specified, the Command Name will be used.
ID The unique identifier of the action.
Roles List roles allowed to execute this action in Roles. Role check is performed on the server and precedes the action conditions.
When Client Script When Client Script is a JavaScript expression that will display the action if it evaluates to true.
When HRef When HRef will display the action when the specified regular expression matches the page URL. If you would like to have a negative match then put "false:" without double quotes in front of the expression.
When Key Selected If When Key Selected is enabled, the action will only displayed when a record is selected.
When Last Command Argument When Last Command Argument will only display the action if the previous action has the specified command argument.
When Last Command Name When Last Command Name will only display the action if the previous action has the specified command name.
When Tag When Tag will display the action when the view Tag is matched by the regular expression.
When View When View will display the action when the regular expression matches the view.
Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Action Groups

This is a typical view of action groups in a project.

Typical view of action groups in a project.

Consult the following table when entering property values:

Property Description
Controller The data controller that this action group belongs to.
Flat Rendering Flat Rendering will display actions as individual items on the action bar. When disabled, they will be rendered in a dropdown menu.
Header Text

The Header Text is displayed when the group is rendered in a menu.

ID The unique identifier of the action group.
Scope

The Scope determines the location and presentation of the action group.

  • Grid scope actions are displayed in the context menu of a grid.
  • Action Column scope actions are displayed in an action column on a grid.
  • Form scope actions are displayed in the action buttons row of a form.
  • Action Bar scope actions are displayed on the action bar of views of any type.
  • Row scope actions are displayed under a selected row in a grid view.
Wednesday, May 1, 2013PrintSubscribe
Tools for Excel: Data Fields

This is a typical view of data fields in a project.

Typical view of data fields in the project.

Consult the following table when entering property values:

Property Description
Aggregate

Specify an Aggregate that will be displayed at the bottom of grid views.

Alias The Alias is the field value that will be displayed to the user. The header text will be inherited from the alias field label.
Auto Complete Prefix Length Specify an Auto Complete Minimum Prefix Length greater than 1 to enable auto-complete on the data field.
Category The category that this data field belongs to.
Chart If the view is a chart, specify a Chart property that the data field will function as.
Code Filter Specify an operator for the Code Filter to determine how records will be restricted from being displayed.
Controller The controller that this data field belongs to.
Columns Columns determines the width of the data field. If the field is a radio button list or check box list, this will determine the number of columns.
Data Format String Specify a Data Format String to format the field value before it is presented to the user.
Field Name The name of the field that is instantiated.
Footer Text Displayed under the field in the form.
Filter Expression Write a Filter Expression in the programming language of your project. Code Filter must be specified.
Format On Client If Format On Client is disabled, the server will format the field using the specified data format string.
Header Text Replaces the name of the field in the form.
Hidden Enable to hide the field from the user interface.
Hyperlink Format String The Hyperlink Format String allows formatting the field as a link. Specify an absolute or relative (starting with ~) URL that may include field names enclosed in curly brackets. You can place _blank or any other standard window name followed by colon symbol in front of the URL.
Read Only If Read Only is enabled, the data field will not be editable in the user interface.
Read Only When Read-Only When is a JavaScript expression that will enable editing on the data field when it evaluates to true.
Rows Rows determines the height of the data field or list box.
Search Mode The Search Mode property will control the behavior of the data field in the advanced search bar.
Search Options Search Options represent the options available for searching the field in the advanced search bar. You can limit or reorder the search options. Search options must be compatible with the data type of the field. Separate options with "," or list one option per line. Examples: $contains, =, $between, >, $future.
Tag Use the Tag property to define enhanced business purpose of the data field.
Text Mode

Text Mode will determine how the text box is rendered. Password will render the field value as asterisks. Rich Text will enable rich text editing on the field value. Note allows easy editing of long field values. Static will display the field as read-only, but still send the field value to the server.

Tool Tip Tool Tip is displayed when user mouses over the input box or text.
View The view that this data field belongs to.
Visible When Visible When is a JavaScript expression that will display the data field when it evaluates to true.