List-User Fields: Importing, Exporting, and Printing

If your application 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:

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:

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:

 

Go back      |       |   

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.