Auto calculating ID numbers depending on the product type.

[tstoney]

I'm working on an Inventory app and would like the app to auto generate a new item number (Last number+1) based on the users choice of product category. The rub here is each product category has a different numbering system (for example one product type is 100001, another is 400001). How can i do this so the user doesn't have to do any extra review or investigate what should be the next number?

[SkrOYC]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Serial-Numbers-If-You-Must/m-p/286300