Nested Relational Objects

AppSynergy has the industry's most advanced relational nested object capabilities. Building editable UI that relies on multiple tables with complex relationships has never been this quick and easy.

Records can contain scrolling lists of records, reports, etc. without limitation as to depth or complexity. 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.

Nested Records Make UI More Intuitive - There Are Almost a Dozen Tables Used On This Screen

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.

Data Visualization

AppSynergy provides a variety of ways to visualize your data and build rich interactive dashboards.

• Google Maps integration to easily show location based data.
• Multiple Chart Types: bar, line, area, pie, doughnut, bubble, timeline, Gantt charts and geographic heat maps.

All charts support data linking and live interaction. For example, clicking on a chart element or map pin can bring up related information from the database.

Only write code when absolutely necessary.

Business Logic

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. Just add an event and a little code to do whatever is needed – without reinventing the wheel. We think you'll be pleasantly surprised by just how little client-side coding you'll actually need (hint: often none).

On the server-side you have full support for building out complex business logic using ANSI standard Procedural Language programming extensions to SQL. This is similar to Oracle's PL/SQL with variables, FOR, WHILE, IF, etc. plus the ability to make RESTful API calls and publish your own RESTful APIs.

Root Access

AppSynergy provides full root access to your own private, dedicated database server without restriction. Freely use third-party tools directly with your AppSynergy hosted MariaDB database without any artificial restrictions getting in the way.

Customizable Role Based Security

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.

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

Native Barcode Scanning

• AppSynergy has built-in native 1D and 2D barcode scanning capability – just use your phone's camera.
• Alternatively, quickly scan barcodes using any commercially available barcode scanner (like those from Socket Mobile).
• AppSynergy also has the ability to generate barcodes in 15 different formats for use on things like inventory labels and packing slips.

Embed An Application In Your Website

Embed Support

You can embed your application into your website with a simple copy & paste of an embed code using one of the two options below:

• Sign-in Required – 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. Ideal for B2B portals.
• Public – Set your embedded application to public access and anyone visiting your website will have access just like a regular web page. Ideal for easily adding live database data to your website.

Email In/Out To Database

AppSynergy has integrated email APIs for easily sending email notifications and receiving email back into the database. We use SendGrid as our email transport partner.

• Outbound Email. Easily send an email notification with a single line of PL/SQL code. Full support for advanced scenarios like capturing a status change on an order, dynamically generating an HTML invoice, converting that into a PDF document, storing it in the database and finally sending it as an email attachment.
• Inbound Email. Easily receive email into your database by simply cc'ing AnyName@YourDomain.com The email is parsed and stored in database format for easy use within your applications.

Integrated capabilities for sending and receiving email.

Programmatically create PDF documents from database data.

Server-Side HTML to PDF Generation

AppSynergy has server-side PDF doc generation capabilities built in – making it easy to build systems that need PDFs generated for things like invoices, purchase orders, customs documents, etc. Your PL/SQL code can call three types of PDF services:

• HTML2PDF – Converts your dynamically generated HTML (e.g. for an invoice) into a PDF without user intervention.
• PDF_AUTOFILL – Inserts database data into a fillable PDF template (e.g. a customs form) generating a complete PDF without user intervention.
• PDF_MERGE – Combine multiple PDFs into a single document.