You need to sign in to do that
Don't have an account?
SfDc@123.ax1389
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,
Developer
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.
Thanks
Hi,
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.
Hi
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
Newbie.
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,
Newbie.
Hi,
I think using Trigger in this condition is more appropraiate here.
Why...
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