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'