API from Data Model

Use a point / click designer to specify your API:

1. Choose columns, and
2. Related Data (Items for PartnerOrder) for a nested document

The system handles all data access, including filtering, pagination and optimistic locking. You can provide JavaScript events, to compute fields, and access Web Services and Java.

Logic

The API provides not just data access, but a full server - it enforces logic specified by spreadsheet-like rules that are 40X more concise that code.

1. Constraints - multi-table expressions that must be satisfied, else exceptions are raised
2. Derivations - multi-table expressions, such as sum, count
3. Extensible - via JavaScript
4. Integration - reformat data and sent it to other systems via APIs or messages

Logic is automatically invoked, and ordered by system-discovered dependencies. Data access is transparent and automated.

Web App

App Logic Servers create a default web app, automatically from your schema. Shown at right, these are multi-table:

1. Master Detail (Orders for Customer), with editable grids (multi-table pages)
2. Parent Lookups (SalesRep for Order)
3. Drill Down (see Order detail image, below - multi-page apps)

The result is multi-page apps, consisting of multi-table pages.

You can use Author Mode to control style sheets, masks, field ordering, and conditional hide/show based on data content expressions.

Author Mode also enables you to add tables and columns, automating DDL including Foreign Key definition. This promotes collaboration between IT and Users.

****

Click Walkthrough (above, top) to see how these concepts are used in creating a complete server and web app.