Serial Number Generator

AppSheet AppSheet Q&A
,
1

Halo,

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

Misalnya :

Produk : A

Quantity : 3

Serial number : ?

2

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

3

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

4

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.)

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