Auto Action - Field - New Value with a Twist

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?

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.

Wat about other tables besides jos_users?

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.