Documentation Index

Fetch the complete documentation index at: https://help.quickbase.com/llms.txt

Use this file to discover all available pages before exploring further.

Formula - duration field properties

Prev Next

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

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

Formula

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

  1. Select Select a Function to open the Quickbase Formula Functions dialog box.

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

  3. Select the formula you want, then select Insert.

Permissions

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

  2. Select either None, View, or Modify for each role.

Searchable

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

Reportable

  1. Select Add this field to all new reports to display this field as a column when users create but don't customize reports.

  2. Select The field may be used in reports to use this field in reports.

Shared values

  1. Select Values from this field may be a source for dropdown lists in other apps, then select Add App.

  2. Select an application, then select OK.

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 (Information icon) icon next to the field.