Build Flexible Business Applications in the Cloud

For developers the general workflow is as follows:

• Define your Schema – Use our intuitive schema editor to create your tables and specify relationships that enforce referential integrity. You can even link tables from multiple remote databases of different brands into a single live, federated database if needed.
• Build your UI – Drag records, reports, fields, text, menus, buttons, modal panels, and more from the palette and drop them into your application canvas. Position them however you like, tweak settings, etc. Everything is customizable. Add events to extended with your own JavaScript as needed. If you later make modifications to the underlying database schema, the UI updates and stays in sync automatically.
• Interconnect your Objects – For example, connect a Button object to a Record object and assign it a predefined action like Save, Add new record, etc. Or a button click can trigger an event that calls your JavaScript code which has full access to all the widgets in the application and can do whatever is needed. You can connect a data-backed object like a record, report, or graphic to another data-backed object so that selection in one object triggers refreshing data in another.
• Write your Data-Centric Logic. – You can use client-side formulas to calculate fields, validate fields, enable/disable objects, etc. without having to code everything (automatic dependency-tree based calculations). You can also use database views to centralize the logic for common computations, and views can be built atop other views such that you can have an always-current set of calculated values that can't get out-of-sync. If data changes, you can fire a trigger which can run any code you like. You can even make asynchronous REST API calls from your triggers. You can also set up scheduled events (cron jobs) to automatically execute your REST-based integration code at predefined intervals. Powerful JSON to SQL functions makes this much easier than with most other systems.
• Leverage Pre-Wired Services – AppSynergy provides a built-in set of features and API services to handle all common business requirements. Well designed image and document storage. Electronic signature capture. There are also "services" that your triggers can call to do non-database things, like generate a PDF document from HTML code your trigger dynamically generates. Or send an email when something changes in the database (e.g. catch an Invoice status changes to "Shipped" to automatically generate a PDF document of that Invoice, then email it to the customer, or send it via API or EDI calls to your trading partners.) And too much more to list here.

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

Master Complex Relational Data

Discover the ultimate solution for advanced relational data handling with AppSynergy. Creating screens that rely on multiple tables with intricate relationships is incredibly easy and flexible.

Experience the freedom to design records that can seamlessly include scrolling lists, detailed reports, and more, regardless of their depth or complexity. Whether you need free-form tabular layouts, form-like structures, or multi-line entries, AppSynergy provides complete layout freedom. Enjoy calculated fields at any level, with parent records automatically summing child values. Updates to child values instantly propagate through peer, parent, and child formulas, ensuring your data is always accurate and up-to-date.

All this power comes without the need to write a single line of code.

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

Unmatched Versatility

When your projects demand more than drag-and-drop solutions, AppSynergy empowers you with the ability to trigger custom UI events and execute your own JavaScript code. Our comprehensive API grants your scripts full access to every object within your application, offering a level of versatility akin to fully custom-coded development.

While not every application will require this degree of adaptability, it's reassuring to know that you have this depth of capability at your fingertips whenever you need it.

The Flexibility You Need (expand image)

The Power You Need (expand image)

Unleash the Power of Automation

Effortlessly perform tasks such as updating inventory levels, sending email notifications, or dynamically generating PDF documents with our robust database triggers and stored procedures.

Our triggers and stored procedures go beyond traditional capabilities, supporting RESTful API calls and JSON. This means they can interact with virtually any external system or service, providing you with unparalleled flexibility and power. It transforms PL/SQL from a database-bound language into a more general purpose programming language, while still maintaining the benefits of a database-first language, like being able to natively take action when data changes.

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

Experience seamless signature collection with our integrated signature fields, designed to simplify and streamline the process of capturing signatures with ease and precision.

Barcode Support

• Empower your apps with advanced barcode scanning capabilities using your mobile device's camera for swift and accurate data entry.
• Effortlessly generate and print barcodes and QR codes in 15 versatile formats, perfect for inventory labels, packing slips, and more.

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.

Stay In The Loop 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)

Reduce Costs with Electronic Data Interchange (EDI)

Enterprise Edition customers can now seamlessly integrate with trading partners using advanced EDI tools.

Send and receive X12 documents, binary files, and more via SFTP or AS2. Our fully managed servers adhere to the EDIINT AS2 standard, offering flexible configurations and support for various signing and encryption algorithms. Enjoy features like compression, HTTP/HTTPS transmission, and message disposition notifications (MDNs) for confirmed receipts. Streamline the secure exchange of business documents such as purchase orders, invoices, and shipment notifications, all while reducing costs compared to traditional EDI methods.