AnsweredAssumed Answered

Semi smart Part numbering Input formula and aliases

Question asked by Alison Hilditch on Aug 13, 2012
Latest reply on Aug 14, 2012 by Alison Hilditch

Hi there,


I figure this might be a common question, but my search keywords wern't turning up anything close to what I was looking for. So if there is a thread on this topic I would happily skip in that direction.


I'm trying to build a semi intelligent part number using drop downs on a data card. I have a basic version using an input formula running nicely. However, the part numbering system we are switching to is slightly more complex at least in options and looks something like this:




the A denotes component type, Assembly (A) or Part (0)

the B denotes the Project

the C denoted the Engineering system (like electrical (E) or Power System (P) for example)


01-99 are purchasing/manufacturing's category code for the item


random 5 digit serial number


dash number for tabulated parts


I have the serial number, dash number, and Component type covered, but what I want to know is how can I build an input formula without having the aliases be a mile long?

For Project I would have to have %[Project](P1=A,P2=B,P3=C...............P26=Z)%

For Category code I would have to have 01-99 aliases and I'm attempting to save time and my typing finger.


Does anyone have a solution or suggestion on how to go about doing this? Maybe a list somewhere that It could reference?

I was thinking of having the variable at least on the project card ,for example, that keeps track of the Project letter (as I can't seem to have serial letters be generated without it being from a list which is on my todo list as well), but that was giving me trouble.