Hello Glide Family, Generate SKU from user input

[Kuyeang_Tea]

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

[ThinhDinh]

How do I create an auto-incrementing row number with Glide Tables?

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.

[Kuyeang_Tea]

Thank you so much I’ll check it out