populate dropdown list from database

[ashley07]

Hi all,

I have created a custom drop down list and i notice there is a function to enter the dropdown list value. I am just wandering if i can populate the dropdown list "dynamically" from a table? I tried to find this functionality but can't, i want to make sure i haven't miss anything.


thanks a lot.

[Angel]

You can't do this via Studio.

You might be able to accomplish it by using a logic hook, only problem is that you wouldn't be able to fire it off for new records. Might be worth considering though. Take a look at the following Wiki entry for further details on that feature: http://www.sugarcrm.com/wiki/index.p...l_custom_logic

If that doesn't work, you could create your own Javascript code and link it to the appropriate HTML and use that Javascript code to populate the list for you.

Note that the logic hook method would be upgrade safe, but the Javascript approach wouldn't be, as it would require manual modifications to the source files.