Skip to main content

Data Sources and Dynamic Options

OSPROV Form Builder allows you to populate select components with dynamic data from various sources.

Master Data Tables​

To use master data tables as a data source:

  1. Select a Select, Radio, or Checkbox component
  2. Go to the Data tab
  3. Set Data Source Type to "Master Data"
  4. Choose the master data table from the dropdown

Master data tables are populated from Output tasks in workflows, creating a powerful way to build interconnected forms and workflows.

URL Data Source​

To fetch options from an API endpoint:

  1. Select a Select component
  2. Go to the Data tab
  3. Set Data Source Type to "URL"
  4. Enter the API endpoint URL

Dependent Dropdowns​

Create cascading select components where one dropdown's options depend on another:

  1. Create the parent select component (e.g., "Country")
  2. Create the child select component (e.g., "City")
  3. For the child component, use a URL data source that includes the parent value
  4. Add a conditional to only show the child when the parent has a value

Example URL with dynamic parent value:

/api/cities?country=${data.country}