+ Start a Discussion

Formula field for auto labeliing

Hi Force.com board,


                                       My requirement is creation of a formula field for the existing  auto number field. In detail If the auto number is 1 Formula field should retain the value 'A'.If it is 2 formula field should give 'B' and similarly upto 26 'Z'.And after that It should be given as 'AA' and should continue.I cant find a solution for this, So help in any form would be really appreciated.


Thanks in Advance,



   Dear new Bie,


   Here I need to clarify you between Autonumber and the Formula Field.


   Auto number and Formula fields are only generated upon saving the record.

   It's not possible to formulize your solution.








I don’t think you can do this through formula field because inside the formula fields you have to individual define all the value and after some time you will hit the max character limit used inside the formula field. So, I would suggest writing a trigger to achieve this.


Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 




here auto number is only for reference for the formula field. For example, the auto number on saving the record will give as 1 and formula field will show as A .I had taken CASE functionality inorder to check itand it worked fine upto 'Z'.But after that the sequence has to move on like 'AA'.So please help me on this.



Thanks in advance



HI ankit,


                 As you said I had created a trigger for the requirement but we cant increase the Alphabets in the order.If its number we can give   for(i=0;i<maxvalue;i++)  . BUt my requirement is to increase the alphabets in an order.Can you please explain this in an elaborated way



Thanks in Advance,


Pravesh RanaPravesh Rana



I think using Trigger in this condition is more appropraiate here.




Because for  calculating respective code for a digit say 90, you have to execute some loops, the number will keep on increasing and there will come a time when executed code will get higher than the code limit of a Formula field.


So what you should do is right a Trigger which execute on after INSERT of the record.


For Logic....


You can use something like dividing the auto number value by 26 and finding out how many thimes it get divided by it and the reminder..


Hope this helps