Solved: Auto sku id appsheet - Page 2

aminsaleh · 07-08-2023 10:51 AM

Hello, how are you all

can I create a unique ID formula that generates sku for each item.

For example: I have a table called (Items)

Columns called (category), (sub category), (color),

example: (office) (Desk) ( Brown)

I want to have an sku that concatenate one or two letter of first category and add a number. like this

office = Of

Desk= D

Brown = Br (If two colors start with B... take different letter) for example for brown take B and for black take k.

so new sku will be

of-d-b-001

dbaum

See Concatenate values with a delimiter: How to simula... - Google Cloud Community . For example:

SUBSTITUTE(
    TEXT(
      LIST(
        [Category], 
        [Subcategory], 
        [Color], 
        UNIQUEID()
        )
      ), 
    " , ", 
    "-"
)

In the draft expression, you can substitute each column reference with a more detailed expression to return just the abbreviation that you want. For example:

LEFT([Category], 2)

SWITCH([Color], "Brown", "br", "Black", "bk", LEFT([Color], 1))

View solution in original post