| Widget Connector |
|---|
| url | https://www.youtube.com/watch?v=NifKQWWjN9g&feature=youtu.be |
|---|
|
In this second example we have taken the options for the Continent custom field from the database as well. The script used in this example are:
| Code Block |
|---|
| title | Continent data source |
|---|
|
string[] continents = sql("myDB", "select distinct continent from countries");
return continents; |
| Code Block |
|---|
|
string continent = argv["customfield_10109"]; //the dependent field
string[] countries = sql("myDB", "select country from countries where continent = '" + continent + "'");
return countries; |
| 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. 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]" |