Next Step Fields

Next Steps Historical Field

This section will cover how to create and use custom fields and labels to track historical changes to the Next Steps field on opportunities in Salesforce.

Custom Fields

  1. Next Steps Historical: Long text area field with a maximum length of 131,072 characters. Stores historical comments added to the Next Steps field.

  2. Next Steps Last Updated: Datetime field that stores the date and time when the Next Steps field was last updated.

Custom Labels

  1. Line Break: Custom label with a value of two dashes separated by a return. Used to create line breaks in formulas.

Flow

  1. Record Triggered Flow: Triggered when an opportunity is created or updated.

  2. Entry Condition: Triggers when the Next Steps field is changed.

  3. Assignment Elements:

    • Next Steps Historical: Updates the Next Steps Historical field with a formula that includes the date, user who made the change, stage of the opportunity, and the text added to the Next Steps field.

    • Next Steps Last Updated: Updates the Next Steps Last Updated field with the current date and time.

Formula for Next Steps Historical Field

The formula for the Next Steps Historical field is as follows:

TEXT(TODAY()) & '-' & USERFIRSTNAME() & ' ' & USERLASTNAME() & '-' & TEXT(Record.StageName) & '-' & Next_Step__c & SUBSTITUTE(Line_Break_Short__c, '--', '') & Next_Steps_Historical__c

This formula includes the following elements:

  • Today's date in text format

  • First name of the user who made the change

  • Last name of the user who made the change

  • Stage name of the opportunity

  • Text added to the Next Steps field

  • Line Break custom label to create line breaks

  • Next Steps Historical field value

The formula uses the SUBSTITUTE function to replace the two dashes in the Line Break custom label with an empty value, which creates a line break in the formula.

Usage

To use the Next Steps Historical field, simply add comments to the Next Steps field on an opportunity. The comments will be automatically added to the Next Steps Historical field, along with the date, user who made the change, and stage of the opportunity.

You can also use the Next Steps Historical field to create reports and dashboards to track historical changes to the Next Steps field.

Last updated

Was this helpful?