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 report, with a custom column that converts the user data type to a text type. Then you can export the records from this particular report 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 report. 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

For more information, please see our Use a Calculated (Formula) Column in a report help topic.

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.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit