Loading

Formula: Returning True on Record Creation or Specific Field Change

Дата публикации: Dec 8, 2025
Описание

It covers the usage of the ISNEW and ISCHANGED functions to achieve this logic.

Решение

To determine if a record is newly created or if a specific field has changed, use the ISNEW and ISCHANGED functions.

To return TRUE when "a record is created" OR "a specific field (e.g., Status__c) is changed", combine these functions using an OR condition.

The formula syntax is as follows:

 

Syntax Example 1 (Using the OR function):

OR(
    ISNEW(),
    ISCHANGED(Status__c)
)

Syntax Example 2 (Using the || operator):

ISNEW() || ISCHANGED(Status__c)

Note: This formula cannot be used in all locations. Refer to the ISCHANGED documentation in Salesforce Help to check where the ISCHANGED function is available (e.g., Validation Rules, Workflow Rules, Process Builder formulas).

Дополнительные ресурсы

OR

ISNEW

ISCHANGED

Номер статьи базы знаний

005232816

 
Загрузка
Salesforce Help | Article