Build Powerful Database Applications in the Cloud

Your general workflow outline:

1. Define Your Tables – Use our intuitive table editor to create your tables and their relationships effortlessly. Even tables linked from remote systems.
2. Drag and Drop Objects – Drag records, reports, fields, text, menus, buttons, modal panels, and more from the palette and drop them onto your application canvas. Position them however you like, tweak settings, etc. Everything is customizable.
3. Connect Objects – Visually connect a Button to a Record and assign it a Save action. Create a data link from a Report to a Record. Pop open panels to display related info quickly and easily. Without any code.
4. Add Formulas – You can use formulas to calculate fields, validate fields, enable/disable objects, etc. You can also add events to objects and call your own JavaScript code. Triggers, stored procedures, and database views are also all fully supported.
5. Go Crazy – Call APIs or publish your own. Auto-generate PDF files from database data. Send email notifications. Scan and print barcodes. Everything you need to build and integrate powerful business applications is right in your browser.

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.