5 Replies Latest reply on Aug 14, 2012 3:34 PM by Alison Hilditch

    Semi smart Part numbering Input formula and aliases

    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.