Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Sku creation - part numbers

207 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello-

I saw this formula for creating SKU’s based off of Single Selects and codes:

SWITCH(
{Product Category},
“Mural”, “MUR”,
“Magnets”, “MAG”
) & “-” &
SWITCH(
{Class},
“Economy”, “EC”,
“Deluxe”, “DX”,
“Premium”, “PM”,
“Platinum”, “PT”
) & “-” &
SWITCH(
{Substrate},
“Canvas”, “CN”,
“Wood”, “WD”
) & “-” &
SUBSTITUTE({Size}, " x ", “”) & “-” &
SUBSTITUTE({Product Name}, " ", “”)

My Question is: Is there a way to not specifically call out the IF selected in the field types, basically what ever you select becomes the “CODE” - because I have thousands of selections that would not work here - would take me forever to write and I don’t want to have to add new ones as the new parts come in - make sense?

2 Replies 2

I’m not entirely sure what you’re asking for. The example you gave shortens specific words in a not-necessarily-uniform way. If “whatever you select becomes the code”, what else is there to do?

It would help if you provided what your data currently looks like (screenshot) and then describe exactly what its supposed to look like.

Basically anytime you select any drop down selection, it auto populates with the code it’s attached with creating the SKU # from the formula built in. But I don’t want to have to add in all of the options is what I am asking if there is a workaround.

Thank you for your help.