[SOLVED] Associate Member With Another

Our community has a number of regional member managers (who are also members) and I want to allocate each member one of these managers.

I thought of adding a field with a single selection from a drop down list, but think this is too basic and does not use the system to its best.

At the very least, I would like to allocate a manager to a member, for reporting.

Ideally, I would like to allocate the manager and have their details show in the members profile - 'here is your local contact'.

Is there an easy way to do this, or is it a case of dipping into some code.

I am about to create a user group to put these managers in (or re use an existing one!) if that helps.

Well you'll need a way to link the two users together. Whether it's a field or a new database table with both their user ids specified is up to you. Field is probably easiest. As for showing the managers contact information on the members profile you'll probably need to use CB Query Field or CB Code Field to either query for it or use PHP and getFields API to output it using the linked user id field or database table you've setup to determine who that information is coming from. CBs substitutions don't support substitutions within substitutions so that wouldn't work to just substitute in the user id. Maybe easier to just link to that managers profile.

First the linking.

Can I create a field that allows me to easily choose who the manager is? I have been looking, but cannot work out if/how!

Yes, CB Query Field and its Query Select fieldtype could be used. It builds the dropdown options from the results of a database query. If you're using a usergroup to determine if a user is a manager or not I'd just query _users then join the usergroup map table and filter it to those with your usergroup that way or have a CB field (checkbox for example) that you toggle to determine if they're a manager.

Kyle,

I know this is an old post, but I never managed to get the query worked out. With my new found knowledge of CB Query Field I thought that I would give it another go, without success.

I have several members who are in a Joomla Group called 'Member Managers'. I would like to call this group up and select the relevant person, displaying their firstname & surname from comprofiler.

If I smile really nicely, do you think you could push me a little more in the right direction?

You can use CBs userlists and Joomlas debug mode to help build queries like this. At the bottom of the page it exposes the queries and will show you how to do a simple join of the tables. Such example as follows.

That should give you a value and label for a Query Select usage. It'd store as their user id and display their full name. Supply the usergroup id to limit the selection to users with that specific usergroup.