SKU number generator

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
Hi all,

Is there any way I auto-generate a sequential number and include it to the SKU number without depending on the record ID? (last 3 digits)

I'm still figuring things out and these are my following results as it is still dependant on the RecordID:


This is my code:

([Code]& "-" &
[Equipment Type] & "-" 
& Right("000" & ToText([Record ID#]),3))

I want to be able to create the SKU number based on the sequential # of that specific number type. Hence, the ideal results would be for the number to automatically generated, given the condition that it is the same type of item.

8652674-210-001, 8652674-210-002, 8652674-210-003....
8557-233-001, 8557-233-002, 8557-233-003...

Any help or idea to implement this would be greatly appreciated!

Thank you.

Photo of Samuel Goh

Samuel Goh

  • 382 Points 250 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
It can be done. You will need a table of item types where the key field is the item type. Then a relationship to the items.

Then a summary maximum of the increment counter portion of the SKU.
Then look that up down to the items,
Then make a snapshot of yhat lookup,
Then add 1 to it for the next item.

It’s a bunch of work to set up and awkward to get the numbering stared when you have existing data.

You will have to decide if it’s really worth spending hours getting it built and the data loaded. You would need an SKU override field to load the initial data..