Build Powerful Cloud-Based Database Applications

Development Overview:

1. Define Your Tables – Use our intuitive table editor to establish your tables and their relationships effortlessly.
2. Drag and Drop Objects – Select records, reports, fields, text, menus, buttons, modal panels, and more from the palette and place them onto your application canvas. The system intelligently comprehends data relationships, automating much of the tedious work for you.
3. Connect Objects Seamlessly – Utilize the inspector to link objects. For instance, connect a button to a record and assign it a save action, or create a data link from a list object to a record object so that selecting an item in the list displays the associated record.

Need to write a bit of code? No problem (see below).

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

Master Complex Relational Data with AppSynergy

Discover the ultimate solution for advanced relational data handling with AppSynergy. Our platform makes building editable screens that rely on multiple tables with intricate relationships 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.

Unmatched Versatility in Development

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.

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.

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.