Serial Number Generator

[faandayoday]

Halo,

Bisakah saya membuat beberapa serial number berdasarkan quantity di suatu produk?

Misalnya :

Produk   : A

Quantity : 3

Serial number : ?

[Nadhirah]

Do you have any example on how the serial number should be?

[faandayoday]

Hi Nadirah,

For example, Product A, can I generate the serial number based on the total qty? For example, I will generate 5 serial numbers from product A. I enter product A, Qty 5. Later, 5 serial numbers will come out. (A001,A002,A003 etc.)

[faandayoday]

SKU	Qty	Serial Number(results)
Product A	2	A001 , A002
Product B	1	B001
Product C	3	C001 , C002 , C003

[Denny774]

Hey man,

you can try this:

RobinsonList[Sequence-Number] = {1..n}    <-- (e.g. can be a GSheet Table)
[Sequence-Prefix] = "ABC"
[Sequence-Suffix] = "XYZ"
[Sequence-Start] = 1
[Sequence-End] = [_THISROW].[Quantity] = 3

LIST(CONCATENATE([Sequence-Prefix], SUBSTITUTE(TEXT(SORT(
  SELECT(
    RobinsonList[Sequence-Number],
    AND(
    ([Sequence-Number] >= [Sequence-Start]),
    ([Sequence-Number] <= [Sequence-End])
    )
  )
)), " , ", CONCATENATE([Sequence-Suffix], " , ", [Sequence-Prefix])), [Sequence-Suffix]))

OUTPUT:

{ABC1XYZ,
 ABC2XYZ,
 ABC3XYZ}

Cheers