I would like to customize part numbers that would also auto-generate. Can the auto-generated values be put together with formulas? Or programming?
Ideally, the number would incorporate initials from the person/company who originated the order and include a alpha value based on the type of part.
For example:
Company name: Widgets, Inc
Order includes: Machined parts
The part number should be something like: WID-MH-A1000
Thanks!
Hi,
You may use string formulas to achieve this.
Let’s say the “Company Name” field locates in A1 and “Machined parts” in A2.
You can create a C1 field and configure a IF() so that when A1 equals to “Widgets, Inc”, show WH in C1.
With the same logic, you can apply IF() in C2 so that when A2 equals to “Machined parts”, show MH in C2.
Then, create a new field and use string formulas to combine the field value of C1, C2, and the auto-generate field.
Alternatively, if you have too many selections in company name and it’s hard to put them all in the IF(), you may also use link & load to load the correct alpha value from your client sheet.
I have same issue but i cannot get auto-generate field. Can you help me in trouble ?
How can i get WH-MH-00001 in E2 ?
Hi,
If you want your part number to appear in E2 as “WH-MH-00001”, you will need to create an additional auto generate field to automatically generate the number “00001”. Let’s assume this new field is in A3.
Next, you should change the field type of E2 to Free Text. Then, you can set up a string formula in E2 like this:
C1 + ‘-’ + C2 + ‘-’ + A3
This will combine the values from C1, C2, and the auto-generated field in A3 to produce your desired part number format.
If you have any more questions or need further assistance, feel free to ask!
OMG, Best regards!
I almost gave up on that one, thank you so much!!! 
