Example 6 - (Video) - More Dependent Fields
- Alexandra Topoloaga (Unlicensed)
- Chelsea Bauer (Deactivated)
- Service Account
Power Custom Fields PRO™ is becoming Power Custom Fields™
Power Custom Fields PRO™ is being upgraded to Power Custom Fields™. We are removing Power Custom Fields PRO™ from the market to focus resources on the combined app, Power Custom Fields™ which has all the features of PRO™ and more. Existing Power Custom Fields PRO™ users can get 65% off their new Power Custom Fields™ license by following the steps here.
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:
string[] continents = sql("myDB", "select distinct continent from countries");
return continents;
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, reference it like this: "argv[customfield_id]".