Formula - date / time field properties

The properties for this field type are:


Enter a name for this field. This name displays on data-entry forms and as column headings in reports.


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:


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 Quick Base finds existing values in this field that aren't unique, an error message appears and Quick Base clears the Must be unique checkbox. If this occurs, you can do one of two things:

  • Sort the field to find duplicate values, make corrections as necessary, return to the Properties page, then select both Unique checkboxes again.

  • Select Must be unique if it doesn't matter whether existing data in this field is unique or if you want only new entries in this field to be unique.


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:


Quick Base date and time fields display in the following format: 07-08-2012 03:45 PM. To format the date differently, select one or more of the following checkboxes:

Select this option...

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, Quick Base 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.

Tip: Select Show the month as a name to display the date as Jul 08, 2012.

Show the time

The time and the date. For example, 07-08-2012 03:45 PM.

Note: Quick Base turns on this option automatically. It's the default.

Show the time zone

The time zone after the date and time. For example, 07-08-2012 03:45 PM (PST).

Value Display

These properties apply when the field appears in table and timeline reports.

Select one or more options...


Display in bold

Display the data in bold.

Display without wrapping

Prevent the data from being broken into multiple lines.


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:


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:

Shared values

To make entries in this field available as choices in another field:
  1. Select Values from this field may be a source for dropdown lists in other apps, then click Add App.

  2. Select an application, then click OK.

Related Topic: