You need to sign in to do that
Don't have an account?
Auto-generating a Product Number Based on a Predefined Range
I'm developing a custom app to manage product numbering. I'm not using the Product functionality from core SFDC. I have the need for different product number ranges based on different product lines. For example: Product Line 1 = PN10000-PN19999, Product Line 2 = PN20000-PN29999, etc.
The custom app will create a record for every new product that we need. The sole purpose is to generate the product number. I plan on having a lookup field for Product Line that will help determine the range. Then I need to be able to find the last product number that was created in that range and increment the number by "1".
What's the best way to do that? Can formulas be used for this?
Thanks.