Appearance
App Builder
App Builder (Administration → App Builder) makes apps for one organization without writing a module: a table for the data, a page to work with it, and optional queries and workflows. Everything is saved live; there's no draft stage.
The parts
| Part | What it is |
|---|---|
| Table | a real database table for this organization only (named app_t<organization id>_<code>), with id, created_at and updated_at added. Column types: string, int, decimal, date, datetime, text, bool. You can also register one of the organization's existing tables without copying it. |
| View | what people open at /app/<code>: a Page made in the visual designer (a 12-column grid of widgets), or a simple Grid. Publish to nav adds it to the menu. |
| Named query | a reusable data source: one SQL SELECT, an HTTP call, or a read or write of a builder table. Bind it to a page widget, or expose it through the Tenant API. |
| Workflow | steps with if/else, HTTP calls, SQL queries, table queries, variables and logging, started by hand, from the API or on a schedule. |
| Saved component | a group of widgets kept for reuse on other pages. |
Who can do what
| Who | |
|---|---|
| Build (the App Builder screen) | platform staff; others only when BMA allows it for their organization, group or user, or grants the builder.access permission |
| Open an app | anyone in the organization whose group can see its menu item |
| Run a named query from a page | users with builder.run, or who can see a page that uses the query |
| Save rows | people with build access. To let other users add, change or remove rows, a view needs row permissions (read, create, update, delete, each a permission key); these are set through the API or a package today, not on screen. |
Safety rules
- SQL is one
SELECT(orWITH), on the organization's own builder tables. Writes, schema changes and comments are refused,{{input.x}}values are always bound (never pasted into the SQL), and aLIMITis added (100 by default, 500 at most). - HTTP calls go to public addresses only, with a timeout.
- HTML and Markdown widgets are cleaned; embedded frames show only this BMA's pages unless the organization allows more hosts.
When to write a module instead
Choose a module when you need your own PHP code, your own screens in Vue, migrations, settings, or the same app in many organizations with upgrades. App Builder apps can also be packaged as builder modules (see the reference).