About Record ID# 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.

Some field types (List-User, Multi-select Text, and File Attachment, for example) may not be changed. The Change Type link will not be present if this is the case.

Related Topic:

Unique

Select this option...

If you want to...

Must be unique

Ensure that every entry in this field is different.

This is useful for fields that contain information such as product serial numbers or ID numbers.

Check existing entries for duplicate values

Change a field in an existing application to require unique values and want to require that all previously entered data is unique.

To display this option, select Must be unique.

If Quick Base finds existing values in this field that aren't unique, an error message appears and Quick Base clears the Must be unique checkbox. If this occurs, you can do one of two things:

  • Sort the field to find duplicate values, make corrections as necessary, return to the Properties page, then select both Unique checkboxes again.

  • Select Must be unique if it doesn't matter whether existing data in this field is unique or if you want only new entries in this field to be unique.

Commas

Select one of the following options...

To...

No Commas

Not display commas in numeric values.

Commas after 3 places

Display commas in numeric values larger than 999.

Commas after 4 places

Display commas in numeric values larger than 9999.

Value Display

These properties apply when the field appears in table and timeline reports.

Select one or more options...

To...

Display in bold

Display the data in bold.

Display without wrapping

Prevent the data from being broken into multiple lines.

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:

 

Go back      |       |   

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