How to combine and display dates and strings?

Article Number：010212

By utilizing the auto-calculation feature of the "Text" field and configuring the `&` operator and the `DATE_FORMAT` function, you can combine and display the values of the "Date" field and the "Text" field.

○Preparation

Place the following fields in the form of the app settings and set field names, field codes, and formulas for each.

Text Field
・Field Name/Field Code: Customer_Name
Date Field
・Field Name/Field Code: Date
Created_by Field
・Field Name/Field Code: Created_by

Text Field
・Field Name/Field Code: Project_Name
・Formula:

Customer_Name & " " & DATE_FORMAT(Date,"MM-dd","system") & " " & Created_by

Note

Using the `DATE_FORMAT` function allows you to treat dates, date-times, and times as strings.
If you do not use the `DATE_FORMAT` function, the date value will be displayed in seconds, making it difficult to interpret as a date.
By setting the auto-calculated "Text" field as the record title, it can also appear in notification headers and as the title in calendar views.
Displaying Multiple Fields in the Title Field

＜References＞

Search

How can I help?

Note