PPPHP

Choice fields — dropdown, radio, checkboxes

One field control answers two independent questions: where do the options come from (a database table, a built-in preset like countries, or a manual list) and how should they look (a dropdown, a radio group, a checkbox list, or a type-ahead box). Pick a source and a display — any combination — and the same field shows friendly names while storing a small, joinable value.

WhereDesigner → double-click a field → Field Controls → Edit · or Console → project → Fields → a field’s Edit controlPHP

One control, two questions

The Lookup Wizard edit control is the all-in-one choice field. Set Values from and Display as separately — every cell in this grid is a valid field:

Display ↓  /  Source →TablePresetManual
DropdownCustomer from customersCountry from the ISO listStatus: Active/Inactive
Radio groupBranch from branchesGenderYes / No
Checkboxes (multiple)Tags from tagsDays of the weekInterests: Sports, Music…
Type-ahead (ajax)Any large table, searched liveCountry — type to filter the ISO listType to filter your options

Type-ahead works for every source: a table is searched live on the server; a preset or manual list is filtered instantly in the browser (no server round-trip). The plain Dropdown control also has a Searchable (type-ahead) switch that turns a long single-select list into the same type-to-filter box.

Values from — where the options come from

SourceUse it forWhat is stored
TableOptions that live in your own data and change over time — customers, branches, categories. Supports a WHERE, ordering, cascading parent/child, and add/edit on the fly.The table’s key column (usually id); the user picks by the display column.
PresetA common, standard list you shouldn’t have to type — countries, gender, marital status, and more (see below). Baked into the app, so it works offline.The preset’s numeric id (for Countries you may instead store the ISO code, name or calling code).
ManualA short, fixed list unique to one field — e.g. Active, Inactive.Whatever you type. Use value:Label pairs to store a code but show a label (e.g. 1:Active, 0:Off).

No control chosen? A column created with a fixed list of values (an ENUM such as draft, published, archived) becomes a dropdown of exactly those values automatically, and the first option is pre-filled from the column's default when you leave it blank. Lookup options always keep the order you set (for example, alphabetical by name) in every dropdown and type-ahead.

Display as — how it looks

DisplayBest for
DropdownLong lists (countries), or when space is tight. Turn on Multiple to select several (stored comma-separated).
Radio groupA few mutually-exclusive options you want visible at a glance — gender, yes/no. Lay out vertically or horizontally.
CheckboxesChoosing several at once — interests, tags. Always multiple; stored comma-separated.
Type-aheadVery large tables — the user types and matches load live. Optionally allow free text not in the list.

Styling — make it look the way you want

Every choice control (and Dropdown, Button Toggle, Switch, Star Rating…) shares one consistent set of Style options in the same Field Controls panel. Set them once and they apply on every page.

OptionWhat it doesApplies to
ColourThe accent colour of the selected option / dot / pill (Primary, Success, Danger, …).All choice controls
SizeS / M / L. Small is now a genuinely compact, tighter list.All
Full widthStretch the group across the row (options spaced out) instead of hugging the left.Radio, Checkbox, Button Toggle
Option styleplain = classic dots/boxes · boxed = bordered selectable cards · button = pill buttons (the dot hides, the chosen pill fills with the colour).Radio group, Checkbox group
Group frameA container around the whole set. Label above: none · box (square border) · rounded · card (rounded + soft shadow) · list (divided rows, iOS-style). Label ON the border (an outlined field, like a Material text field): outline (rounded) · outline-sq (square) — the field label becomes a legend notched into the border, options inside.Radio group, Checkbox group
LayoutInline (in a row) or Stacked (one per line).Radio, Checkbox
Variant · Height · ShapeFor the Dropdown select: a plain themed field or a coloured button, its height, and rounded corners.Dropdown, Lookup Wizard
StateRender the control disabled (read-only, dimmed).All

Each control only shows the style options that make sense for it — e.g. no “rounded” on round radio buttons, no “full width” on a fixed switch. The panel lays everything out in a tidy two-column grid, so the options stay compact and easy to scan.

Built-in preset lists

Ready-made lists you can drop onto any field — no table to create. Each stores a small numeric id and shows the friendly name.

PresetValues
Countries196, ISO 3166 A→Z (name, 2-/3-letter code, calling code). Choose what to store: id (default), ISO code, name or calling code.
GenderMale / Female / Other
Marital statusSingle / Married / Divorced / Widowed / Separated
Salutation / TitleMr / Mrs / Ms / Miss / Dr / Prof
Blood groupA+, A−, B+, … O−
Yes / NoA simple Yes / No pair
Days of the weekSunday → Saturday
MonthsJanuary → December
Year (dynamic)A range of 4-digit years around the current year. Set Years before and Years after — e.g. before 4 / after 1 shows 2022 … 2027 today — and a Sort order (Ascending = oldest first, or Descending = newest first, handy for a birth year). Either bound can be negative to shift that edge across this year: after −1 stops at last year for a past-only list (2022 … 2025), and before −1 starts next year for a future-only list. The list recomputes every time the form loads, so it never goes stale, and the field stores the year itself.

Because the Year list is anchored to “now”, it is offered only as a choice-control preset — not as a seedable reference table (a fixed snapshot would drift out of date).

Worked examples

Gender as radio buttons. Field Controls → Edit → Lookup Wizard → Values from = Preset, Preset list = Gender, Display as = Radio. The form shows three radios; the field stores 1/2/3 and the list shows “Male”.

Country as a searchable dropdown. Values from = Preset → Countries, Display as = Dropdown. Stores the country id; shows the name everywhere.

Interests as checkboxes. Values from = Manual, Manual options = Sports, Music, Travel, Reading, Display as = Checkboxes. Stores the chosen labels comma-separated.

Customer picker on a large table. Values from = Table = customers, key id, display name, Display as = Type-ahead.

What is stored vs. what the reader sees

A choice field almost always stores a small code (an id) and shows a name. That name follows the value automatically — on the List and View pages, in Print/PDF and exports, and in the filter dropdown — you never have to map it yourself. Because the stored value is a discrete code, the list filter becomes a proper value picker (with a search box and per-value counts) that matches exactly — filtering “Male” never accidentally matches “Female”.

Reference tables — fetch any column later

When you store a numeric id against a real table, that one value can fetch any column later — a country id gives you its name, ISO code and calling code by a simple join. To create the standard tables in one click, open Tables → New from template → Reference data and pick Countries, Gender or Marital status; each is created with a single INT id primary key already filled in. Then point a field’s Lookup Wizard at it (Values from = Table).

Tips

The other input controls, feature-packed too

The same Field Controls panel customises the rest of the inputs:

ControlOptions
Text BoxPlaceholder · max length · a leading/trailing add-on (a unit like kg, a symbol like $, or a Bootstrap icon such as bi-at) · text transform (UPPER / lower / Capitalize).
Text AreaRows · placeholder · max length with a live character counter · auto-grow (expands to fit).
PasswordPlaceholder · an optional show/hide reveal button.
Colour PickerPreset swatches (your own hex list, a starter palette, or none) · a clear button.
Range SliderMin / max / step · a unit shown after the live value (e.g. %) · show/hide the value.
Star Rating · SwitchColour, size and state like every other control (stars keep their gold default).

Date & Time — choose how a timestamp is shown

Everything above sets the Edit control (how a value is entered). A field also has a View control — how the stored value is displayed on the list, view, print, PDF and export. For a date / datetime / timestamp column, the Date & Time view control gives you one place to pick from many patterns — including date-and-time together and human-friendly forms the built-in Long / Medium / Short Date controls don’t cover.

WhereDesigner → double-click a field → Field Controls → View tab → “Date & Time” → pick a pattern · or Console → project → Fields → a field’s View controlPHP
GroupPatterns (example)
Date & timeLong (January 5, 2026 at 3:45 PM) · medium (Jan 5, 2026, 3:45 PM) · short · full (weekday + seconds) · 24-hour · ISO (2026-01-05 15:45).
Date onlyLong · medium · short (1/5/2026) · padded · day/month/year · ISO (2026-01-05) · weekday · month & year.
Time only12-hour (3:45 PM) · 24-hour (15:45) · with seconds.
HumanRelative (2 hours ago, in 3 days, just now) · Today / Yesterday at 3:45 PM · calendar (names weekdays within a week).
TechnicalISO 8601 · RFC 2822 · Unix timestamp · weekday name.
CustomAny PHP date() format you type — e.g. D, d M Y — H:i → Mon, 05 Jan 2026 — 15:45.

The picker shows a live example beside every pattern, so you choose by sight. It is timezone-aware (your app clock), safe on empty values, and — unless you turn it off — wraps the output in a semantic <time> tag whose hover tooltip reveals the exact date and time (handy for a relative label like “2 hours ago”). The chosen pattern applies everywhere the field is shown: list, view, print, PDF and export.

Signature — capture a hand-drawn sign-off

The Signature (draw) edit control turns a field into a draw-to-sign pad — for consent, approvals, delivery receipts and agreements. It works with a mouse, a finger or a stylus, stays crisp on high-resolution screens, and re-draws an existing signature when you reopen the record. The stored value is a PNG image, so the paired Signature view control shows it wherever the field appears — list, view, print, PDF and export.

WhereDesigner → double-click a field → Field Controls → Edit → “Signature (draw)” · and the View tab → “Signature”PHP
SettingWhat it does
HeightPad height in pixels (60–600).
Pen colour · widthInk colour (hex) and stroke thickness (1–8).
BackgroundTransparent (default) or White — white bakes a solid background into the saved PNG, best for printing / PDF.
Show “Clear”A button to wipe the pad and start again.
Prompt textThe faint “Sign here” hint shown on an empty pad.
View side: Max height and Border control how the saved signature is displayed.
!
A signature image is larger than a normal value (roughly 5–30 KB), so give the column a TEXT / LONGTEXT type — not VARCHAR, which would truncate it. Only what the person draws is captured; it is never a real identity document.

Formula — a field that calculates itself

The Formula (calculated) edit control makes a field a read-only value computed from other columns in the same record — a line total, a full name, a flag. It previews live as you type in the form, and the server recomputes it authoritatively on every save (full form, inline edit and spreadsheet), so the stored value can never be faked from the browser. Because it is a real column, the result is sortable and filterable; pair it with a Number / Currency / Percent view control for display formatting.

WhereDesigner → double-click a field → Field Controls → Edit → “Formula (calculated)” → type the formulaPHP

Reference other columns as {column}. Combine them with + − * / %, comparisons (== != < <= > >=) and text in "quotes". Functions available: round abs ceil floor sqrt min max sum avg if concat upper lower trim len coalesce number.

GoalFormula
Line total, 2 decimalsround({qty} * {price}, 2)
Total with taxround({qty} * {price} * (1 + {tax}), 2)
Full nameconcat({first_name}, " ", {last_name})
Tiered labelif({score} >= 40, "Pass", "Fail")
Fallback valuecoalesce({nickname}, {full_name})

Optional Decimal places rounds the numeric result; a Prefix / Suffix dress the live preview (e.g. $, %).

!
Choose the column type to match the formula — a numeric column for maths, or TEXT for concat results. The expression is evaluated by a safe parser (no code execution); anything it can’t parse simply yields a blank value rather than an error.

Address / Location — capture a place

The Address / Location edit control captures a place as an address, map coordinates, or both, all in one field. A “Use my location” button fills the latitude and longitude from the visitor’s own browser (it asks their permission first), and an “Open in map” link hands the place off to their map app. It is completely self-contained — no map tiles, no third-party geocoder, nothing loaded from the internet — so a generated app keeps working offline and leaks nothing. The paired Address / Location view control shows the address (and coordinates) with a small map icon wherever the field appears — list, view, print, PDF and export.

WhereDesigner → double-click a field → Field Controls → Edit → “Address / Location” · and the View tab → “Address / Location”PHP
SettingWhat it does
CaptureAddress, Coordinates, or Both — which parts to collect.
“Use my location” buttonFills the coordinates from the browser’s geolocation (with the visitor’s consent).
Map linkThe provider the “Open in map” link uses — OpenStreetMap, Google Maps, or None. The link is always built from the data, never from anything stored, so it is safe.
Address placeholderThe faint hint shown in the empty address box.
View side: Map link picks the same provider for the small map icon (or turns it off).

The value is stored as a compact JSON object — {"address":"…","lat":…,"lng":…} — so the address and coordinates travel together and can be read back later. A plain address typed into an older text field still displays correctly.

!
Put this control on a TEXT or VARCHAR(255)+ column — it stores a small JSON object, not just a street name. To show many records on one map, add the Map page component (the field captures a location; the component plots them).

See also: Add & Edit pages · SQL Variables