About Address Field Properties

The Address field is unusual because it contains several subfields.

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.

Format

Select International or United States.

Countries

If you selected International for the Format property, the Countries property will be available. You may restrict the field to specific countries. You can restore all countries to the list by clicking Reset Countries.

Width of input boxes

Enter the desired width of the input boxes in pixels. Default value is 60 pixels. Width of Zip Code input boxes is 50% of this value.

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:

Auto-fill

Select to copy the value when copying a record.

Searchable

Select to allow the field to be included when searching or filtering the table.

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:

Shared multiple-choice

To make entries in this field available as choices in a multiple-choice field in another table or another application:

  1. Select This field may be a source for shared multiple-choice lists for other apps, then click Add App.

  2. Select an application, then click OK.

Related Topic:

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:

Field help text

If you wish to provide help text in association with this field, enter the text in the text box. This text will display via the information () icon next to the field.

 

Return to top   

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