Dynamic Data
- Single DropDown
Depended DropDown
Getting Data from a Query
Month
Parameters (Settings):
- Project
Wonderful Relations Project
- Formidable Form
- Formidable Field
- Dependend Formidable Filed
- Query
- Select Text
Select “Static Data” with Database
Create a Query with no database table
Create a Field Source “DUAL” and SQL Function:
SQL Function
0 value, 'Option 0' text
union
select 1, 'Option 1'
union
select 2, 'Option 2'Resulting Query
SELECT
0 value, 'Option 0' text
union
select 1, 'Option 1'
union
select 2, 'Option 2'