Auto Action query doesn't update username

I did set it to after registration before so member ID was generated for anyone who registered. However, this means if a user is not approved by the committee the member ID will be 'wasted' and there will be gap in the member ID of the active/approved members. My client's policy is they will give membership ID only to approved member.

So technically, yes, executing the SQL after registration works and guarantees correct details sent out in the Welcome email. It's just that the workflow doesn't suit the business policy so I had to find another way

There is also onBeforeUserActive and then onUserActive, which you can try and see if either will fit your needs. Both are fired before the email is sent and onUserActive is triggered after all user storage so maybe it'll work.

Excellent! I'll give them a try. Thanks Kyle!!

UPDATE:
I can't find onUserActive in the dropdown, only onBeforeUserActive. However, it's fired right after submitting the registration form.

Use onUserActive, but add a condition to ensure [approved] is Equal To 1, maybe that'll do the trick. Did you try onBeforeUserActive?