Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

Auto Action - Field - New Value with a Twist

11 years 9 months ago #218309 by edmundcheong
Auto Action - Field - New Value with a Twist was created by edmundcheong
I would like to check if the auto action could modify username/email with multiple values..

1. Scenario for for username:

Field Action:

Field (Required): Username
Operator (Required): Set (Field = Value)
Value: [user_id][user_id] (this is not a mistake, it's intentional)

Therefore this way the new username or output will be 12341234 (if the user_id is 1234). Am I right?

2. Scenario for for email:

Field Action:

Field (Required): Email
Operator (Required): Set (Field = Value)
Value: [user_id]@newemail.com (this is not a mistake, it's intentional)

Therefore this way the new email or output will be 1234@newemail.com (if the user_id is 1234). Am I right?


3. Is there a possibility to modify the name under the _users table? or any other table under Joomla?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #218323 by krileon

Therefore this way the new username or output will be 12341234 (if the user_id is 1234). Am I right?

Yes.

Therefore this way the new email or output will be 1234@newemail.com (if the user_id is 1234). Am I right?

Yes.

3. Is there a possibility to modify the name under the _users table? or any other table under Joomla?

Yes, CB splits the name up to whatever you have CB configured to use. So for example you may have First Name and Last Name fields that you'll need to adjust and it'll combine and store those to Joomla name column on change.


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.

11 years 9 months ago #218910 by edmundcheong
Replied by edmundcheong on topic Re: Auto Action - Field - New Value with a Twist
Wat about other tables besides jos_users?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #218921 by krileon
You want to update tables other than _users and _comprofiler? Just don't use a Field action. Use a Query action instead and you can supply whatever database query you want.


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