Track Row Duplicates Like a Sub-SKU

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

Thanks, @JonathanBowen.

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

But thank you!

-Randy

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.

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

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.