Release Notes

This page lists the major changes in each release of AppSynergy.

Release v152 (January 2025)

• New application specific app manifest.
• Better notification of expired login sessions.
• Miscellaneous bug fixes and smaller improvements.

Release v151 (December 2024)

• Auto Delete Expired Invites. App invites that are not accepted within 7 days are now deleted.
• Revised task queue implementation.
• Miscellaneous bug fixes and smaller improvements.

Release v150 (October 2024)

• New Sign In Options. We now support signing in with a Google Account, a Microsoft Account, or a native AppSynergy account. The AppSynergy account supports optional 2-step verification using the authenticator app of your choosing.
• Miscellaneous bug fixes and smaller improvements.

Release v149 (September 2024)

• New 2024 Style Sheet with Dark Mode. This style sheet now also contains Dark Mode support. If your device preferences are set to dark mode, this style sheet will automatically switch to dark mode.
• Miscellaneous bug fixes and smaller improvements.

Release v148 (July 2024)

• Direct Edit of Field Tab Order. You can now directly edit a field's position in the tab order by double-clicking its tab index on the inspector.
• Improved AppSynergy API documentation. Check it out here.
• Miscellaneous bug fixes and smaller improvements.

Release v147 (June 2024)

• Phone Number formatting. There is now a standard function to format North American phone numbers into a consistent style. See documentation here.
• New Database Email Routing Option. You can now set up a personalized email address on your own domain and route it to your database email address. See documentation here.
• Miscellaneous bug fixes and smaller improvements.

Release 146 (May 2024)

• AS2 Send and Receive. Enterprise Edition customers now have access to their own dedicated AS2 server for electronic data integration (EDI) with trading partners. This fully managed server implements the EDIINT AS2 standard, offering extensive configurability and support for various signing and encryption algorithms. They also support compression, HTTP/HTTPS transmission, and message disposition notifications (MDNs) for receipt confirmation.
• Speed improvements. On average a 3x improvement in the time required to load large database schemas. Significantly faster table creation and modification for situations where the change does not require checking existing apps for potential modification. Application of native roles after a schema change is now also up to 10x faster.
• Miscellaneous bug fixes and smaller improvements.

Release 145 (May 2024)

• SFTP Upload and Download. Intended for lightweight EDI purposes. You can now upload any generated text (e.g. an X12 file) or any document, image or signature from your database to a trading partner via SFTP. You can also download files. See documentation here.
• Miscellaneous bug fixes and smaller improvements.

Release 144 (April 2024)

• YourAccountId@dbmail.appsynergy.com You can now send email to your database by including your database email address in the To, Cc or Bcc lines of any email. You can find your Account ID via Help > About. See docs here.
• Miscellaneous bug fixes and smaller improvements.

Release 143 (March 2024)

• Image Serving URLs. This is the first version of AppSynergy to use the new Cloud Storage based image thumbnail process.
• Miscellaneous bug fixes and smaller improvements.

Release 142 (February 2024)

• parasql_http() This new stored procedure makes it easier to perform RESTful API calls from your PL/SQL code. See the documentation here.
• Improved PDF Form Filler. The PDF Form Filler allows you to complete a PDF form with data from your database. The API now returns the fully qualified names of all the fields in the PDF (regardless of how deeply they are nested). See the documentation here.
• Support for database SEQUENCEs. A database SEQUENCE is a native MariaDB alternative to AppSynergy's built-in AutoKey datatype; both generate sequential numbers for use with primary keys. AutoKeys are easier to use and manage, however certain integration scenarios may benefit from the use of SEQUENCEs. As of this release SEQUENCEs are shown in green on the palette. Documentation for SEQUENCEs is here. You can create and manage SEQUENCEs via Tools > SQL Console. You can then place a formula on a field to generate the next sequence value like this:
  parasql.app.execSQL('SELECT NEXTVAL(MySEQ) AS SEQ', function(results) { parasql.app.getWidgetById('ID12345').setDataValue( results.getValue(0,'SEQ') ); })
• Miscellaneous bug fixes and smaller improvements.

Release 141 (January 2024)

• Chart Settings > Advanced Options now revert to their previous value if new, invalid options are entered by mistake.
• Miscellaneous bug fixes and smaller improvements.

Release 140 (November 2023)

• Miscellaneous bug fixes and smaller improvements.

Release 139 (September 2023)

• Upgrade to MariaDB v10.11. The most notable new features are:
  • Backup & Restore capability for Audit Trail history records. Since AppSynergy v73 you have been able to optionally enable the Audit Trail feature on a table-by-table basis. Enabling the Audit Trail instructs the system to automatically keep track of all changes by saving timestamped history records; this allows you to query the database AS OF a specific timestamp to see what it looked like at that point in time. However, prior to v139, Audit Trail history records could not be backed up which limited their usefulness in certain production systems. As of AppSynergy v139 history records are now included in the nightly backups, and these backups can be restored if needed.
• Miscellaneous bug fixes and smaller improvements.

Release 138 (August 2023)

• Two new 2023 Style Sheet variations (Grape and Lime) to provide a refreshed look for your applications. Be sure all widget settings in your app are set to Theme Default for the style to truly show through. If you select the top-most tab or menu object in your app and choose Format > Apply Theme Defaults all widgets under the selected tab or menu, not just the tab or menu itself, will have their defaults reset to the theme default. Also be sure to apply the CSS styles save and cancel to the Save and Cancel buttons respectively on your modal panels to fully utilize the new style sheets (via Format > CSS Style...).
• Public apps with a fixed-width app canvas (the default) now center horizontally within the browser like non-public apps.
• Miscellaneous bug fixes and smaller improvements.

Release 137 (July 2023)

• Improved Printing. Fixed a bug that would sometimes cause data to be cut off when printing a multi-page report.
• Improved embedded app styling. You can now also customize the embedded app container with CSS.
• Miscellaneous bug fixes and smaller improvements.

Release 136 (June 2023)

• New AppSynergy 2023 style sheet. Significant improvements in default color scheme for Modal Panels that have master-detail style layouts using tabs.
• Rewrite of internal Datastore architecture.
• Miscellaneous bug fixes and smaller improvements.

Release 135 (April 2023)

• Upgraded to Google App Engine Java 17 environment.
• Fewer App Reload Required messages.
• Added support for improved printing on certain mobile devices.
• Miscellaneous bug fixes and smaller improvements.

Release 131 (March 2023)

• Formatted Notes Field - Dynamic Toolbar. If Dynamic Toolbar is enabled then a field's text formatting toolbar is only displayed while the field is being edited. The dynamic toolbar is enabled by default for newly created fields. You can toggle this feature on/off for older fields via Format > Dynamic Toolbar.
• Miscellaneous bug fixes and smaller improvements.

Release 130 (February 2023)

• Miscellaneous bug fixes and smaller improvements.

Release 129 (January 2023)

• Fast Record Append. Appending a new record no longer forces redisplay of the other records in the list.
• Better handling of broken database VIEWs. Fixing a broken view no longer destroys references to it.
• Persistent SQL Console. The SQL Console now persists its contents for a given user on a given machine.
• Miscellaneous bug fixes and smaller improvements.

Release 128 (December 2022)

• Native Barcode Scanning on Android Mobile Devices. The new BarcodeScannerPanel class enables native 1D and 2D barcode scanning by using the camera on your mobile device. Currently only Android mobile devices are supported.
• QR Codes. The BarcodeField class can now render QR codes. Barcodes are also now their own icon on the palette.
• Discard Changes. Record objects now have a Discard Changes action available. Useful for building better Cancel button behavior.
• Mobile menus now render the selected option name in the title area.
• Improved copy and paste between applications. Invalid hard references are now removed when pasting between apps.
• Miscellaneous bug fixes and smaller improvements.

Release 127 (November 2022)

• Improved printing:
  • You can now print an object located within a Modal Panel.
  • You can now print a Box object (with Container Options > Display > Flex Container) as a means of printing more complex reports with headers and footers.
  • Various smaller visual improvements.
• Miscellaneous bug fixes and smaller improvements.

Release 126 (October 2022)

• Ability to reorder Button Actions.
• Ability to reorder Data Links.
• Improved Data Link efficiency.
• Miscellaneous bug fixes and smaller improvements.

Release 125 (September 2022)

• New Application API method DataWidget.getFirstValue(tableName, columnName) that returns an equivalent value to the @FirstValue() token. Note that as with @FirstValue() the UI event triggering the code can only reach down a single level in the parent-child record nesting hierarchy.
• Fixed issue with Custom Filters on mobile devices.
• Miscellaneous bug fixes and smaller improvements.

Release 124 (August 2022)

• You can now share an application directly from the Start page (i.e. without first editing the app).
• parasql.util.getMachineId() A new API function that returns a pseudo machine id that should be stable across sessions with the same browser/machine combination.
• Miscellaneous bug fixes and smaller improvements.

Release 123 (July 2022)

• The Last Executed time is now shown on the Scheduled Events panel; this only applies for automatically executed events, not those executed via Run Now.
• Miscellaneous bug fixes and smaller improvements.

Release 122 (June 2022)

• Auto Round Calculated Numbers A new setting under File > App Settings... forces automatic rounding on calculated numeric fields such that the stored number of decimal places matches the displayed number of decimal places.
• parasql.util.round(num, places) A new utility function to round a number to the specified number of decimal places.
• Miscellaneous bug fixes and smaller improvements.

Release 121 (April 2022)

• New parasql_blob_get() Function. A new PL/SQL function called parasql_blob_get() makes it easier to extract the constituent parts from a blob field (e.g. Document Field, Image Field, Signature Field). For example, parasql_blob_get(MySignatureField, 'latitude') would return the latitude where the signature was captured.
• REST API action HTML2PDF "makePublic" option. You can now specify that the PDF file created by this API call is made public upon creation. This allows anyone with the URL to access the document without a digital signature.
• Miscellaneous bug fixes and smaller improvements.

Release 120 (March 2022)

• @NewPrimaryKeyFor(T.C) New formula token allows you to generate a primary key value for a specific base table. Useful when inserting records into a database VIEW that has a base table with an AutoKey column for its primary key.
• Miscellaneous bug fixes and smaller improvements.

Release 119 (March 2022)

• Code Search. Via Tools > SQL Console... you can now search across your entire PL/SQL code base in one step (i.e. search across all triggers, stored procedures, functions, scheduled events, and database views).
• Miscellaneous bug fixes and smaller improvements.

Release 118 (February 2022)

• MariaDB v10.6. Upgrade servers to MariaDB v10.6.x. You can see the exact version your account is currently running via Help > About. This upgrade primarily provides reliability enhancements (atomic DDL) and a very useful JSON_TABLE() function for those working with JSON data.
• Miscellaneous bug fixes and smaller improvements.

Release 117 (January 2022)

• Inbound Web Requests. You can now accept a GET or POST web request directly into your database and process it with a trigger. Documentation is here.
• Miscellaneous bug fixes and smaller improvements.

Release 116 (December 2021)

• Miscellaneous bug fixes and smaller improvements.

Release 115 (November 2021)

• parasql_code_search('Orders') A new utility procedure, accessible from the SQL Console, allows you to search across your entire code base (all triggers, routines, events and views) for a specific keyword. For example, typing CALL parasql_code_search('Customer') would return a list of all triggers, routines and events that contain that key word.
• Miscellaneous bug fixes and smaller improvements.

Release 114 (September 2021)

• Record Widget Auto Select First Record. If a Record Widget has a DataLink to a non-child widget, the first record will be automatically selected upon render. This now matches the behavior of a ReportWidget.
• New Record Widget Custom CSS class show-selection. If you are using the AppSynergy 2021 Modern CSS stylesheet, you can optionally add a show-selection style via Format > Style options.... This causes the currently selected record to be highlighted with a blue bar as its left border (same as a selected row in a Report Widget).
• My Routines. When editing SQL the three-dot menu now includes a My Routines menu to quickly insert references to your own procedures and functions.
• Miscellaneous bug fixes and smaller improvements.

Release 113 (August 2021)

• New Format > Allow Direct Edit option. Allows direct editing of foreign key fields (i.e. does not force use of the Pick List).
• Migration to new VMs. New virtual machine builds for all database servers using the latest security hardened hardware and OS techniques. Instances with a -v10 suffix are those that have been migrated, those with a -v1 suffix will be migrated in coming weeks. The instance name associated with your account is visible on the About panel.
• Miscellaneous bug fixes and smaller improvements.

Release 112 (July 2021)

• Miscellaneous bug fixes and smaller improvements.

Release 111 (June 2021)

• New Arrange > Resize option. You can now select multiple widgets (via Ctrl+Click) and make them all the same width/height. The first widget selected determines the width/height applied to the others.
• Multicolumn Record Layout. A Record object can now be set to render in a multicolumn layout via Options > Multicolumn on the toolbar. The number of columns rendered is based on the available width vs. the width needed to render a single record. Search the AppSynergy support forum for specific usage examples.
• Miscellaneous bug fixes and smaller improvements.

Release 110 (June 2021)

• New Enabled / Disabled option. When creating a Visibility formula you can now set its behavior to either Visible / Not Visible or Enabled / Disabled. Disabled buttons cannot be clicked but are still visible. Disabled fields are made temporarily read-only. Currently only buttons and fields are supported.
• Improved Code Hints. When editing trigger code you can now type NEW. or OLD. then Ctrl+Space to choose from a list of columns in the trigger table. Likewise you can type a table name like Customers. then Ctrl+Space to choose from a list of columns in that table. If you type a partial table name like Cust then Ctrl+Space a list of tables starting with those letters will be shown (e.g. Customers, CustomerOrders, etc.).
• New CSS print Class. The CSS class name print is now added to every widget's CSS class list while printing. This allows you to customize the printed vs. on screen look of a widget.
• Improved Error Handling. When an error occurs as a result of clicking a ButtonWidget all further actions assigned to that button are halted.
• Miscellaneous bug fixes and smaller improvements.

Release 109 (May 2021)

• New CSS Theme. A new CSS theme named AppSynergy 2021 Modern is now available for use. You can apply this theme to new or existing applications.
• Fix-Width Apps. A newly created app now defaults to fixed-width. You can change the width behavior of the App Canvas to dynamic via Format > Layout....
• Miscellaneous bug fixes and smaller improvements.

Release 108 (April 2021)

• Dynamic setReadOnly. As of this release you can now dynamically change a field's read-only attribute at runtime via the API.
• Dynamic setIsRequired. As of this release you can now dynamically change a field's required attribute at runtime via the API.
• External Users. Support for designating external users via their Security Role.
• Miscellaneous bug fixes and smaller improvements.

Release 107 (April 2021)

• Icons on Tabs. You can now set icons on tabs.
• Icons on Menu options. You can now set icons on menu options.
• New Icons. On the icon panel you can now set any Material Design icon via its name.
• Miscellaneous bug fixes and smaller improvements.

Release 106 (March 2021)

• New PDF_AUTOFILL API. Use a fillable PDF as a template (say, an insurance form) and database data to generate a completely filled PDF with a single REST API call. See the documentation here.
• Miscellaneous bug fixes and smaller improvements.

Release 105 (January 2021)

• Automatic Code Completion. When editing code you can now press Ctrl-Space to get a list of auto completion hints including table names, column names and keywords. Use sometablename. Ctrl-Space to hint columns from a particular table. As you type the list of options narrows; tab or enter uses the highlighted option.
• Drag and Drop Values Between Fields. You can now designate a field widget as Draggable (via Format > Draggable) and then define another field widget as a drop target (via Format > Set as Drop Target...). This allows the user of your application to drag values from one field to another.
• Miscellaneous bug fixes and smaller improvements.

Release 104 (January 2021)

• Bulk Image and Document Import. You can now bulk import images and documents into AppSynergy Image Fields and Document Fields, respectively. Contact AppSynergy support for details.
• Miscellaneous bug fixes and smaller improvements.