[Dropdowns] How to populate dynamically?

[andy60]

I am a financial planner and i have a great portfolio of products. My solution for archiving operations is to add a dropdown field to module Calendar. But my dropdown must read data from a mysqltable. I prefer it, i have several products. My question is: how to populate dynamically a dropdown box? i have problems to understand it. I have the bokk for SugarCrm Developers but unfortunately i don't see this importanta aspect.

[andopes]

Hi, andy60.

You can implement it by ajax.

I believe the dropdown must be filled after some value were selected into another dropdown. This way you will:
1. Create a php file into root of sugar whose receive by GET the desired parameters and echo the content of dropdown as a json variable;
2. Create a javascript that calls this php function and populate the dropdown through the json variable;
3. Include this js file into header of EditView, together other js including
4. Define an event at this dropdown onchange="javascript_function_name(parameters)"


Cheers

André Lopes
Lâmpada Global Services
Av. Angelica, 1814 cj. 1502
São Paulo, SP 01228-200
tel1. 55 11 3668-6776
tel2. 55 11 3822-2581
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[andy60]

Thank you for your attention. Sincerely.