function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
WPCMSWPCMS 

Creating an Auto Number concatenation

I know how to set up auto numbers with letters in SF and I know how to set up a concatenation in a formula for SF. But I need to combine the auto number and fields to create a unique purchase order number. What would the formula be?

Basic Example:

 

"SC"&&(Salesforcefield)&&{AUTONUMBER}  I don't know how to include an autonumber.

 

Basically I want the PO to start with SC, have a SF field in the PO and then end with a counting number.

 

SCWMI1001   or SCASR1002 or SCASR1003

 

Thank you in advance.

JakesterJakester

Create an autonumber field, then create another field that's a text formula field that concatenates those 3 things. Assuming the salesforcefield is a picklist, it will look something like this:

 

 

"SC"+text(your_picklist__c)+your_autonumber__c
 
 
 
 


max4904max4904
I want to concatenate 3 object fields into a new custom field so I can have a new Account Plan Name field that equals Account Name + Planning Year + Created Date. What is the simpliest way to accomplish this?  Can this be done as a formula field?
 
Thanks for your help.