# Hello Glide Family, Generate SKU from user input

**URL:** <https://community.glideapps.com/t/hello-glide-family-generate-sku-from-user-input/75398>\
**Category:** Ask for Help\
**Created:** [August 3, 2024, 12:29pm UTC](https://community.glideapps.com/t/hello-glide-family-generate-sku-from-user-input/75398 "2024-08-03T12:29:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kuyeang\_Tea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kuyeang_tea/32/77976_2.png) [@Kuyeang\_Tea](https://community.glideapps.com/u/Kuyeang_Tea)\
**Post date:** [August 3, 2024, 12:29pm UTC](https://community.glideapps.com/t/hello-glide-family-generate-sku-from-user-input/75398/1 "2024-08-03T12:29:39Z")

</div>

Hello Glide Family I’m a newbie here, A few days ago, my relative asked me a favor to create a jewelry inventory management system for him, so I challenged myself to make one, but here is where I ran into a problem and needed some help.

SKU I try to create follow by:  
Jewelry Type-Model Design Number-Design Variation-Material  
EX: RM-1001-001-GD

A. Jewelry Type choice: Men Ring, Women Ring, Pendant, Stud Earring, Necklace, Bracelet, Bangle.

B. Model Design Choice:  
+Start from 1=Diamond Design For example RM-1001  
+Start from 2=Gemstone Design For example RM-2001  
+Start from 3=No Gem or Diamond Design For example RM-3001

C. Design Variant:  
Starting from 1 then increment by 1  
for example RM-1001-01, RM-1001-02, RW-1001-01, RW-1001-02

D. Material:  
GD= Gold  
SL=Silver  
Final SKU look=  
RM-1001-01-GD = Men Ring Diamond Design 1 Variant 1 with Gold  
RW-2002-01-GD = Women Ring Gemstone Design 2 Variant 1 with Gold

Finally, the question is, how do I match Model Design with its Varaint and increment by 1 when a new one is added?

Thank In Advance 🫂

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 3, 2024, 1:10pm UTC](https://community.glideapps.com/t/hello-glide-family-generate-sku-from-user-input/75398/2 "2024-08-03T13:10:51Z")

</div>

> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

Hope this helps. Your case is a bit more complex due to the relation between model design choice & variant, but the thread above should give you enough to start.

---

<div class="post-metadata">

**Author:** ![Kuyeang\_Tea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kuyeang_tea/32/77976_2.png) [@Kuyeang\_Tea](https://community.glideapps.com/u/Kuyeang_Tea)\
**Post date:** [August 3, 2024, 1:41pm UTC](https://community.glideapps.com/t/hello-glide-family-generate-sku-from-user-input/75398/3 "2024-08-03T13:41:54Z")

</div>

Thank you so much I’ll check it out