CiviCRM Community Forums (archive)

My Problem: Some of my civicrm contacts have publications in a bibliography database, I want to add a custom field that allows me to set their "author id" in the civicrm contcact record. Since new author id's are added frequently, the select box opitons in the civicrm field need to be based on a query of the current author data instead of a static option group. I know what the query should look like, but how do a create an "Option group" based on a query instead of a static list?

That looks like just what I was searching for, Thanks! It seemed like something that must exist, but I wasn't finding the right hook.

There is no other way to fetch the option list without executing your code, thus it runs every time.

That's what I was beginning to surmise. None of the variable's passed into hook_customFieldOptions have any information about the context ($fieldID, $options, and $detailedFormat). Is there a 'best practices' method for detecting whether or not the field is being displayed as an editable value?

I fine tuned it by using Drupal's context module and creating a "no_auth_labels" context, then wrapping the relevant code in this:

$contexts = context_active_contexts();
if (!array_key_exists('no_auth_labels', $contexts)) :
    /*  All the good stuff goes in here;*/
endif;
Thanks for all your help