Infinitely Nestable Records

Infinitely Nestable Records

AppSynergy has the industry's most advanced nested record capabilities.

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 data 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).

Build Applications that Support Drag-and-Drop

You can build applications that support drag-and-drop data changes by your users. Simply designate any field in your application as "draggable" and then designate another field as its drop target. It's that easy.

Electronic Signatures, etc.

AppSynergy has fields that support electronic signatures, document management, and more.

• Electronic Signature fields allow signature capture directly from within your application (like a FedEx delivery signature).
• Document management fields can be used to securely store an unlimited number of documents. Upload the file or simply drag-and-drop it.
• Image fields that automatically create their own thumbnails for the utmost performance and convenience.

Complete Barcode Support

You can scan barcodes using any commercially available barcode scanner. AppSynergy also has the ability to render barcodes in 16 different formats all using high resolution SVG for the utmost in scanning accuracy.

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.

A better way to write business logic.

Business Logic & Beyond

AppSynergy has built-in support for writing triggers and stored procedures using a modern ISO standard version of Oracle's PL/SQL language extended with the ability to call any RESTful API on the planet from within that code. Suddenly, an entire world beyond the database is open for business.

Combine this business logic architecture with the fact that AppSynergy also pushes the data integration work down to the data layer via its Federated Architecture and you begin to see how powerful systems that span multiple integrations and leverage remote APIs can be built in a fraction of the time and with zero application specific code.

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 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 their role to dynamically change the UI as needed, filter visible rows based on the current user or their role, etc.

Application API (JavaScript)

You can easily add an event to a UI object that calls your own custom JavaScript code. And your code has full access to the entire AppSynergy Application API.

The good news is you will seldom need the API as even complex applications are typically built entirely via drag-n-drop with a few formulas added for calculated fields.

Add an event to any UI object to call your own JavaScript code.

Embed An Application In Your Website

Embeddable 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 enhancing websites with live data!

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 form) and database data to generate a completely filled PDF with a single REST API call.
• PDF_MERGE service: Combine multiple PDFs into a single document with a simple REST API call.

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

Integrated Messaging

AppSynergy has integrated messaging services for sending email notifications and processing replies.

• Send an email notification from a database trigger or stored procedure when any condition is met. Dynamically generate the HTML body, use templates, attach documents as needed, etc. Fully automate invoicing, purchase orders and more by using notifications together with the PDF Document Generation capabilities described elsewhere.
• Send an email To your database by emailing SomeWord@YourDomain.com (typically used within CC, BCC and ReplyTo email addresses). The messages are parsed and stored in the database for flexible integration with your workflows. All formatting and email attachments are preserved. 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, etc. (e.g. parsing a Case# to link to a case).

Advanced integrated messaging capabilities for sending and receiving email notifications.