Email address field properties – Quickbase Help

ZenTarget.4.log-1799136965.zip
20 KB Download

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:

About Field Types

Required

Select Must be filled in to require 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.

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 Quickbase finds existing values in this field that aren't unique, an error message appears and Quickbase 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.

Default value

Enter the value that you want for the initial entry or default for this field. For example, you can set the Status field to Open for the default, and users can change it, if they want.

For multiple-choice fields, you must enter a value that is in your list of choices. If you don't want any option to appear automatically, leave this field blank.

For Multi-select Text fields, you can specify a list of default values delimited by semi-colons (;).

Default Domain

Enter a domain name to add to every user name. You can use the default domain to enter the email addresses of your company into forms.

For example, if you work for Squeegee Makers, Inc., you can enter the domain name, "squeegeemakers.com," in this field. Then when you type an employee's email address in a form, all you need to enter is the name portion of the email address—Quickbase automatically appends @squeegeemakers.com to the entry when you click Save.

Email All

Select the Display an icon in the totals row to email everyone in reports checkbox if you'd like to include an Email icon in table or summary reports. Clicking the icon opens a new email in the default email client, addressed to everyone in this field that appears in the report.

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.

Select one of the following options...	To...
Display the entire email address	Display the entire email address.
Display just the part of the email address before "@"	Display the email, but not the domain name. For example, if the email address is jsmith@example.com, then only "jsmith" appears.
Display just the part of the email address before the first underscore "_"	Display the email up to the first underscore (typically, the first name of the user). For example, if the email address is john_smith@example.com, then only "john" appears. Note: If there is no underscore, the entire email portion of the email address displays.

Permissions

To set the permissions:

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

When selected, the Role and Permission list appears.
Select either None, View, or Modify for each role.

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

Auto-fill

Select Copy this value... to copy the value(s) in this field when the record is copied.

The command to copy a record is visible in the More menu when you're viewing the record.

Not all fields are good candidates for this option. For example, if you also select Unique, the value of this field is not automatically copied.

Searchable

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

Reportable

To use this field in reports:

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.
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 values

To make entries in this field available as choices in another field:

Select Values from this field may be a source for dropdown lists in other apps, then click Add App.
Select an application, then click OK.

Snapshot

To capture a value from a specific lookup field:

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.
From the Lookup field list, select the lookup field for which you want to capture the value.
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.