0

I have an AutoNumber field in my leads. I'm assigning leads based upon the last digit of that field. Salesforce says the following code has no syntax errors:

RIGHT(RoundRobin__c, 1) == text(1) || RIGHT(RoundRobin__c, 1) == text(4) || RIGHT(RoundRobin__c, 1) == text(7) || RIGHT(RoundRobin__c, 1) == text(0)

However, the AutoNumber field seems to me like it must be a number, not a string. When I try to convert to a string, it says that RoundRobin__c is of type "text" and therefore the conversion isn't necessary. I just wanted to make sure that this won't cause any problems with my logic.

1

The maximum length of an Auto Number field is 30 characters, 10 of which can be the number and 20 of which can be the prefix.

Your starting number must be less than 1,000,000,000, which means that the most that you can start it out at is 999,999,999. That means that in the worst configuration you could make you'd still be able to create ~9 billion records (9,999,999,999 - 999,999,999) before you'd reach the maximum allowed. I don't know what happens when it hits 11 digits, although if the docs state the max is 10 digits then I'd expect an error.

Check out the doc page on custom field attributes, specifically the Staring Number entry.

|improve this answer|||||
  • Custom field attributes help.salesforce.com/apex/… – sfdc_Learner Oct 5 '15 at 13:43
  • Right, but I'm asking if AutoNumber is a number or a text field. It seems that it is a text field because I can't convert it using text(). – AKor Oct 5 '15 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.