Loading

Issues with 18 Digit ID and not 15 Digit ID in custom Formula

Data pubblicazione: Oct 13, 2022
Descrizione
Why is it that when I build my custom formula in my org and I reference the 18 Digit ID that I get from Data loader, the formula never works, however, when I reference the 15 Digit ID I get from the URL of the record, or when I run a report, I have no issues?
Risoluzione

Formulas recognize information mainly from the User Interface (or UI) which deals with the 15 digit ID format.

 

When there is an ID with 18 Digits, that ID is usually from an export or another program that uses API integrations to send and receive the information.

With Formulas, the 18 Digit IDs are not recognized in the system because they are not in the UI.


An example of an 18 Digit ID formula that would not populate the information correctly would be:

IF(CreatedById = "00Xx0000000XxXxAAW" , "This will work" , "This will fail")

This formula field would always display "This will fail" because the formula is looking for an ID in the system that it would never find.

However, using the 15 Digit ID if the formula read as follows:

IF(CreatedById = "00Xx0000000XxXx" , "This will work" , "This will fail")

Then the fields would display "This will work" when the record was created by the user whose ID matches that ID because the system would be able to find it.

See Also:

Tips for Building Formulas

Note:  While referencing formula field in process builder,it is necessary to add 18 digit ID only.  Process builder formula will not work with 15 digit ID.
Numero articolo Knowledge

000386186

 
Caricamento
Salesforce Help | Article