Skip to Content Skip to Menu

Confirming CB user name in a registration field

  • cagoffice
  • cagoffice
  • OFFLINE
  • Posts: 478
  • Thanks: 27
  • Karma: 4
9 years 4 months ago #266323 by cagoffice
Is there a way for a user to type in a persons name in a field during registration and have CB scan our list of users to confirm that the person they type is a current user?

If so, is there a way to email that existing user when someone registers to say that the person registered and lists their registration details in an email?

Long story short, the registrant must use a reference (an existing customer) and that customer needs to see their registration details to confirm that they will refer that person.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 4 months ago #266337 by krileon
Yes, using CB Query Field and its Query Validation on a text field. You'd create a query that queries the _users table and compares the value they supplied to the username column. As for emailing that user it maybe possible using CB Auto Actions and a second query field to grab the references email address, which you'd then substitute in for the To address of your email action that'd fire on the after registration trigger.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • cagoffice
  • cagoffice
  • OFFLINE
  • Posts: 478
  • Thanks: 27
  • Karma: 4
9 years 4 months ago #266338 by cagoffice
Replied by cagoffice on topic Confirming CB user name in a registration field
I don't know anything about CB Query Fields or Query Validation. Are there any tutorials on that?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 4 months ago #266343 by krileon
Yes, see the below videos regarding CB Query Field.

www.youtube.com/playlist?list=PLp0puRITgC7MM9iP9FooKB1qk8f5MLWVp


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: nant

Please Log in or Create an account to join the conversation.

  • cagoffice
  • cagoffice
  • OFFLINE
  • Posts: 478
  • Thanks: 27
  • Karma: 4
9 years 4 months ago #266353 by cagoffice
Replied by cagoffice on topic Confirming CB user name in a registration field
The 2nd video was a little complicated for me but I think I get the basic idea.

Dumb question- where do I find my user table?

Please Log in or Create an account to join the conversation.

  • cagoffice
  • cagoffice
  • OFFLINE
  • Posts: 478
  • Thanks: 27
  • Karma: 4
9 years 4 months ago #266356 by cagoffice
Replied by cagoffice on topic Confirming CB user name in a registration field
I just found out that the validation should be shown to the moderator only (not the registrant). We don't want the registrant to know if their field matches anyone in our database. But we do want the moderator to be able to see. Because if it's not a match, it could be spelling mistake etc. that only a live person will be able to confirm.

Is this possible or something custom I would have to pay you guys to set up?

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum