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
jaishrijaishri 

I want create a autonumber field Display format is ALG-ABC-10-001 Country code ,Account name ,present month and sequence number can anyone help me how to create field

Best Answer chosen by jaishri
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Jaishri,


 You cannot include any fields in the auto number format.
 
But ths solution would be as below
 
1. create a auto number type field, hide it from all page layouts
 
2. Create a field of type text or formula which will populate the value based on the formula we need or a flow to populate this field.

Let me know if this type of solution works so I can provide you the formula or flow which ever best suits here.

Thanks,

 

All Answers

Sai PraveenSai Praveen (Salesforce Developers) 
Hi Jaishri,


 You cannot include any fields in the auto number format.
 
But ths solution would be as below
 
1. create a auto number type field, hide it from all page layouts
 
2. Create a field of type text or formula which will populate the value based on the formula we need or a flow to populate this field.

Let me know if this type of solution works so I can provide you the formula or flow which ever best suits here.

Thanks,

 
This was selected as the best answer
jaishrijaishri
On billing object I'm fetching the account name what is formula for this
Sai PraveenSai Praveen (Salesforce Developers) 
Hi JaiShri,

Can you confirm what is the relation between Billing object and Account and which is child and parent here.

Thanks,