Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Warning
titlePower 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.

...

Widget Connector
urlhttps://www.youtube.com/watch?v=NifKQWWjN9g&feature=youtu.be

Script details

...

The options for the Continent custom field were taken from the database as well. The

...

following scripts are used in this example

...

:

Code Block
titleContinent data source
string[] continents = sql("myDB", "select distinct continent from countries");
return continents;

...

Note

For the moment, dependent fields can only be used by the two custom fields with autocomplete, and can only be referred in SIL data sources.

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 reference it like this: "argv[customfield_id]".

See also

Dependent Custom Fields