Page Comparison

Select a country or several countries in a custom field based on a continent selected in another custom field.

Video

Script details

The options for the Continent custom field were taken from the database as well. The following scripts are used in this example:

Continent data source

string[] continents = sql("myDB", "select distinct continent from countries");
return continents;

Country data source

string continent = argv["customfield_10109"];	//the dependent field
string[] countries = sql("myDB", "select country from countries where continent = '" + continent + "'");
return countries;