Skip to end of banner
Go to start of banner

Example 6 - (Video) - More Dependent Fields

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Use case

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;

For the moment, dependent fields can only be used by the two custom fields with autocomplete.

From Power Custom Fields PRO 4.0.0, you can now use the dependent fields on SQL data sources as well.

In order to get the value set on the screen for one custom field, you will have to refer it like this: "argv[customfield_id]"


See also

Dependent Custom Fields

  • No labels