Custom Formula fields do Not support which of the following functional expression?
Click on the arrows to vote for the correct answer
A. B. C. D.C.
Custom formula fields in Salesforce are used to create new fields by combining existing fields or performing some operations on them. These fields can be used in reports, page layouts, and other areas of Salesforce. When creating custom formula fields, there are certain functional expressions that are not supported. Let's go through each answer option one by one:
A. Adding multiple records together: Custom formula fields can perform various mathematical operations, including adding, subtracting, multiplying, and dividing values. However, they cannot add multiple records together. For example, you cannot create a formula field that adds the total number of opportunities for an account.
B. If/then/else conditional statements: Custom formula fields support conditional statements, which can be used to display different values based on certain criteria. However, they do not support the if/then/else statement directly. Instead, they use a similar statement called the IF function. The syntax for the IF function is as follows: IF(logical_test, value_if_true, value_if_false)
C. Clickable image buttons: Custom formula fields do not support clickable image buttons. However, you can use formula fields to display images based on certain conditions. For example, you can create a formula field that displays a red icon if a case is unresolved and a green icon if it is resolved.
D. Combine text strings together: Custom formula fields support concatenation, which is the process of combining text strings together. You can use the & operator to concatenate values. For example, if you have two fields called "First Name" and "Last Name", you can create a formula field that displays the full name as follows: [First Name] & " " & [Last Name]
In summary, the functional expression that is not supported by custom formula fields is adding multiple records together. The other options are all supported, albeit with some slight differences in syntax or functionality.