using Auto Actions for login actions

Hello!

I have just started to work with Auto Actions. Let me explains what I want to do:

"When a user from usergroupA logs in, I want fieldname1 from table1 to be set to value1"

Then, I guess the proper way to do it with Auto Actions is to set an Auto Actions with:

- Type = Query (as we wan't to update the database)
- Triggers = onDuringLogin (for instance, or Before User Login)
- User = Automatic (I don't understand this part actually)
- Access = Everybody
- Conditional = [usergroup] = usergroupA
- query = "UPDATE table1 SET fieldname1=value1 WHERE id_field=[his id]

By now, I just dont know what to write for [usergroup] and [his id]. I did not find any documentation about those values: if there is one it would be usefull.

Many Thanks in advance!

Don't add an access check on conditionals, that's specifically why there's an access parameter. Simply set it to the usergroups you want the trigger to apply to. As for the ID I assume it's user id, which you can substitute in with [user_id]; please see below tutorial for further substitution usage information.

www.allmysocials.com/directory/tutorials/item/233-substitution-usage

Hi,

Thank you for the answer. I read the article, and I still have questions:

"The user [username] lives in [cb_citystate] and his name is: [name]."
[username] is specific to the current user: it should correspond to a joomla parameter, for instance $user object etc. Then, do you have a list for all the available FIELD_NAME and their correspondance in joomla?

Then, do you have a list for all the available FIELD_NAME and their correspondance in joomla?

Navigate to CB > Field Management and that's a list of all fields you can substitute.