Skip to Content Skip to Menu

[SOLVED] Auto Group Creation

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
10 years 9 months ago - 10 years 9 months ago #239534 by eciudad
[SOLVED] Auto Group Creation was created by eciudad
I would like to allow the users at registration to create a unique group or join an existing one, based on their last-name. I was looking at the instructions but they look a bit confusing for me. I did not find where to pick up the fields to be used to create the group and the logic that would allow them to join one that already exist. I am sure I missing something but after working on trials for hours I decided to ask. I would like to use the same concept to concatenate five fields into one for display only. Can you give me lead way?
Last edit: 10 years 9 months ago by krileon.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
10 years 9 months ago #239568 by krileon
Replied by krileon on topic Auto Group Creation
Please review the below tutorial as it explains how to create groups based off registration data.

www.joomlapolis.com/support/tutorials/107-use-cases/18331-gj-auto-on-the-fly-creation-of-groups-based-on-registration-data

The name of the group can be a substitution such as [name] or whatever you like. Please see the below tutorial regarding substitution usage.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb


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.

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
10 years 9 months ago #239594 by eciudad
Replied by eciudad on topic Auto Group Creation
Thank you Kyle. I was able to get the groups going. I will try to see if I can use the same function to update a field in the #__comprofiler with concatenated information from several fields from the same table.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
10 years 9 months ago #239607 by krileon
Replied by krileon on topic Auto Group Creation

update a field in the #__comprofiler with concatenated information from several fields from the same table.

Probably don't need to do that. You could use CB Query Field then just query for the information you want and it'll output it as a field on the users profile.


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.

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
10 years 9 months ago #239616 by eciudad
Replied by eciudad on topic Auto Group Creation
Thank you kyle. I tried it before but I had issues on displaying more than one field on the CB Query field and I wanted to display five fields. I thought on concatenating tghe fields into one and display that field would work. Let me ask, how would you about it on displaying all those fields into one CB Query field?

A separate question, the calendar only goes back to year 1904. Is there way to get it back to 1800's and 1700's?

Thank You Again

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
10 years 9 months ago #239619 by krileon
Replied by krileon on topic Auto Group Creation

Let me ask, how would you about it on displaying all those fields into one CB Query field?

Couple ways you could do this. You could use CONCAT and combine them or set the query field to output multiple columns. Both exampled below.

CONACT Method
Query:
Code:
SELECT CONCAT_WS( ' ', `firstname`, `middlename`, `lastname` ) FROM `#__comprofiler` WHERE `id` = '[user_id]'
Output: Single Row
Columns: Single Column

Multiple Columns Method
Query:
Code:
SELECT `firstname`, `middlename`, `lastname` FROM `#__comprofiler` WHERE `id` = '[user_id]'
Output: Single Row
Columns: Multiple Columns
Display: Delimiter
Delimiter: Space

A separate question, the calendar only goes back to year 1904. Is there way to get it back to 1800's and 1700's?

You can go back as far as you want. Edit your date field and adjust the minimum year as needed.


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.

Moderators: beatnantkrileon
Powered by Kunena Forum