Universal Annotations and Dynamic Field Configuration

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
Sunday, January 31, 2010PrintSubscribe
Universal Annotations and Dynamic Field Configuration

We are announcing immediate availability of two new features in Web Site Factory and Data Aquarium Framework premium projects. The features are included in the latest release of the product and are available to all subscribers to the Premium Projects.

Universal Annotations

This feature allows end users to extend any data records exposed by your application with custom annotations and attachments. Users can activate this feature on demand and enter notes and attach any number of files. The notes and attachments are stored outside of the application database in a specified folder.

You can activate this feature for the entire application or for individual data controllers.

The live demo is available at http://dev.codeontime.com/demo/annotations/pages/customers.aspx.

Click on the link above and sign in as admin/admin123% or user/user123% . Select any customer record and press edit button. Action Annotate will become available on the action bar of the form.

image

Click on Annotate button and the screen will transform as follows. New category Notes and Annotations is dynamically added to the form layout.

image

Enter a note and attach a few files. The screen will transform into the following. The category Notes and Attachments will move to a dedicated tab. Each note and attachment are presented as fields of the data record.

image

This feature requires no coding and may prove to be invaluable when end users are in the need of custom fields that were not incorporated in the database by design.

Note that users in role Administrators are allowed to add and delete notes and attachments. All other roles are only allowed to add new notes and attachments . Every note and attachment label incorporates the user name, email, and time-stamp.

Dynamic Field Configuration

Dynamic field configuration allows to provide data-driven run-time properties of individual data fields.

Here is the dynamic configuration of ProductName field in Products data controller.

image

Expression HeaderText=CategoryCategoryName will force the Data Aquarium Framework to use the name of the product category as the HeaderText of the field.

You can see this in action at http://dev.codeontime.com/demo/annotations/pages/products.aspx.

The grid view automatically uses the category name of the first record on the page or the category name of the selected product as a header text of the first column.

image

The same affect is taking place when you view your data in a form.

image 

You can override dynamically many properties of any field in a data controller through stored or calculated database table columns any properties of the fields in a given row. Open ~/App_Code/Data/DataField.cs(vb) to see available data field properties.

image

Dynamic field configuration is a great addition to the arsenal of developers building extensible data driven applications.