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
Solved! Go to Solution.
Solved by michelle.stone. Go to Solution.
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?
There's a tutorial on the Wiki for Computed Fields - this should help!
For string concatination - here's a quick example with name and prefix:
Hope that helps!
Michelle
Thanks Michelle.
I'll be studying your Wiki link and catching up on your webinars this evening!
You are appreciated.
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.
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.
Michelle
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?
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.