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)
Thursday, November 16, 2017PrintSubscribe
Peformance Improvements and Notifications

Code On Time release brings a significant improvement in the data processing framework and the new feature Notifications in Touch UI.

Performance Improvements

This release will speed up data interactions of the application framework with your database. Application always counts the number of available rows whenever your access any data for the first time. It uses an SQL query to count the total number of records to perform data paging when needed. Subsequent retrieval of pages of data does not require record counting. Starting with this release, the initial counting has been eliminated when only a small number of records available for retrieval. 

The change in the implementation will provide performance gains of up to 25% or more. This applies both to Classic and Touch UI when you re-generate your project.

Forms with the large number of static lookups (Drop Down List, Radio Button List, List Box) will see a significant boost.


Action notifications provide and effective method of confirming user actions without stopping the flow of user interactions with the app. Fleeting messages are displayed at the bottom of the screen to inform the user about data manipulations. Custom notifications can also be displayed when needed.

Custom action notification displayed in th app with Touc UI created with Code On Time.

Other Features and Ehancements

Popups is the standard feature of Touch UI. We display options with choice for dropdown menus, context menus, etc. Previous implementations have blocked user interaction with app until the popup is dismissed with Esc key or when the user clicks/taps outside.

The new release significantly modifies this behavior for end users working with the mouse. The drop downs on menu bar will automatically open when user hovers over. The entire toolbar set of elements is fully responsive when any popups are open. If the “mouse” user clicks ouside of the boundaries of the popup, then the user interface will respond. Use Esc key or click on static elements of GUI to prevent interactions and close the popup instead.

Users of touch screen will see no change in the behavior of popups.

This modification makes Touch UI behave in a mouse-friendly way.

Touch UI is now even more "mouse-friendly" than ever.

The styling of Calendar view has been changed.

New peresentation of the Calendar view style.

Previously a popup with a card representing the selected event has opened when the event was clicked or tapped on. Now the first available action is executed instead.

Clicking on the event in the Calendar view style will execute the first available action.

The up/down/right arrows in the lookups are now appearing larger as we are switching to material icons.

Material icons are now used in the implementation of right/down/up arrows in lookups.

Other notable changes:

  • Calendar view style is correctly rendered for dataview fields in modal forms.
  • Method DataView.findAction will return null if an empty path is specified.
  • TimeSpan fields can be passed to SQL business rules.
  • Increased speed of $settings method when verifying touch-settings.json variables on the client.
  • Popup menus dropped from the menu bar will auto-select on hover faster than when a standard popup menu is opened for improved user experience on mouse-pointer devices.
  • We have removed "apple" trick for numeric inputs. The numeric input type implemented through native HTML input for numbers will be replaced with the custom keyboard in the next release.
  • Surveys allow unlimited text input in multi-line string fields. This fixed the problem with Batch Edit form and multi-line fields.
  • BatchEdit correctly clears selected key list (checkboxes) after successful execution.
  • BatchEdit displays system notification about the number of updates items.
  • Method $app.execute now returns a "deferred" object to allow "done", "then", and "fail"
  • Methods $app.alert and $app.confirm now return "deferred" object to allow "done", "then", "fail".
  • If $settings('') == 'sidebar' then content pages display with a sidebar.
  • Added integration with Offline Sync to provide "cloud" icon
  • Event "before[panel-type]" event provides "panel" property with "type" and "id". List of items is in "items" property of event.
  • Calendar View now supports the following tags:
    • calendar-day(-disabled)
    • calendar-week(-disabled)
    • calendar-month(-disabled)
    • calendar-year(-disabled)
    • calendar-agenda(-disabled)
  • Calendar now runs first action in Grid scope instead of showing card, handles double click, fixed offset color boxes, month events no longer grow.
  • Core.css now contains glyphicons for Classic UI.
  • Fixed issue (again) where ASPX projects navigate to "/login" instead of "/login.aspx".
  • Fixed issue with server authentication generating incorrect code.
  • Added URL Decryption in @Url_XXX SQL business rule parameters.
  • Internal static page references will open in fullscreen mode when accessed from a non-modal page.
  • Static page navigation uses promises when making remote calls.
  • Integrated initial daf-odp.js into the framework and setup.
  • Flag mobile.busy is set to the same value as dataView._busy argument to ensure global “gray glass pane” on top of the GUI.
  • Auto-open menu options on hover.
  • Deleting and retyping incorrect unmatched value does not clear the selection in the drop down list.
  • Enhanced auto-completion of text in Lookup/AutoComplete/DropDownList. BackSpace and Del buttons do not cause auto-completion.
  • Fixed the typo in the label reference. It is again possible to access Sort, Filter, and Group menu options in the context menu.
  • Advanced Search now works with the data controllers based on rowsets created with the business rules.
  • Fixed. Group BY is not supported with controllers using DataTable for resultset.
  • Synchronization of Distinct page requestes performed by advanced search form is disabled to improve performance.
Tuesday, November 14, 2017PrintSubscribe
Configuring SMTP Settings

In order to send emails from within your web app, the SMTP web.config settings must be configured. For example, the automatic password reminders sent by ASP.NET membership require an SMTP configuration.

Start the web app generator, and click on the project name.

Starting in release, the SMTP settings can be configured. Select “Settings”, choose “Features”, and switch to “SMTP Configuration” section to define your SMTP settings.

Select Settings, and click on Web Server Configuration option.

In the Web.Config modification instructions text box, insert your configuration. Model it after the sample displayed below:

InsertAfter: /configuration/connectionStrings
      <smtp deliveryMethod="Network" from="">

Press Finish, and regenerate the web app. The SMTP settings have been added to the web.config file and emails will now work as intended.

Learn more about configuring email settings.

Wednesday, November 8, 2017PrintSubscribe
Announcing Custom Native Apps and Offline Sync Add-on

Code On Time release is expected to be available December 22, 2017. See our current roadmap at

With this release, will make it possible to download custom Windows 7 native client for your app based on embedded Chromium browser. The second option is a custom Universal Windows App for distribution via Microsoft Store. Both options will be available directly in the Publish screen of the app generator. We are also introducing a new product to enable “always offline” mode in those apps!

In a world where apps are everywhere, it makes sense to package your application in a native shell on all platforms, be it Windows, iOS, or Android. Such shell must not merely provide a custom online browser. The shell must host a local set of client-side application files while using the server components of the app to read and write data. This will not only increase speed of page loading (all required files are already on the device), but will also enable access to the device equipment and make it possible to work in a disconnected mode.

Custom Native Apps

Presently, the app generator offers a number of Publish options for deployment to a web server. After an application is published for the first time, an “App Store” option is displayed. The option is not implemented in the current release.

Generator will display “App Store” option on the Publish screen as soon as you publish your application to any of the supported targets (Azure, File System, FTP, etc). Deployed application is available on internet and native apps can access services provided by the server components of the app.


The Publish / App Store option will be expanded to allow getting access to the native implementation of the app for each supported mobile platform. The initial implementation will offer two options:

  • Mobile App for Windows - this is a customized version of the Universal Mobile App based on embedded Chromium browser (CMA-W7). Developers will be able to download the installation package for the app directly. Unlimited Edition users will have an option to download the source code as well

  • Universal Windows App - this is a customized version of the Universal Mobile App for Windows 10 and 10S (CMA-10). Developers will be able to download the installation package for Windows App Store. Unlimited Edition users will be able to download the source code as well.

Follow up releases will make available similar options for Apple iOS, Google Android, and Apple MacOS. We are hoping to complete support of the other mobile platforms by the end of March 2018. See the roadmap for details.

    Offline Sync Add-on

    Offline Sync Add-on makes its appearance in this release. The add-on will be available for purchase at The purchase will be delivered to you as a zip file with the name “”. Copy the zip file to ~/Documents/Code OnTime/Addons folder. The application generator will automatically expand the contents of the file when the app is generated.

    Installed addon will enable “always offline” mode in your application. Any pages marked for offline will magically become fully autonomous. The relevant data will be downloaded when application is installed on the native device. Any data modifications will be executed locally while requests to change data are logged and saved. User interface will expose Sync option in the menu. If synchronization is requested, then the log of changes will be submitted to the application server and requests will be executed as a single transaction. If there were no errors, then the transaction is committed. Otherwise, the user will have the option to reconcile issues for each individual error and attempt to resubmit the entire change log.

    Here is a screenshot on app with Offline Sync Add-On installed. The tablet-sized screen will display synchronization status icon as a cloud in different states. In this case, all data is downloaded and there are no pending changes.


    User can access “Sync” option in the context menu of their app shown next. This option is always present in the app enhanced with Offline Sync Add-On. It provides additional settings such as automatic synchronization.


    See the roadmap for more details about offline features.