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.