Support

 Hi,

I would like to auto populate the options in custom fields from existing tables.

Example: Product Listings in a Dropdown

If you have a lot of products it could be a real pain to define all options in the options fields.

There is also a good chance that products will differ from time to time and you have to do the changes manually.


For exaple, RSForms is using following code to auto-populate lists

// Prepare the empty array
$items = array();
// Prepare the database connection
$db = JFactory::getDbo();
// Keep this if you'd like a "Please select" option, otherwise comment or remove it
$items[] = "|Please Select[c]";
 
// Run the SQL query and store it in $results
$db->setQuery("SELECT your_value, your_label FROM #__your_table");
$results = $db->loadObjectList();
 
// Now, we need to convert the results into a readable RSForm! Pro format.
// The Items field will accept values in this format:
// value-to-be-stored|value-to-be-shown
// Eg. m|M-sized T-shirt
foreach ($results as $result) {
  $value = $result->your_value;
  $label = $result->your_label;
  $items[] = $value.'|'.$label;
}
 
// Multiple values are separated by new lines, so we need to do this now
$items = implode("\n", $items);
 
// Now we need to return the value to the field
return $items;

Is this also possible with ATS ?

cheers
Alexandra

Hello Alexandra,

there isn't any built-in support for dynamic fields and sql queries.
The main reason is that such feature could led to security issues (what if you query the wrong table and fetch the wrong fields?).

If you want to create a new field populated with the data fetched from the database, you have to create a new plugin for that, I'd suggest you to take a look at the customfields one, inside the group ATS