You may have to create a new list by using From SQL Database i guess.
or the simplest way is to create a separate lists for the stock number and partnumbers and allow users to select them both.
Hope this helps.
The problem is the guys on the floor know the parts by stock type and purchasing knows it by the part number so there both need it to be on the drawings.
I’m new at Administrating EPDM and would have no idea even where to start building a data base like that that would work.
You can do it a for a short list using the imput formula but it's limited to 1024 characters so it would only work for a small list. Looksing at your above list of part numbers and descriptions, you would run out of characters fairly quickly.
The only other way to handle this is via an add-in where it populates one field based on your selection of the other.
We have faced the same problem.It is not possible to use "Display Data" when using List with Alias.For this we did a workaround.
1. Created list with entries as follows (DiplayValue*Alias)
User selects one of the value from this list and using input formula,the value is divided and stored in two variables.
Looks ugly on card,but does the job.
Glad to hear some else did this but I am still a little confused I am new to EPDM can you tell me in more detail? is that made as a normal list? and how did you gret the input forumula to seprate the varables?
@Ravi, Great idea. I love it. I may be able to help you with the "ugly" list. See my reply to Craig below.
@Craig, Here's what you do. In your current list leave the Displayed Value alone and change the alias value to be the Displayed Value with a * character plus the current Alias like Ravi showed.
Add the following fields to your data card
Set the Droplist Items to Special value of CopperMaterialAlias.
The Input Formula for the Stock type is $Left(%StockList%,$Find(%StockList%,*)).
Since the part number of your stock is always 15 characters long the Input Formula can be a little simpler, $Right(%StockList%,15).
When the user selects a value in the droplist, the stock type and part number will be filled out accordingly. Pretty cool.
That's really cool!
I'm asking a lot now, but is there a way to make it a little longer and have its finish number included? Would another special character be needed?
lets say the finish number is 50.
is that possible and if so what would I putting the alias field and how would the formula go?
Thanks for everyones help!
@Craig, If I understand what you want here's one way to do it. You can add the finish number to the Alias like so:
BAR,0.0375 X 2.00*50*CPR-2-037502000
For your Finish field the input formula will be $Mid(%StockList%,$Add(1,$Find(%StockList%,*)),$Sub($FindReverse(%StockList%,*),
This only looks complicated. I put the finish in the middle of the alias so the other input formulas don't need to change. Plus, I've accounted for the fact that your finish string length may vary.
@Joy, What Ravi's saying is that in your example the value for Stock Type will be the alias, not the displayed value.
It worked perfectly!
The only thing I did to make it look better was I gave the pull down menu a variable called StockMat_EPDM ( I gave it no attributes) and named a Edit Box the StockMaterial and hid it under my company logo so it can’t be seen making it appear little cleaner.
Is there any good place that talks about Input Formula and programing it? Solidworks help is really lacking here…
Great Idea Ravi! I wish I could mark both as right anwsers!
Maybe I'm missing something - why not just define the PartNumber as an Input Formula of the StockType?
Select the editbox control for the PartNumber variable, RMB on Input formula, Variables and select StockType.
Whenever you select the StockType, it will fill the PartNumber variable with the associated alias.
With tha,t Stock type will not be usable.If we use Stock type in a template..we will still be getting part number value.