Hey. I need some help scripting to generate next available SKU when adding a new product through an Interface.
My table is called PRODUCT MASTER and my column is SKU. Depending if product category (column category) is Software, Subscription or Hardware, it should look for and create the next available SKU number in the 100000, 200000 or 300000 range.
And how can I add this automation to the Interface form that I have created? Or do I need to add the automation to a button?
Appreciate any help! 🙂