Track Row Duplicates Like a Sub-SKU

[Randy_Shoemaker]

Hi,

Here’s the scenario:

I have a row with a product. I want an auto generated number to assign to that product.

I want to then duplicate that row, but know that it is a duplicate of another row.

So - Product 001.1 gets duplicated, I want the duplicate to then show Product 001.2

If I create a new product (not duplicating), then that product would be Product 002.1, and so on.

Any ideas?

[JonathanBowen]

Hi @Randy_Shoemaker - you can’t use the autogenerate field type as this is a) an integer and b) unique:

However, as a workaround, you could enter the “product ID” and the “SKU ID” for each record and concatenate these into the unique ID you note above:

I’ve prefixed the product ID with zeros as you’ve done using the formula:

CONCATENATE((REPT("0", (3 - LEN(Product_ID)))), Product_ID, ".", SKU_ID)

Note that the product ID and the SKU ID need to be of type “single line of text” as you can’t perform the LEN() function on a number.

Hope this helps

JB

[Randy_Shoemaker]

Thanks, @JonathanBowen.

I know of this. I’m looking to track it with less manual input.

But thank you!

-Randy

[Justin_Barrett]

I figured there had to be a way to make this work, and after a lot of fiddling around, I managed to pull it off. This is something that has come up in other requests as well, so I’ll add it to the Show and Tell category for easier reference by all, then edit this post with a link once that other post is done.

EDIT: Here’s a screenshot of the final result. A second table and some helper fields aren’t shown, but all will be outlined once I get that post composed for Show and Tell.

[Randy_Shoemaker]

Looks like it’s doing what I need! Will wait for final instruction to test it out. Thank you for your help on this.

[Justin_Barrett]

Here’s the Show and Tell post outlining the process, including a link to a sample base so you can dig in and see all the formulas involved.

Automatic Sequential Numbering of Non-Sequential Items (READ JUN 9 2021 FOLLOW-UP) Show and tell

Summary This setup allows Airtable to automatically number collections of items that may not be in sequential order. Item length can be either fixed or variable, with only minor changes needed to the core system to accommodate the latter. Example To borrow from the thread that inspired this endeavor, say you’re building product codes that have a variant sub-code, and want that sub-code to automatically increment each time an item of a given product code is added in a new record. However, it n…