AnsweredAssumed Answered

Input Formula for Description Concatination

Question asked by Tim Mrazek on Sep 16, 2013
Latest reply on Sep 20, 2013 by Tim Mrazek

We are in the middle of a EPDM implementation and until about 1 Hour ago I was to believe that one field cannot be set to update with the the current values of certain fields. I have come to find this is not true. We are designing data cards with the details that the engineers would be using to describe the part and create a description. We have many different types of parts and require a complex description builder. Prior to learning about this feature I was going to design a SQL query that pulled the information I required and created a data export for my ERP system to concatenate the information. This would be a complex setup and am glad that input formulas exists, as I think it will solve my issue. I have having configuration roadblocks though.

 

Say that we have a main raw part category of Cord and sub categories of Conductive and RTD. Under those categories there are details that differ greatly (Shape - Conductive, Calibration - RTD). I would just put the variables in the input formula box, lined up in the correct order, but the value is not descriptive enough, as there is no descriptor of the value. Example: CORD, Conductive flat SJOEW 150 120 16 copper yes 8 2 none

These values need a description, but with the RTD sharing the same data card, and many other categories are like this, it would be impossible to put a string value in a position if it will not represent a possible value for all parts of the cord category.

 

Any help is appreciated

Outcomes