AnsweredAssumed Answered

How to reference source/destination user data in a wire report?

Question asked by Caleb Youker on Mar 15, 2016
Latest reply on Mar 17, 2016 by Earl Hasz

On both electrical and hydraulic schematics, we use the components attached to each end as a part of the identifier for that wire/hose.

 

For example, if a hose has a straight fitting on one end and a 90 degree elbow on the other, the part number ends with "-00-90"

 

I have been adding '00' or '90' to our hose ends as we set them up under 'user data 1' - I'd like to pull this reference in my hose list, but am having trouble figuring out how to reference it.

 

Anyone have this level of knowledge with the formulas?

 

Here's what I'm using:

use_data_1 + '-' + STR(length/25.4, 3, 0) + '-' + '00' + '-' + '00'

 

Where the two '00' at the end I want to replace with the proper reference to origin user data 1 and destination user data 1.

 

Is this possible?

 

Thanks!

Outcomes