About Formula-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.

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:

Formula

Enter the formula to generate the value this field shows. When you click the Formula text field, a Fields & Functions list appears.

  1. Click Select a Function to open the Quick Base Formula Functions dialog box.

  2. Select or search for the type of function you want from the list.

  3. Click the formula that you want, then click Insert.

Related Topics:

Value Display

These two 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...

Full Name

Display the first name and last name of the user.

Note: If a user doesn't enter a full name during registration, Quick Base displays the email address.

Last Name, First Name

Display the full name of the user, but with the last name displaying first. This format lets you create reports that correctly sort by last name.

Note: If a user doesn't enter a full name during registration, Quick Base displays the email address.

User Name

Display the Quick Base user name of the user.

Note: If a user doesn't have a user name, Quick Base displays the email address.

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 Quick Base 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:

 

Go back      |       |   

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