Build Powerful Database Applications in the Cloud

Development overview:

1. Define your tables – and their relationships – using the table editor.
2. Drag objects from the palette and drop them on to your application canvas. These objects could be records, reports, fields, text, menus, buttons, modal panels, etc. The system understands the relationships behind the data, so most of the tedious work is done automatically.
3. Make connections between objects using the inspector. For example, connect a button to a record and assign it the save action, or make a data link from a list object to a record object so that selecting an item in the list pulls up the associated record.

If you need to write a little code, you can do that too (see below).

This screen uses nearly a dozen tables yet has zero lines of code. (expand image)

Handling Complex Relational Data

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

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 without additional work.

All without writing a single line of code.

Versatile Development

When drag-and-drop just doesn't cut it for your specific tasks, you have the option to fire custom UI events that call your own JavaScript code. The AppSynergy API offers your scripts full access to every object in your application, providing a level of versatility that goes beyond the basics.

This degree of adaptability might not be necessary for all applications, but it's comforting to know that such depth is there if you need it.

The Flexibility You Need (expand image)

The Power You Need (expand image)

Power

If you need to do things like update an inventory level, send an email notification or dynamically generate a PDF document you can do so easily with a database trigger.

And because our triggers support RESTful API calls and JSON, they can do virtually anything. No longer are triggers confined to only working on data within the database itself.

Dashboards

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, heat maps, etc.

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

Quickly build highly visual, data-rich applications. (expand image)

Powerful cloud-based Reporting without the need for a separate solution. (expand image)

Reports

AppSynergy has integrated reporting with powerful features like:

• Multilevel master-detail reports.
• Comprehensive grouping, sorting and filtering capabilities.
• Computed columns with correlated sub-query support.
• Data "windowing" functions for advanced analytics.
• One-click export to Excel.

Got Root?

AppSynergy provides 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. Maximum performance, security and reliability.

Integrated Signature Capture

Signatures fields make it easy to capture signatures.

Barcode Support

• Build apps that use the camera in your mobile device to quickly scan barcodes directly into a field.
• You can also generate and print barcodes and QR codes in 15 different formats for use on things like inventory labels and packing slips.

Audit Trail

If you enable a table's Audit Trail the system will automatically keep track of all changes made to the table over time. This allows you to run queries that can ask how the database looked at a particular point in the past.

• Allows data analysis at any point in time.
• Compare data from two different time periods.
• Use for forensic analysis, legal requirements, etc.
• All history data is automatically included in nightly backups.

Enhance Your Document Workflow with Dynamic PDF Generation

Transform your database data into polished PDF documents. Whether you're crafting a compelling quote, drafting a detailed proposal, or issuing an accurate invoice, our solution seamlessly converts your data into sleek, professional PDFs.

These PDFs are securely stored in your database, linked to their relevant records, and support an unlimited volume of documents.

• PDF Generator – Converts your dynamically generated HTML into a PDF without user intervention. See docs here.
• PDF Form Filler – Inserts database data into a fillable PDF template (e.g. W2 form, customs form, etc.) generating a complete PDF without user intervention. See docs here.

Streamline Your Workflow with Email Notifications

You can easily write triggers with just a few lines of code that send email notifications when certain events occur, such as an order status changing to Shipped. See docs here.

Not only can you streamline outbound communications, but you can also send email directly to your database to be stored and linked with other relevant records. See docs here.

Send and Receive Email Notifications (expand image)