|
|
|
About Concatenated FieldsA concatenated field is a field that can display the values from multiple fields and can also display additional text. Your administrator can set up concatenated fields for most record types. For example, your administrator might set up a concatenated field called Profile on the Contact record type to show the value of the Job Title field and the Age field in the following format: Job Title, aged Age Your administrator can then add the field to the Detail page layout for the Contact record type. If a contact's job title is Manager and the contact is aged 41, then the Profile concatenated field for the contact shows the following: Manager, aged 41 If you have the necessary permission to edit the fields that appear within a concatenated field, then you can edit the fields through the concatenated field. In the example described earlier, you can change the job title of the contact by editing the concatenated field, but you cannot change the age of the contact. The age of the contact is calculated from the date of birth on the contact's record, and the Age field is not an editable field. Your administrator can also include expressions in the configuration of a concatenated fields. These expressions might determine the behavior of the fields and text within the concatenated field. For example, a concatenated field might be set up with an expression that results in certain text within the concatenated field being changed or removed if you change the value in another field on the record. As another example, a concatenated field might be set up with an expression that results in a default value being displayed in a field within the concatenated field, if the same field on the record is blank. The concatenated fields can appear on record Detail pages and Edit pages, on List pages, and in related information sections. However, you cannot use the concatenated fields as search fields or as filter fields for lists. Depending on how your user role is set up, you might be able to use the fields within the concatenated fields as search fields and as filter fields for lists. Related TopicsSee the following topics for related information: |
| Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices. |
