Manual · 8

Controls

Every property can be fixed or computed with a binding {{ … }}. Every element also has Visible when (a binding; empty = always).

Control Properties Event
Heading text, level 1–4, alignment –
Text text, markdown, muted, alignment –
Divider label (optional), alignment of the label, line (solid, dashed, dotted), vertical –
Spacer – (just empty room in the grid) –
HTML HTML with {{ … }} placeholders, optionally a query and parameters (then record and records), as a card –
Image image address (URL), alternative text, fit, rounded –
Button label, style (primary, secondary, danger, ghost), alignment, full width, disabled when click
Input label, name, kind (text, number, email, phone, URL, password, multi-line), placeholder, start value, required, disabled when, help text change
Select label, name, options (one per line) or a query with value and label field, placeholder, start value, required change
Date label, name, with time, start value, required change
Checkbox label, name, start value change
Switch label, name, start value; like a checkbox (yes/no), shown as a toggle Change
Options label, name, options or a query with value and label field, side by side, start value, required – exactly one choice Change
Multiple choice like Options, but any number; the value is a list Change
Slider label, name, minimum, maximum, step, unit, start value; the value is a number Change
Rating label, name, maximum (5 stars), start value; a click on the current star clears it, Arrow left/right changes it Change
Search select label, name, query, parameters, search parameter (default q), value and label field, shown label, placeholder, required Change
File label, name, allowed types (e.g. image/*,.pdf), several files, required, disabled when, help text; sits in a form Change
Form title, button text, empty after submitting; holds inputs submit
Table title, query, parameters, columns (field, label, format), rows per page, sortable, text when empty select
Detail view title, record (binding, e.g. {{el.leadsTable.selected}}) or a query with parameters, fields (field, label, format; empty = all), columns (1–4), hide empty fields, text when empty –
List query, parameters, title/text/badge per item, columns 1–4, maximum, text when empty select
Chart title, query, parameters, kind (columns, horizontal bars, line, area, pie, donut), label, value and series field, aggregate (per record, count, sum, average), stacked, format of the values (number, currency, percent, hours) Select
Key figure heading, value (binding) or a query with value field and aggregation (first record, count, sum, average, minimum, maximum), format (number, currency, percent, hours), decimal places, unit, subline, compare with (shows the change in % with an arrow), comparison label, rising is good/bad, icon Click
Calendar title, query, parameters, start, end (optional), title and colour field (a label colour like blue or #hex), view month/week Select, click on a day
Map title, query, parameters, kind (points, areas), latitude/longitude field, title/text per point, colour field, group close points, area field, value field, aggregate, format, base map, centre, zoom select
Kanban title, query, parameters, lane field, lanes (order; empty = as in the data), title/text/badge per card, sum field and format, text when empty Select, Move
Gallery title, query, parameters, image field (attachment column or image address), title/text/badge per tile, columns 2–6, aspect ratio (landscape, square, portrait), fit, text when empty Select
Badge text, colour (label colour; empty = by the text), alignment –
Progress label, value, maximum (100), hide value, value text, colour (empty = accent, ok, warn, danger – also as a binding) –
Container title, style (card, plain); own grid –
Tabs tabs with labels; one grid per tab –
Dialog title, size; shown with the step Open dialog –

Field (input, select, date, checkbox): the column Fill form takes the value from when the element’s name differs (e.g. name due_date, field due date).

Key figure: percent expects the value already in percent (42 → “42 %”). Compare with is usually a binding to the previous value, e.g. {{query.kpis.data.hoursPrev}}; the change shows green when it goes the good way (for costs or open items choose rising is bad).

Chart: the series field splits the values by a second column – columns and bars then stand side by side (or on top of each other with stacked), every series gets its own line or area; pie and donut don’t use it. One series takes the accent colour of the app, several series and pie slices get up to eight fixed colours that stay distinguishable for colour-vision deficiencies (more fold into “Other”), always with a legend – with value and share for pies. Every column, point and slice shows its values on hover. Select runs on a click, with point = {label, series, value} – e.g. Open page with the parameter stage = {{point.label}}; on the target page {{url.stage}} reads the value.

CSV download (tables, lists, charts; off until you switch it on): a CSV button at the top right of the element. Tables and lists load all records of their query for it (not just the page shown, in the current sort order), tables with their columns and headings, lists with all fields; a chart delivers what it shows (one row per label, one column per series, value and share for pies). The file is UTF-8 and follows the interface language: comma as the separator where the decimal mark is a point (English), otherwise semicolon and decimal comma – so Excel opens it directly. Values come raw (numbers without thousands separators, dates as 2026-11-12); text that starts like a formula (=, +, -, @) gets a leading apostrophe. The action Export CSV creates the same file – also without the button on the element.

Calendar: month or week, with paging and Today; entries spanning several days show on every day, with more than three on a day “+n more” opens that week. el.<id>.from and el.<id>.to are the visible range (YYYY-MM-DD) – as parameters of the query it loads just that. Select runs on a click on an entry (with item, also el.<id>.selected), click on a day with date (e.g. Fill form with {"day": "{{date}}"} and open a dialog to create one).

HTML: free HTML for your own tiles, notes or cards. Placeholders are escaped before they are inserted – a value containing <b> shows as text, not as markup. Then the HTML is sanitized: no scripts, no event handlers (onclick …), no javascript: links, no <style> blocks, forms or frames; inline styles (style="…"), links (also mailto:, tel:) and images stay. Links with target="_blank" open without access to the app. The browser shows images from other addresses only when the security settings allow them. With a query the element loads its data itself: {{record.name}} is the record (or the first one), {{records}} the list.

File: Run query with an Upload a file query sends every chosen file of the form (or of the file input chosen in the action) to the record, one at a time – with a write grant on exactly that table, never more than the account may anyway. Size (at most 50 MB per file) and allowed file types are also set by the attachment column; the content is checked, not the extension. A new record with a file: first Create record, then Upload a file with {{query.<create>.record.id}} as the record. el.<id>.value is the list of chosen files; Reset form empties it.

Kanban: one lane per value of the lane field, the header shows the count and (with a sum field) the sum. Cards can be dragged to another lane with mouse or finger; with the keyboard Arrow left/right moves the focused card, Enter selects it. Move runs with item (the card), lane (the target lane) and from – typically Run query with an update query {"id": "{{item.id}}", "stage": "{{lane}}"} and then Reload query. The card shows in the new lane at once; if an action fails it goes back. Plain numbers, amounts and percentages as a badge show in neutral gray.

Gallery: if the image field is an attachment column, the tile shows its first image as a thumbnail; without a Select event of its own, a click opens the image large (Esc closes). Images and files of attachment columns come through the app’s own address (see fileUrl in Bindings and actions) – also for app users and public apps, which may not use the REST API.

Search select: searches while typing – the query gets the text in its search parameter, e.g. a list with the filter name contains {{params.q}} (empty text = all). For foreign keys in large tables, where a Select would get too long. Required means an entry from the list, not just text. When Fill form sets a value, the shown label (e.g. {{query.lead.record.client_name}}) shows its name; el.<id>.label is the label of the choice. Multiple choice delivers a list – as a parameter of type any.

Divider and spacer structure a page: a divider is a line, optionally with a small heading (left, centred or right) or vertical between two columns. A spacer is empty room, for example to keep a button on the right. On a phone, where all elements stack, spacers and vertical dividers drop out; horizontal dividers stay.

Map

The map shows records as points or colours countries and regions by a value.

  • Points: latitude and longitude field (default latitude/longitude, decimal degrees). Title and text per point with placeholders ({{item.name}}) appear on hover. The colour field takes a label colour (red, blue …), #hex or a category (up to eight, with a legend). Close points are grouped into a number; a click zooms in, and if they sit at one place a list to choose from appears. Event select with item.
  • Areas: the area field holds a country code (ISO 3166 alpha-2 like DE or alpha-3 like DEU), a region code (ISO 3166-2 like DE-BY) or a country name; plus value field and aggregate (sum, count, average). Five steps of one colour, a legend with the smallest and largest value and a tooltip with name and value. Event select with area (code, name, value).
  • View: fits the data (for areas the mainland, without overseas parts); centre (lat, lng) and zoom fix it. Dragging pans; double click, + / − and Ctrl + mouse wheel zoom – the wheel alone only after a click into the map, otherwise the page scrolls; ⤢ shows everything again. Keyboard: arrow keys, + / −, 0. On touch screens a vertical swipe scrolls the page until you tap the map; two fingers zoom.
  • Base map: built in, from Natural Earth (public domain): countries, coasts and from zoom 5 the region borders – no external requests, works without internet too. It does not show streets or places. If a tile server is set (Settings → Security → Maps), its tiles lie underneath; base map: outline still uses the built-in one.
  • Coordinates from addresses (geocoding) are not built in – the data brings them, for example through a script or a workflow with your own service.

Values of elements

  • Input, select, date, checkbox: el.<id>.value – e.g. {{el.search.value}} as a query parameter.
  • Form: el.<id>.values – input name (or its ID) → value. On submit the same is available as values.
  • Table and list: el.<id>.selected – the last selected record; in the select event as row (table) or item (list).
  • Tabs: el.<id>.tab – the ID of the open tab.

Data elements

Tables, lists, charts and selects with a query load their data themselves: as soon as a parameter changes (a search field, say), they query again shortly afterwards. Without a column list a table shows all fields of the query. Formats: date, date and time, number, currency, yes/no, badge (the value as a coloured pill) and progress (0–100 as a bar). Without a colour of their own, common states get a telling one: Done, Paid, Won, Approved, Active green, Overdue, Lost, Urgent, Blocked red, Review, Sent, Proposal, In progress, High amber, Qualified, Scheduled, Medium blue, New, Open, To do, Backlog, Draft, Low gray; any other value always the same colour.

The detail view shows one record as a labelled field list – for example the record selected in a table or the result of a One record query (for a list, its first entry). The columns arrange themselves: on narrow areas the fields stack. In addition to the table formats there is Markdown (for long texts, across the whole width). Empty values appear as “–”, or not at all with Hide empty fields.