DropDown Field for Customer Company - population

[Rotyn]

Hi guys

In the table "customer_company" I have added a new column: "projectm" (to contain the responsible project manager for the specific company)

Displaying the new field when viewing the list of companies: no problem.
Filling out the new field when editing the company data: no problem.

But:

(a) I would like to present the field as a dropdown menu
(b) There should be no fix choices, but the choices should be populated with all entries of the "user" table (or in other words: all registered agents should be available as a selection in the dropdown menu)

Can someone help me?

Thx
Rudy

[Rotyn]

nobody any idea?

[crythias]

Don't cross-post: viewtopic.php?f=35&t=16940#p66486

You may have already seen this answer, but for those who see it here...
(a)

Code: Select all

             [ 'CustomerCompanyComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ],
            [ 'WorkwithThis', 'Projecktleiter', 'projectm', 1, 0, 'var', '', 0],
            [ 'ValidID',                'Valid',   'valid_id', 0, 1, 'int', '', 0 ],
        ],
        Selections => {
            WorkwithThis => {
                'a' => 'Item A',
                'b' => 'Item B',
            },
        },

(b)
Not really, but you can change your selections to be "nothing"
WorkwithThis => { '' => '', },
and use my code to populate that field viewtopic.php?f=60&t=17033

Now, if you need to pull from the api, you'll need to make a bit of a change to the extdata.pl code to use the user api, but the concept won't otherwise vary.