Relation Picker

A dropdown/search field that lets users select related rows from another database table. Automatically loads options from the target table.

Properties

Property	Type	Default	Description
name	text	''	The field name. Should match a reference column in your database table.
label	text	''	The visible label displayed above the picker.
targetTable	number	''	The ID of the target table to load options from.
displayField	text	'name'	The field from the target table to display as the option label.
multiple	boolean	false	Whether multiple selections are allowed.

Events

• onChange -- Fires when the selection changes.

Example

Select a category for a product (single selection):

name: category_id
label: Category
targetTable: 5
displayField: name
multiple: false

Select tags for a blog post (multiple selection):

name: tag_ids
label: Tags
targetTable: 8
displayField: title
multiple: true

Tips

• Place inside a Form Container for the selected ID(s) to be included in form submissions.
• The submitted value is the ID of the selected row (or an array of IDs when multiple is true).
• The targetTable property requires the numeric table ID, which you can find on the Tables tab.
• The displayField controls what the user sees in the dropdown. Common values: name, title, label, email.
• Pair with reference column types in your schema for proper relational data modeling.
• Use the Lookup transform node in your pipeline to resolve reference IDs back to their full row data for display.