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:
|
Enter the formula to generate the value for this field. You can either type the formula in the text field
Select one of the following options:
- Edit formula using a text field
- Type the formula that you want in the text field, or click the Fields & Functions list to select the formula that you want from the list.
- Select the type of function that you want from the list at the top of the Quickbase Formula Functions dialog box.
- Click the formula that you want, then clickInsert.
- Use the End Date formula builder
- Select the name of the field that specifies the start date for tasks from the Start date field list.
- Select the name of the field that specifies the length of time it takes to complete a task from the Time span field list.
- Optionally, select Work week is Monday–Friday.
Related Topics:
Format
By default, the date displays in the following format: 07-08-2008. To format the date differently, select one or more of the following options:
Select any of the following options... |
To display... |
---|---|
Show the month as a name |
The first three letters of the name of the month. For example, JUL-08-2012. |
Show the day of the week |
The day of the week and the date. For example, Sunday, 07-08-2012. |
Don't show the year for dates in the current year |
The date using commas, for example, 07, 08, 2012. If the date falls within the current year, Quickbase does not display the year. For example, if you enter 07-08-2012, and the current day falls within 2012, the date that appears is 07 08. |
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.
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.