List-user fields: importing, exporting, and printing

If your app contains list-user fields, you should understand the rules for importing data into these fields. You should also understand what you'll see when you export or print data in these fields.

Rules for importing into list-user fields

The rules for importing data into a list-user field are the same, regardless of whether you are importing from an Excel file or a csv file, or copying/pasting from the clipboard:

  • You import users using email addresses. If you've already exported data from your app, you can also choose to use the hashed user IDs that Quick Base exports for each user.

  • Separate users in the import list using a semi-colon.

An example of data that is valid for import appears below:

jdoe@example.com;ksmith@example.com;sconnolly@example.com

What you'll see when you export data

If you export data from an app that contains list-user fields, you'll see that Quick Base exports a list of users, separated by semi-colons. The entry for each user is made up of the following:

  • User's full name, email address, or user name AND

  • the hashed user ID

The following example shows you how an export of a record containing a list-user field might look. You can see that a comma is used to separate fields in the record; and within the list-user field, users are separated by semi-colons (shown in bold font).

Task name,Assigned to,Project name,Date Created,Date Modified,Record ID#,Record Owner,Last Modified By

Documentation Review,John Doe <56766236.cdxb>;Kelly Johnson <56772365.dbtk>;user2@example.com <56765724.dqyq>;user3@example.com <56765736.w6ef>,Feature Development,03-14-2011

What you'll see when you print data

When you print a record that contains a list-user field, you'll see that users in the list-user field are separated by semi-colons. Each user is identified by the user's first and last name, email address, or Quick Base user name.

Related Topics: