Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 29, 2019 09:01 AM
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?
Mar 29, 2019 10:05 AM
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
Mar 29, 2019 10:17 AM
Thanks, @JonathanBowen.
I know of this. I’m looking to track it with less manual input.
But thank you!
-Randy
Mar 29, 2019 11:44 AM
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.
Mar 29, 2019 01:08 PM
Looks like it’s doing what I need! Will wait for final instruction to test it out. Thank you for your help on this.
Mar 29, 2019 04:24 PM
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.