Calendar View, Mini-Calendar, Multi-Select, Responsive Grid with Auto-Balancing, Hyperlinks, Multi-Column Sorting

Labels
AJAX(112) App Studio(8) 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(184) 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, September 6, 2015PrintSubscribe
Calendar View, Mini-Calendar, Multi-Select, Responsive Grid with Auto-Balancing, Hyperlinks, Multi-Column Sorting

We wanted to share with you that Iron Speed, Inc. has discontinued operations. Diligent developers have surely tried Iron Speed Designer and for various reason have turned to Code On Time instead. Read our comment about Iron Speed to learn more. We are charging ahead - expect to be amazed!

Calendar view style

Code On Time update 8.5.5.0 introduces a brand new view style into the already potent mix of visualization methods available to end users of Touch UI. View style Calendar brings a whole new level of interactions with data. Drag & drop is fully supported with numerous enhancements planned ahead. Take a look at the Calendar and other view style supported right now.

Calendar view style in Touch UI

The following tags allowing controlling otherwise fully automatic display of Calendar view style:

  • calendar-date will mark a particular data field as start date or “general” date of event. An event is a database row with a date column.
  • calendar-end specifies the “end” date of the calendar event. Mark a field as “end” date to allow “resizable” events.
  • calendar-text specifies the field value displayed on the event
  • calendar-color specifies option “color” source for the events. For example, an order event can be presented with a different color for each employee associated with it. 24 standard colors are supported.
  • calendar-disabled excludes “date” field from being displayed on the calendar.

Mini-Calendar

A permanent sidekick called mini-calendar is display on the sidebar whenever at least one data field is available to the user. Mini-calendar filters data in all data views and serves as a navigator in Calendar view.

Mini-calendar filters data displayed in Charts view style in the app with Touch UI

Other highlights include responsive grid with auto-balancing, multi-column sorting, and support for Hyperlink Format String property in Touch UI.

Multi-Select

Ability to select multiple rows is now fully supported in Touch UI in Grid, List, and Cards view styles. End user can select up to a 1000 items at once.

Multi-select in the grid view style in the app with Touch UI

Responsive Grid with Auto-Balancing

The responsive Grid view style has been redesigned and now support auto-balancing of data.  Notice that the data is densely distributed on the screen. Built-in screen-size breakpoints automatically reduce the number of fields visible to the user .

Responsive grid view style with auto-balancing in the app with Touch UI

Application framework uses these breakpoints:

  • tn (tiny) – 480px
  • xs (extra small)  - 768px
  • sm (small) – 992px
  • md (medium) – 1199px
  • lg (large) – 1440px
  • xl (extra larget) – anything larger than 1440px

If you want to ensure that a particular data field is display on a tiny screen in Grid view style than tag it as “tn-grid”. The framework will automatically take core of the remaining fields.

Hyperlink Format String

Touch UI now supports hyperlink format strings. Field will be displayed as underline if a hyperlink is present. Context menu will display items for every field with a hyperlink even if it is not visible in the current view style.

Hyperlinks in the app with Touch UI

Multi-Column Sorting

End users are now able to perform sorting on multiple columns.

Multi-column sorting in an app with Touch UI

Other Enhancements

The release also introduces numerous enhancements to both Touch and Desktop UI.

  • High performance reading of many-to-many fields. Framework performs a single database request per many-to-many field to retrieve junction table rows that match the rows of the data page that will be returned to the client. (Desktop and Touch)
     
  • Authorized roles can be assigned to individual data views in SPA applications (Desktop and Touch).
     
  • Import processor assigns the same default values to all imported rows (Desktop and Touch)
     
  • Aggregates are now calculated on result sets based on stored procedures and web services. (Desktop and Touch)
     

  • SQL Business rules allow clearing "Modified" property of field values as follows
      set @FieldName_Modified = 0

    Application framework will not use the field in update/insert/delete operation.
     

  • Single Page Applications allow anonymous calls to data controllers.
     

  • Relationship Explorer links now use shortcuts for data controller URL parameters _commandName and _commandArgument. The new syntax uses _command and _argument.
     
  • HTML page implementation is now also supported in Relationship Explorer links.
     
  • “Borrowed” blob fields are correctly displaying a thumbnail in Touch and Desktop UI
     
  • Touch UI allows right-click of items in all view style with ability to perform quick filtering.
     
  • Paging is now supported in “Summary” presentation in Touch UI.
     
  • Touch UI memorizes tab selection for the last 10 objects on any given page.
     
  • DACL correctly processes parameters @BusinessRules_, @Url_, and @Session_.
     
  • Fixed issue with Oracle Session State throwing "Value does not fall within the expected range".
     

Coming Next

We are bring a controller-level Data Model in the Project Designer. You will be able to set up your own tables, columns, and relationships instead of relying on the app generator to do so. This will give complete GUI-based control over the command and fields in the application baseline.

Also Expect a mini-calendar to become a part of Desktop UI. This handy feature work similar to its counterpart in Touch UI.

Mini-calendar in the upcoming revision of Desktop UI