I actually have this requirement in two different aMember databases so this would be a huge help if there is a solution to this. I have a custom user field called 'Member Number'. I would like this field to be auto populated during user creation. The number would also need to be auto-incremented.
My existing members numbers cant change, so what would I do export and import all users and assign member number to user_id? I thought I read somewhere on the forums that user_id should not be used/treated as a static number that will never change.
user_id never changed. You can use any unique integer numbers for it for new users (import) but you can not alter user_id for existing users.