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
autochicautochic 

Formula to return an auto-number field

I am looking to create a formula field that will return an auto-number.
Example:
If Status = Next Step then "New Field" auto-populates the next sequential #.
Any pointers?
Thanks!
NPMNPM

Here is a way that I have used, it may not be perect for your described need but may it can be built upon.  I have a checkbox field (Assign_Firm_Member_Number__c) that when checked the formula field (Generated Firm Member Number) gets set to the value of the autonumber field (Fund_Record_Num__c).

Generated Firm Member Number

 

IF(  Assign_Firm_Member_Number__c  ,  Fund_Record_Num__c , "")

 

 

This does not give the next sequential number (as you askled for) as the autonumber field (Fund_Record_Num__c) increments whenever a new record is created and some new records do not need a Firm Member Number generated so these are not in sequence, but are always unique.

 
autochicautochic
Thanks for the suggestion. I have presently got something very similar, thinking along the same lines as to generate a UNIQUE number. However, they are saying that the sequence is of great importance.
I have now created a new custom object that has an auto-number field. Since I cannot rollup the auto-number, I may be faced with pushing all fields into this custom object creating a sizable project that was already finished.
Again - thanks for taking a look!