Skip to Navigation

Reply to comment

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: and

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



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.

© 2016 QuickBase, Inc. All Rights Reserved.

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