About List-User Field Properties

The properties for this field type are:

Label

Enter a name for this field. This name displays on data-entry forms and as column headings in reports.

Type

Click Change Type to change the field type.

Related Topic:

Required

Select A value is required to force users to enter a value in this field. A red asterisk (*) beside a field in Add and Edit forms indicates that this value has been set for the field.

Default Value

Select this option... If you...

None

Don't want to specify a default value.

Current user

Want the user, who creates the new record, as the default value for this field.

A specific user

Want to specify a particular user as the default value for this field.

Select A specific user, then select a user from the list that appears, or search for a user.

Choices

You can use the default user set or create your own custom user set for field options.

To determine who is in your default set:

Click Users on the Table bar, then view the users in the Show in User pickers column. These users are members of the default user set.

Select one of the following field options:

Optionally, unselect Allow users to create new choices if you don't want users to add choices to the list.

Tip: Leave the Default Value option blank to initially show nothing in the list.

Related Topic:

Value display

Select this option... To display...

Display in bold

The data in this column (or field) in bold.

Display without wrapping

The entries in this column (or field) without wrapping. The entries appear on the same line.

Permissions

To set the permissions:

  1. Click Restrict access by role to limit access to the data in this field.

    When selected, the Role and Permission list appears.

  2. Select either None, View, or Modify for each role.

Note: This property is not available to accounts on the QuickBase Essential plan.

Related Topic:

Reportable

To use this field in reports:

  1. Select Add this field to all new reports to display this field as a column when users create but don't customize reports.

    When selected, automatically selects The field may be used in reports option.

  2. Select The field may be used in reports to use this field in reports.

    If you want the field to be a default column, you must select this option.

Related Topics:

Snapshot

To capture a value from a specific lookup field:

  1. Select Get this field's value from a lookup field and don't allow the value to change.

    When you capture the value of the lookup field in a snapshot, the value in the snapshot field in the details table doesn't change when you change the master record.

  2. From the Lookup field list, select the lookup field for which you want to capture the value.

  3. Select Initialize field for existing records to update all the existing records with a snapshot of the current value when you set up a snapshot field for an application.

    Caution: If you select this option and this field contains existing values, the existing values are overwritten with the current value in the master record.

Related Topics:

 

Return to top   

© 1999-2014   Intuit Inc.  All rights reserved.  Legal Notices.