Please help... Some numbers show instead of user name

[asimzaidi]

I had this working perfectly but then I tried to change my list view where everything got messed up. Now in my Lead list view, when I put Assigned to field, instead of the users name it shows some unique numbers from the database.
Could someone tell me whats going on.
Thanks

[ptemplin7]

Looks like you have a DB error.

Use the admin section to rebuild your custom fields and repair the database. Make a BACKUP FIRST!!!

This should clear it. What's happening is you are getting the hash instead of the text. You may have a db corruption as well and need to revert to a backup. Search around there are lots of instructions to use mysql to fix your database.

You do have a backup i hope.

Try it and see if it clears things up.

Paris

[Angel]

That is normal/expected behavior, as that field references the user's id, not the name (yes, it is confusing). Try using the User field in its place, that should resolve the problem.