-
Re: Tabulated Part Numbers
The only real solution I have thought of is to Assign a drawing number that EPDM generates to each part, for example, 12345. This is set to read only and cannot be changed. Then the part number is manually entered by the user to include the tabulation (12345-01). As EPDM keps track of configurations and creates a new tab for each configuration, Part Number does not update all configurations. The user can then input the next configuration tabulation (12345-02). Does this seem like an acceptable solution? Are there any large flaws other than human error at input? I'm sure I could write an API that would match the first 5 digits of the drawing and part number to confirm they are identical.
Thanks!
-
Re: Tabulated Part Numbers
Alison,
What we did was have a "Number" field on our file card for the dash number.
We created a "Part Number" field on the card using an input formula consisting of our DrawingNumber field concatenated with a dash character and the dash number. I also added some parameters to pad single digit numbers since we always use two numbers for the dash number.
-
Re: Tabulated Part Numbers
Ah! I was wondering about the capibilities of the input formula. So does the dashed number generate automatically? how does it work for each configuration/part? This is the direction I'd like to move in, Thanks!
-
Re: Tabulated Part Numbers
Our users enter it manually. Sometimes they create more than one configuration for a given assembly, (i.e. open position, closed position) which have the same part number.
-
Re: Tabulated Part Numbers
So does that mean the formula is like a check so that the only entry it will accept is one that fits the formula? And does that mean you use "Number" as your part number variable as a whole or just for the dashed number portion? i'm a little confused with how you called the variable Number in your formula.
-
Re: Tabulated Part Numbers
Sorry, I now see that my screenshots have mislead you.
The Number edit box shown in the first screenshot is for the dash number. The second screenshot shows the input formula which is tied to the "Part Number." So Number must be between 1 and 99 and it is used by the Part Number input formula. %Number(1=01,2=02,3=03,4=04,5=05,6=06,7=07,8=08,9=09)% is what is called an input formula alias. This takes the value of number and substitutes the value after the equal sign if it matches the value before the equals sign. You can read about this in the Adminstration Guide. Like I said before, I only did this to ensure that the suffix has 2 digits.
-
Re: Tabulated Part Numbers
Okay! I get it now! The alias makes perfect sense as I've had to do that same sequence work around in other programs. So my next question is how does the formula end up working? Do you have separate boxes for drawing number and dash number that are filled out and then combined in the Part Number box? I'm just trying to form a process for this in my head to understand. The admin guide felt a little underdeveloped in their explanation. Thanks!
-
-
Re: Tabulated Part Numbers
Woo! Thanks! You have been so helpful! I am excited to get this thing running
-
-
-
-
-
-
-
-
