Thanks, Kyle. That looks easy to accomplish.

However, I have to abandon the idea of username-to-email conversion due to potential security vulnerabilities, since users' profile URLs will now include their email address.

Would converting a username into an incremental numeric or alphanumeric ID be as easy as this one? It doesn't have to add the user's name to it, just the numbers and maybe letters. Could you please provide an example?

Thanks a lot!

Kyle, will RAND() generate a unique random number?

If yes, could you please give the actual code? Many thanks.

Hi Kyle,

Thanks for that, my issues of the validation running and the javascript popup showing before the registration was completed is due to the fact that I am using this on an live site with users already in the database.

So I was hitting the issue that the validation was kicking in showing the javascript popup and not completing the registration so no auto action is being triggered.

Not a great way but to solve this in my case and eliminate any issues in the future, I am going to have run an update against all my current users and amend their records, to get rid of the username field using their name.



Sorry timurdavidov and Kyle for trying to solve the question with changing the code I was seeing the issue from my side with user records already being entered. On a new site Auto actions will just work and everything will be fine.

In future I will remember that a lot of readers on here are new to CB and using fresh installs with possibly just an admin in the database, unlike what I am doing.
As it does make a difference to the way CB reacts.

Apologies again for any confusion I caused.

Mike