CB referred by field

One of the first things I did in CB was added a "referred by" field so I could see within someone's profile who invited them.

So, I'm posting this because it seems like something everyone would want to know.

First, I would like the invited person to see on their registration page the name of the person who invited him.
1) I retrieve the user_id from #__comprofiler_plugin_invites based on the invite code
2) Display firstname lastname of the user_id on registration and in the profile.

Suggestions on how you would do this? Can it be done with a single CB field? ( where stored value and displayed are different). Does this functionality already exist some where?

The below should work using a Query field provided by CB Query Field plugin.

Parameters > Query
Query: Parameters > Display
Output: Single Row
Columns: Multiple Columns
Display: Custom
Custom:
That should output the formatname field of the user who invited them through CB Invites. Will review adding this as a field to CB Invites itself as it could be useful for several usecases.

forge.joomlapolis.com/issues/8662

OK, that works, altho I don't understand where the [user_id] is coming from on the registration page. I thought I would have to do a "where code = '[get_invite_code]'" but that doesn't work.

I used to have to set the invite_code from the URL with a trigger and JQuery command but I see that's working now.

Thanks!

This won't be able to work on the registration page. It will only work on their profile. Registration page can only show the invite code field and it has no functionality to grab who invited them. Note the invite code field is not needed anymore unless you want your site to be invite only. Simply using the invite link now stores the invite code to their session data and will accept during registration.

I wouldn't have thought it worked on registration either - but it does. I made a new invite code and my name was on the registration page (obviously I was not logged in at that point)

My site is invite only. Now that I know the field is working I no longer have to display it. However, I also add some members without registration so I will now need to handle that.

I wouldn't have thought it worked on registration either - but it does. I made a new invite code and my name was on the registration page (obviously I was not logged in at that point)

That's probably because [user_id] is 0 at that point. So it's just pulling the first invite that hasn't been accepted yet. I don't recommend displaying it on registration. It's possibly it could work on registration with the help of CB Core Fields Ajax and its Update On feature combined with checking against the database using the invite code.

My site is invite only. Now that I know the field is working I no longer have to display it. However, I also add some members without registration so I will now need to handle that.

If your site is invite only you need to use the invite code field and make sure it's set to Required. However under Parameters > Display you can toggle it to be hidden so it's not visible, but its validation can still work. As for adding users manually the best way to do that is within backend, but you'll need to be sure to turn off backend field required validation in CB > Configuration > User Profile.