Setting a Date Field as the Title Field

You cannot specify a Date field as the record title field.
Fields that can be specified as the title field are as follows.

  • Record number
  • Text
  • Text Area
  • Rich text
  • Number
  • Calculated
  • Lookup

As an alternative, you can use a "Calculated" or a "Text" field that can be specified as the title field, to display the "Date" field content in the title field.
In that case, you need to set a formula that displays contents of a Date field in a Calculated field or a Text field, and then set the field as the title field.
The steps are as follows.

Steps to Use a "Calculated" Field

  1. Check the field code of the Date field that you want to display in the title field. Image

  2. Place a "Calculated" field, and click Settings under the setting button Setting button. Image

  3. Enter the field code of the "Date" field that you checked in Step 1 in the "Formula".
    Select "Date (Aug 06, 2012)" as the display format, and click Save. Image

  4. Click "Save Form" on the upper left side of the screen.

  5. Specify the "Calculated" field as the title field.
    Setting the Record Title

You can complete the setting by updating the app.

Steps to Use a "Text" Field

In order to display contents of the "Date" field in a "Text" field, you need to use "DATE_FORMAT" function.

  1. Check the field code of the Date field that you want to display in the title field. Image

  2. Place a Text field, and click Settings under the setting button Setting button. Image

  3. Select "Calculate automatically", enter a formula, and then click Save.
    If the field code that you checked in Step 1 is "Date", enter a formula like the following.
    DATE_FORMAT(Date,"YYYY-MM-dd","Etc/GMT")
    DATE_FORMAT Function: Displaying Date and Time Using Formulas
    Image

  4. Click "Save Form" on the upper left side of the screen.

  5. Specify the "Text" field as the title field.
    Setting the Record Title

You can complete the setting by updating the app.