ActiveManage Docs ← Back to activemanage.co.uk

Tickbox (Multiple) (DB) Field

Multiple checkboxes whose options are pulled live from a datastore. Edit the source table and the checkboxes update without redeploying anything.

Conditional options

  • Data Source — which datastore the options come from. Pick the table and (typically) the field whose value will be shown.
  • Option Filter (Required) — narrow the source rows by criteria (e.g. only rows where active = 1).
  • Field to Group By — if the source table has a grouping field, options will be grouped under headings rather than listed flat.
  • Display Format — if you would like the value to be displayed in a different format or include additional fields then please enter the format here. ##AMDATA_**## will be replaced with a field from the database row (replace ** with the field name).
  • Option Sorting (Required) — Alphabetically A-Z, Alphabetically Z-A, or By Field. If you pick By Field, an additional Sort Field Name input appears.

How the value is stored

As a comma-separated list of the source rows' IDs (or chosen unique key). Joining back to the source on read is automatic for templates and merge tokens.