Code On Time: COT Tools for Excel

Wednesday, May 1, 2013Print Subscribe

This is a typical screen displaying views in a project.

Consult the following table when entering property values:

Property	Description
Base View Id	Specify a Base View Id to inherit its data fields, categories, description, and label.
Command	Specifies the command that will be used to select data.
Controller	Specifies the controller that the view belongs to.
Filter Expression	Filter Expression must be compatible with the back-end database server syntax. Data field names used in filter are automatically expanded into appropriate SQL expressions as defined in command.
Group	Enter any non-blank value in Group property to make sure that filters selected in a view are transferred to the other views in the same group when a user selects them in view selector.
Header Text	Specifies the text displayed above the view in the user interface.
ID	Specifies the unique identifier of the view.
Label	Specifies the text displayed in the view selector dropdown.
Report Font	Property Report Font will determine the size of text for the data and labels in the report. The default value is Medium.
Report Label	Specify a Report Label that must print when a view report is produced in PDF, Excel, TIFF, or Word format. If the property left blank then the view label will be printed.
Report Orientation	Set Report Orientation to "Portrait" or "Landscape" or let the application to decide what is best.
Report Template	Indicate if a custom report template file must be created for this view. The report in RDLC format can be customized in Visual Studio or Visual Web Developer. The file name will be formatted as [Controller]_[ViewId].rdlc.
Override When	Override When is an expression that evaluates to true or false. It is written in the programming language of your project.
Show in Selector	If disabled, the view will not be displayed in the view selector dropdown.
Sort Expression	Sort Expression is a list of data field names of this view, each followed by optional asc or desc suffix.
Type	Type determines the presentation style. Available types include form, grid, chart, or data sheet.
Virtual View ID	The specifiedVirtual View ID will replace the current view when the condition in Override When is met.

Labels: Application Builder, COT Tools for Excel, Tutorials, Web Application Generator

Monday, April 29, 2013Print Subscribe

Tools for Excel: Fields

This is a typical view of commands in a project.

Consult the following table when entering property values:

Property	Description
Activate If Blank	Specifies that the lookup will be activated when the value is blank.
Allow Nulls	Specifies that the field can blank.
Calculated	Specifies that the the field value is produced by a business rule method. Context fields must be specified to cause the calculation.
Code Default	Specifies the default value that will be applied when the new record form is opened.
Code Formula	Specifies a formula written in the programming language of the project that will return a field value.
Code Value	Specifies a value that will be calculated every time the record is updated.
Computed	Specifies that the field is not physically present in the table.
Context Fields	Specifies which fields, when changed, will cause calculated fields to be refreshed.
Controller	Specifies the controller the field belongs to.
Copy	Specifies a list of fields that will be copied from the selected lookup item.
Data Format String	Specifies the data format string for the value. Available strings are:Standard Numeric, Standard Date/Time, Custom Date/Time, HTML.
Data Text Field	Specifies the field that will be displayed to the end user.
Data Value Field	Specifies the field value that will be saved.
Default	Specifies the default value that will be applied when the record is saved.
Dynamic Configuration	Specifies fields that can provide dynamic values for the field properties.
Edit Mask	Specifies an edit mask that will validate the entered field value.
Editor	Specifies the name of a custom editor.
Field Name	Specifies the name of the field.
Format On Client	When disabled, specifies that the server will format the field using the supplied data format string.
Hidden	Specifies that the field is hidden in the user interface.
HTML Encoding	Specifies that the field value will be displayed in full. When disabled, HTML in the field will be rendered.
Items Data Controller	Specifies the controller that will be used to look up data.
Items Data View	Specifies the view of the controller that will be used to look up data.
Items Style	Specifies the style that will be used to display items.
Key	Specifies if the field is the primary key. The client library uses the primary key to select, update, and delete data.
Label	Specifies the label that will be displayed in the user interface.
Last Entered Value	Specifies that the most recently entered value by the user will be the default value for the next record. Simplifies mass entry of records with values that are not expected to change frequently.
Length	Specifies the length of the field.
Lookup Description	Specifies a description on the lookup window.
Mask Type	Specifies the type of edit mask to be used.
New Data View	Specifies the view that will be used when the New Record icon is selected. If blank, the icon will not be displayed.
On Demand	Specifies that the field requires special handling.
On Demand Handler	Specifies a name for an automatically created handler that will retrieve the blob field.
On Demand Style	Specifies the method used to display the blob field. Available options are thumbnail and link.
Page Size	Specifies the number of items displayed in the lookup view.
Query-by-Example	Enables advanced filtering options for the field in grid views.
Read Roles	Specifies which roles are permitted to view the field.
Read-Only	Specifies that the field is read-only.
Search by First Letter	When enabled, displays quick first letter filters at the top of the lookup view.
Search on Start	Specifies that the lookup view will have advanced search bar open by default.
Show In Summary	Specifies that the field will be displayed in the summary when a record is selected.
Sorting	Enables sorting for the field in grid views.
Source Fields	Specifies primary key fields that uniquely identify the source record.
SQL Formula	Specifies a formula computed on the server that will return the field value.
Target Controller	Specifies the controller data will be saved to when the field is configured as many-to-many.
Type	Specifies the data type of the field.
Write Roles	Specifies which roles are permitted to edit the field.

Labels: COT Tools for Excel, Tutorials, Web Application Generator

Monday, April 29, 2013Print Subscribe

Tools for Excel: Commands

This is a typical view of commands in a project.

Consult the following table when entering property values:

Property	Description
Controller	Specifies the controller that the command belongs to.
Event	Specifies Event that will cause the command to execute. Note that the only supported command type for Select commands is Text.
ID	Specifies the ID of the command.
Table Name	Specifies the table name that must be used at runtime in automatically constructed insert, update, and delete data manipulation operations.
Text	Specifies the text of the command.
Type	Specifies the Type of the command.

Labels: Application Builder, COT Tools for Excel, Web Application Generator