Forum Discussion

KevinHenri's avatar
KevinHenri
Qrew Member
9 years ago

Exporting to excel appends characters to the user field

When I export a report to excel, a user column (sales supervisor) exports to excel as "user name with the number being some random combination. How do I avoid this being appended in the excel file?
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    9 years ago

    You can create a formula text field and export that instead:

    usertoname([user field])

    This will convert the user field to a plan text field.

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    No problem.

    Make a new formula text field called [User Name] with a formula of
    UserToName([Sales Supervisor])

    Use that on your report instead.