Skip to Content Skip to Menu

auto incement field

10 years 10 months ago - 10 years 10 months ago #272696 by michalmediasphere
auto incement field was created by michalmediasphere
joomla 3.4.5
cb 2.0.11
Hello
I need auto increment user field starting from 1 for every user registration, how i can do it using auto action?
Last edit: 10 years 10 months ago by michalmediasphere.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 50714
  • Thanks: 8692
  • Karma: 1475
10 years 10 months ago #272703 by krileon
Replied by krileon on topic auto incement field
Believe the below tutorial covers your scenario.

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.

10 years 10 months ago #272855 by michalmediasphere
Replied by michalmediasphere on topic auto incement field
i try to do it with auto action,
triggers:after user registration
type:query
action: UPDATE `#__comprofiler` SET `so_id` = IFNULL(so_id,0)+1

so_id - int number, only for read

as a result my new user get 1, oldest user get higher number. aadditionally i want that this field was incremented only for register user group (not admin/moderator - backend registration)
Maybe it could be done by query field type not auto action?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 50714
  • Thanks: 8692
  • Karma: 1475
10 years 10 months ago #272882 by krileon
Replied by krileon on topic auto incement field
The tutorial covers your exact usecase. Please watch it carefully. You need to create a field within CB > Field Management. It then will SUM the existing field values and increment by 1 so each user is constantly increasing.

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: beat, nant, krileon
Powered by Kunena Forum