Blog

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, May 4, 2013PrintSubscribe
Tools for Excel: Controls

This is a typical view of controls in a project.

Typical view of controls in a project.

Consult the following table when entering property values:

Property Description
ID The unique identifier of the control.
Container The container that the control belongs to.
Page The page that the control belongs to.
User Control The user control that will be instantiated.
Activator Specify a method to access the data view in Activator property. The available options are Tab, Side Bar Task, and Site Action.
Text Specifies the text displayed on the activator.
Sequence Specifies the order that the user control will be placed in.
Saturday, May 4, 2013PrintSubscribe
Tools for Excel: User Controls

This is a typical view of user controls in a project.

Typical view of user controls in a project.

Consult the following table when entering property values:

Property Description
Name Specifies the name of the user control.
Prefix Specifies the prefix of the user control.
Generate Specifies when to re-generate the user control.
Body Specifies the user control markup.
Saturday, May 4, 2013PrintSubscribe
Tools for Excel: Data Views

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

Typical view of data views in a project.

Consult the following table when entering property values:

Property Description
Activator Specify a method to access the data view in Activator property. The available options are Tab, Side Bar Task, and Site Action.
Auto Hide

Property Auto Hide specifies which user interface element will be hidden if filter value is empty.
Self will hide just the data view. Container hides the entire container that the data view resides in (including all other data views in the container).

Auto Highlight First Row Auto Highlight First Row will automatically select the first row in the grid view.
Auto Select First Row Auto Select First Row will automatically execute the first action in the action group with the scope of "Grid".
Container The container that the data view belongs to.
Controller Specifies the controller that the data view will display.
CSS Class Name Property CSS Class Name will be assigned to the div element on the page that represents the data view.
Filter Field 1 Enter the first field that will limit the visible data.
Filter Field 2 Enter the second field that will limit the visible data.
Filter Field 3 Enter the third field that will limit the visible data.
Filter Field 4 Enter the fourth field that will limit the visible data.
Filter Field 5 Enter the fifth field that will limit the visible data.
Filter Source

Enter the master data view in Filter Source.

ID The unique identifier of the data view.
Multi Select Enable Multiple Row Selection by setting Multi Select to "Multiple".
Page Size

Specify the number of data rows displayed in Page Size.

Refresh Interval Refresh Interval specifies how many seconds will pass before the data view is refreshed. If blank, the data view will not refresh automatically.
Roles Enter a comma-separated list of Roles to that will have permission to view the data view.
Search by First Letter Property Search By First Letter enables a dynamic menu of first characters above the "grid" views.
Search On Start Enable Search On Start if you want non-form views to display an automatic search bar instead of the first page of data. Use Search Mode properties of view's data fields to control the contents of the search bar.
Sequence Specifies the order that the data view will be placed in.
Show Action Bar

Unselect Show Action Bar to hide the action bar.

Show Action Buttons Specify where the action buttons are displayed using Show Action Buttons.
Show Description Unselect Show Description to hide the view description on the page.
Show Details in List Mode When property Show Details in List Mode is enabled, child views will be refreshed when a row is selected in the grid. When disabled, child views will be refreshed when opened in the form.
Show In Summary

Select Show in Summary to include data fields of the view in the summary properties displayed on the side bar.

Show Modal Forms

Show Modal Forms will force any actions that bring up a form to have the form displayed in a modal form. If the option is not selected then the form will be in-line.

Show Page Size Unselect Show Page Size to hide the page size section at the bottom of the data view.
Show Pager Unselect Show Pager if you want to hide the pager area of the data view.
Show Quick Find Property Show Quick Find controls if the Quick Find search box is displayed on the action bar.
Show Row Numbers Enable Show Row Numbers to display row numbers on the left side of the data view.
Show View Selector

Unselect Show View Selector to hide the view selection dropdown on the right side of the action bar.

Start Command Argument Specifies an argument for the startup action.
Start Command Name This action is executed as soon as data view has been initialized on the page in a browser. Only New, Edit, and Select actions can be executed.
Tag Use Tag to enabled conditional controller actions with matching whenTag property and to write custom business rules specific to tagged data views.
Text Specifies the text displayed on the activator.
Transaction Specify if transactions are supported in this data view.
View Specifies a view to display from the specified controller. If left blank, the first view will be used.
Visible When Enter JavaScript expression in Visible When if you want a conditional display of the view on the form. Use the word Master to reference the data view specified in the Filter Source property of this data view.