Fusion Manage Forum
Welcome to Autodesk’s Fusion Manage (formerly Fusion 360 Manage) Forum. Share your knowledge, ask questions, and explore popular Fusion Manage topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Concatenate Fields? Descriptor this...

7 REPLIES 7
SOLVED
Reply
Message 1 of 8
jdavis417
739 Views, 7 Replies

Concatenate Fields? Descriptor this...

First, is the "Descriptor" available to me for use in new fields?

 

Second, how can I "concatenate" fields together to accomplish something similar?

 

Thanks In Advance,

 

John

7 REPLIES 7
Message 2 of 8
jdavis417
in reply to: jdavis417

Here's an attempt to use a Computed Field... see the formula @ bottom...

I don't know how to format the text... is there a guide?

 

PROJECT_ID_SCREEN_CAP.png

Message 3 of 8
michelle.stone
in reply to: jdavis417

There's a tutorial on the Wiki for Computed Fields - this should help!

http://wikihelp.autodesk.com/PLM_360/enu/Community/Tips/Configuring_Fields/Computed_Fields%3a_Small_...

 

For string concatination - here's a quick example with name and prefix:

concat.png

 

concat2.png

 

Hope that helps!

Michelle



Michelle Stone
Technical Marketing, PDM & PLM
Autodesk, Inc.
Message 4 of 8
jdavis417
in reply to: michelle.stone

Thanks Michelle.

I'll be studying your Wiki link and catching up on your webinars this evening!

You are appreciated.

Message 5 of 8
jdavis417
in reply to: jdavis417

Oh, BTW, I did discover "Item Descriptor" in the Workspace Field entry box (after making a Field a Picklist...), the referring  WS's Descriptor is not exactly what I needed.  I'll be trying the concatenation method OR simply displaying more fields in my Default View.

Message 6 of 8
michelle.stone
in reply to: jdavis417

When I wear my 'end user' hat, I find I prefer to set up my own left filter views rather than relying on the descriptor anyway.  

filter.png

 

Michelle



Michelle Stone
Technical Marketing, PDM & PLM
Autodesk, Inc.
Message 7 of 8
ForrestJudd
in reply to: jdavis417

I have a somewhat related question - what if I wanted to concatenate only part of a field with another using a computed field?  For example

 

Field1 = Test

Field2 = 123

 

I want Field3 = Tes12

 

which is the first three characters of Field1 and the first two characters of Field 2.  I've tried syntax like

 

Field1.substring(0,3) + Field2.substring(0,2)

 

Field1.substr(0,3) + FIeld2.substr(0,2)

 

Field1.slice(0,3) + Field2.slice(0,2)

 

 

 

None of those will work in a computed field.  Can I get a substring of another field?  I've tried even just getting the substring of one field and that doesn't work either.  I've also tried casting it, like so

 

CAST(Field1 as String).substr(0,3)

 

That doesn't work either.  Is there a more general reference on the syntax for computed field formulas?  

Message 8 of 8
jpiggee
in reply to: ForrestJudd

Forrest,

For the particular solution that you are looking for, this would be best obtained by using a Javascript behavior coding, which is a lot more powerful and flexible then the available SQL scripting that comes with the Computed fields. 

Joseph Piggee
Fusion 360 Administrator
TPI Composites
jpiggee@tpicomposites.com

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report