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 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:
|
Default sort order
|
Select this option... |
To... |
|---|---|
|
Ascending |
Sort numeric values in ascending order. |
|
Descending |
Sort numeric values in descending order. |
Totals and averages
|
Select this option... |
To... |
|---|---|
|
Display a total of this field in reports |
Have Quickbase compute the sum of all the values in this field and display the result at the bottom of the view (totals row). |
|
Display an average of this field in reports |
Have Quickbase compute the average of all the values in this field and display the result at the bottom of the view (average row). |
Formula
Enter the formula to generate the value this field shows. When you click the Formula text field, a Fields & Functions list appears.
-
Click Select a Function to open the Quickbase Formula Functions dialog box.
-
Select or search for the type of function you want from the list.
-
Click the formula that you want, then click Insert.
Related Topics:
Decimal places
Enter the number of digits you want to appear after the decimal point. For example, you might enter 2 if the field is a price field. If a user enters more digits after the decimal point than you enter here, Quickbase rounds the number and extends it only to the number of decimal places you specify. Here are some examples:
-
.5 rounds the number away from 0.
-
3.5 rounds to 4
-
-3.5 rounds to -4.
Use the Round formula instead of the decimal places option to round up .5, meaning that -3.5 would round to -3.
Display Format
Choose the format used to display numeric values for this field. Organizations in the United States will typically use one of the first two options; organizations in other countries (or who have offices in multiple countries) may want to use any of these options.
To format your number without commas or decimal points, enter 0 in the box labeled Decimal places.
|
Menu option |
Numeric formatting |
|---|---|
|
12345678.00 |
Display numeric values with:
|
|
12,345,678.00 |
Display numeric values with:
|
|
1,23,45,678.00 |
Display numeric values with:
|
|
12345678,00 |
Display numeric values with:
|
|
12.345.678,00 |
Display numeric values with:
|
|
1.23.45.678,00 |
Display numeric values with:
|
Separators
Choose when separators appear in numeric values.
|
Menu option |
Separator formatting |
|---|---|
|
Show separator after 3 places |
Display the thousands separator after the value in the field has more than 3 places (i.e., non-decimal part larger than 999) |
|
Show separator after 4 places |
Display the thousands separator after the value in the field has more than 4 places (i.e., non-decimal part larger than 9999) |
Display as
|
Menu option |
Display results |
|---|---|
|
Simple number |
The number in this field, along with any decimals, separators, or negative signs that have been configured to display. All other characters are ignored. |
|
Star Rating |
The value in this field as 0-5 stars. For example, you might want to use this option in a movie or book review application. |
|
Percent |
The value in this field as a percentage. |
|
Currency |
A currency symbol of up to 10 UTF-8 characters, and set its placement relative to the number. Type the currency symbol into the Symbol field, either as an HTML character entity or in Unicode decimal format. For example, to display a pound sign (£), enter one of the following:
To specify the placement of the currency symbol, select one of the following options from the Position list:
|
Value Display
These properties apply when the field appears in table and timeline reports.
|
Menu option |
Result |
|---|---|
|
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.
Override sub-field access
Set to use the access permissions specified above in Permissions, even if the permissions are less restrictive than those of the sub-fields, which are the fields used to calculate this field's value.
Related Topic:
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.
Related Topic:
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.