COT Tools for Excel

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

This is a typical view of categories in a project.

Typical view of categories in a project.

Consult the following table when entering property values:

Property Description
Collapsed Will render the category as collapsed by default if set to Yes.
Controller The controller that the categories’ view belongs to.
Description The text displayed under the header.
Floating You can force the category data fields to float from left to right by setting Floating to Yes.
Header Text The text displayed at the top of the category.
ID The unique identifier of the category.
New Column If attribute New Column is set to Yes then the category is rendered in the new column.
Tab Specifying the tab will display a bar of tabs above the view and will make the category visible only when the tab is selected.
View The view that the category belongs to.
Visibility Enter a JavaScript expression in Visibility field to allow conditional display of the category. The expression must evaluate as true if the category is visible. Use square brackets to reference the data field values in the expression.