Infinitely Nestable Records

Nested Relational Records

AppSynergy has the industry's most advanced relational nested record capabilities. Building editable screens that rely on multiple tables with complex relationships has never been this powerful or easy.

Records can contain scrolling lists of other records, without limitation as to depth. The records can be free-form tabular, form-like, multi-line, etc. – you have complete layout freedom. Calculated fields can occur at any level, and parents can sum over child values. Changes to child values automatically ripple through to peer, parent, and child formulas with no additional work.

The net result is that AppSynergy handles real-world business app complexity with ease.

Integrated Reporting

Integrated reporting with powerful filtering, sorting, grouping, and computed columns – including master-detail style reports. Advanced features include:

• Computed Columns with Correlated Sub-Queries
• Advanced Join Options (e.g. Inner, Left, Right).
• Data "windowing" functions for advanced analytics.
• One-click export to Excel.

Powerful cloud-based Reporting without the need for a separate solution.

Quickly build highly visual, data-rich applications.

Visualize Your Data

AppSynergy has a large assortment of ways to visualize your data and build rich interactive dashboards.

• Wide variety of chart types: bar, line, area, pie, doughnut, bubble, timeline, Gantt charts and geographic heat maps.
• Google Maps integration to easily show location based data.
• Interactive: click on a chart element to fire a data link to any other widget in your application (for building apps with advanced drill-down capabilities).

Only write code when absolutely necessary.

Fully Programmable

AppSynergy provides robust support for both client-side and server-side programming.

On the client-side, a complete Application API allows your custom JavaScript code to integrate tightly with all the widgets in your drag-n-drop built UI. No need to reinvent the wheel, just add an event and a little code to enhance as needed.

On the server-side, you have triggers and stored procedures that go far beyond what you might expect. There is not only full support for ANSI Procedural Language extensions to SQL (i.e. PL/SQL, similar to Oracle, with variables, branching, looping, etc.) but also support for asynchronous RESTful API calls (with callback procedures) from within your PL/SQL code. It's easy to learn, optimized for data manipulation, and scales well to systems with high complexity and throughput requirements.

Root Access

AppSynergy provides full root access to your own private, dedicated database server without restriction.

This means you can integrate third-party tools and applications with ease. Quickly connect via any software that supports MariaDB, MySQL, ODBC, JDBC or REST APIs.

Create your own fully custom Security Roles

Role Based Security

Every user is assigned to a Security Role and authenticated at both the application layer and the database layer.

You can easily create fully custom Security Roles to specify exactly which tables and fields a user can view or modify. Further, your application UI can reference the currently logged in user and/or role to dynamically change the UI as needed, filter visible rows based on the current user or their role, etc.

Fully Customizable Look & Feel

Create fully custom CSS themes and share them across multiple applications for a consistent look and feel.

You have full control over your application's look & feel.

Embed An Application In Your Website

Embed Applications

You can embed your application into your website with a simple copy & paste of an embed code.

• Set your embedded application to private access and users will be prompted to sign in – which allows you to control exactly what information they can access. Great for B2B customer portals!
• Set your embedded application to public access and anyone visiting your website will have access just like a regular web page. Great for easily enhancing websites with live data!

Integrated Messaging

AppSynergy has integrated messaging services for sending email notifications and processing replies directly from your PL/SQL code.

• Send an email notification from a database trigger or stored procedure when any condition is met. For example, you could capture a status change on an invoice, dynamically generate an HTML invoice from the data, ask the AppSynergy REST API to convert that to a PDF document, and then send an email to the customer with the PDF document attached. Or send a simple email notification with a single line of code.
• Receive email into your database by simply cc'ing AnyNameYouSelect@YourDomain.com The email is parsed into database format and stored in tables for flexible integration with your applications. All formatting - even multiple attachments - are preserved (attached files are stored as Document fields). You can link these messages to other records in your database by simply matching on email address or build more sophisticated routing solutions by parsing subject lines for case numbers, etc.

Advanced integrated messaging capabilities for sending and receiving email notifications.

PDF Document Generation

AppSynergy has native services to generate PDF documents programmatically on the server, opening the world to everything from advanced document management to automated billing solutions and more.

• HTML2PDF service: Dynamically generate your HTML (say, for an invoice) then convert that HTML into a PDF document with a single REST API call.
• PDF_AUTOFILL service: Use a fillable PDF as a template (say, an insurance or customs form) and insert database data for an auto filled PDF without human errors.
• PDF_MERGE service: Combine multiple PDFs into a single document.

Programmatically create PDF documents from dynamic HTML or by filling templates.

Electronic Signatures

AppSynergy has built-in electronic signatures fields. Now you can easily capture electronic signatures directly from within your application (e.g. like a FedEx delivery signature).

Full Barcode Support

Of course you can easily scan barcodes using any commercially available barcode scanner. But AppSynergy also has the ability to generate barcodes from data in over 15 different formats for use on printouts like packing slips and inventory labels.

Comprehensive

AppSynergy has an incredibly comprehensive built-in feature set. It's also open (root access to an open database), scalable (cloud-native architecture) and easily integrated with other systems (see next section).