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 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
- 35048 reads
