Displaying Multiple Fields in the Title Field
* You cannot select multiple fields to be used for the Title Field, in the Title Field settings.
Setting Title Field
If you want to display multiple fields in the Title Field, you can use the "&" operator in the Text field to concatenate strings.
You can also use the DATE_FORMAT function to concatenate values of a "Date" field or "Time" field with a string.
For example, you can concatenate customer name and the value of the Date field, and use that for the Title Field.
& Operator: Concatenating Strings and Numbers
DATE_FORMAT Function: Specifying the Display Format of Date and Time
Steps
-
Set a field code for the field you want to display in the Title Field.
- Open the Form settings screen by clicking the App Settings icon (the gear-shaped icon) at the upper right of the "View" screen.
- Open the settings of the field whose name you want to display in the Title Field.
- Check the string set under Field Code. If necessary, edit the string and save the changes.
For details on how to set a field code, refer to Overview of Field Codes.
-
Set up a "Text" field.
- Click the Text field in the field list on the left and drag and drop it into the frame on the right side of the screen.
- Open the setting screen of the Text field, select "Calculate automatically", and then specify a formula.
Example1: When concatenating a lead title and a person in charge (concatenating strings)
Formula: Lead_title&"-"&Person_in_charge
Example2: When concatenating an activity date and a customer name (concatenating a date and a string)
Formula: DATE_FORMAT(Activity_date,"YYYY-MM-dd","Etc/GMT")&" "&Customer_name
- Fill in other information as needed, and then click Save.
- Click Save Form on the upper left side of the screen.
-
Set the Title Field.
- Select the App Settings tab, then click Title Field.
- Click Set manually.
- Select the "Text" field that you set in step 2, and click Save. For details on how to set the Title Field, refer to Setting Title Field.
- Click Update App on the upper right side of the screen, and click Update App on the confirmation dialog.
This Title Field will be displayed as a header for notifications and search results.