Hello
We currently have a working model set up through SolidWorks PDM.
A lot of information is in drop-down lists, so far, everything is ok.
However, our increasingly international work forces us to have documents (mainly Nomenclature) in English while our entire list system is built in French.
So my question is, in a PDM data map, is it possible to use a lookup table to populate a new variable that depends on the first one?
Let me explain, we are currently filling in a variable "PartDesignation" via a drop-down menu driven by a list (Plate, Imprint, Ejector, ...), we would like to create a variable "PartName" which would be filled in automatically, thanks to a lookup table, according to "PartDesignation".
Example, if "PartDesignation"=Footprint then "PartName"=Cavity
The lookup table would just be an English translation of our current lists.
I have already seen that it is possible to create a list with Alias, it seems to work but forces us to have two different lists and will force users to choose from a drop-down menu for "PartDesignation" in a list and do the same for "PartName" with a second list with the risk of making a mistake:(
Thank you for reading.
Julian
Hello
In the input formula area of your new field, you can call another variable and thus control its filling (only works on an edit field type that you can make read-only).
The line would correspond to something like this: %PartDesignation(Footprint=Cavity,xxx=yyy )%
For my part, I used Excel and a piece of VBA code to format the line.
Hello
There is a tool in the Visiativ myPDMtools tool suite that allows you to create dynamic lists:
This is the DynamicList tool: https://help.visiativ.com/mypdmtools/2022/fr/DynamicList.html
You can test myPDMtools for 30 days: https://www.lynkoa.com/mypdmtools
Have a nice day
1 Like
Cyril.f Thank you for your proposal, I tested it and it works perfectly. This solution is viable for a fairly short list (because there are limited characters in the input formula) and does not require an additional tool such as myPDMtools.
We are lucky to have myPDMtools, for the moment we only used docPrinter without exploiting the other features.
Thank you prossignol for your proposal which perfectly fulfills our request and above all opens the possibilities to translation into other languages easily, now all you have to do is :)
Have a good day to you and thank you for your support.
1 Like