302 Found

Found

The document has moved here.

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

Why is there a number after a user name when I export to a file out of QuickBase?

This number is the UID for the users in QuickBase. This number captures the unique user (e.g. John Smith is not sufficient, as many John Smiths could use QuickBase). This number is exported with the name because the field/column type is of user, so whenever a user field is exported, it contains this UID number. This is important for users who update via a spreadsheet and then update the records by importing them back into QuickBase. If the UID was not there, then QuickBase would not be able to handle the update as gracefully and in an automated fashion.

The workaround in your case, if you want just the text, is to add a new view, with a custom column that converts the user data type to a text type. Then you can export the records from this particular view without the UID.

The formula you should use in the custom column is UserToName(["Enter the field name of your user type field here"]) and make sure the column is listed in the view. You can also remove the user type column. More details about UserToName() are available here: https://www.quickbase.com/db/6ewwzuuj?a=dr&r=e5&rl=biam and https://www.quickbase.com/db/6ewwzuuj?a=dr&r=e6&rl=biam

More information about a custom column in your view is available here: https://www.quickbase.com/help/default.html#custom_column_in_view.html

Tags:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.