Multi-select text 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.

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 (;).

Input type

Select this option...

If you WANT TO...

User input

Let users type information into this field.

Multi-select Text fields do not show this option.

From list

Let users select an item from a list.

Type the items to be shown in the list, each item on a separate line.
If you don't want users to add choices to the list, unselect Allow users to create new choices.
Click Display choices in the order shown here to determine the order of the list, or click Display choices in alphabetical order.

From another field

Use values from another field in a list that appears in this field.

Click Select shared field, select an app, then click OK.
Select the field type you want, then click OK.
Click Display choices in the order shown here to determine the order of the list, or click Display choices in alphabetical order.

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.

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:

Field help text

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