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?