Hi Joomlapolis
I have set a group of referrers. Each referrer has a name, of course, and a referrer_aid
Each new user must choose a referrer = a parrain
The parrain will be identified with parrain_name and parrain_aid

For this purpose, I need a customized field for a specific function
-A customized field named “parrain_name” located on Tab “Parrain” and a “parrain_aid”
*Type : user name
*Selection restricted to “referrers” user group
*selected in list or view or geolocalisation or whatever is easier for you
*If I could show a list of users sorted by “user_dept”( = left (profile.postal_code ;2)) + separator + ”profile.city”, it would be super
*If it is possible to display only dept / city / name, would be top
*mandatory Registration + editing

With a trigger
The “name” of the selected parrain will be copied as parrain_name of the new user when the new user has selected the parrain (referrer)
The value of “referrer_aid” will be copied to “parrain_aid” of the new user

I need to know how I can go and fetch the parrain_aid, which table and key.

Please, how is it possible to solve with CB ?. What do I need (Subscription/addon)?. What support, what suggestion can you provide or/and where can I find help or resources?.

Best regards
Erwan

Hi Krileon
Sorry it is very simple … and very common. But seems impossible with Joomla.
When a new user registers, he must select his correspondent.
It can be in a list or on a map displayed on the right or below (Smartphone). On this list or map a link or a button or field “Select as my correspondent”.
By clicking, the correspondent_aid is copied into the new profile into e.g. mycorrespondent_aid of the new user/member

You could have the same with shops ‘Select as my preferred shop’ on a map or in a list
Does CB provides such a possibility egal whatever it can be select/php/javascript (security ?)
It is not so simple because of access to the session.

Regards

Krileon
No device, so simple.
You see an equivalent on many websites
Please have simply a look to the picture