Creating composite fields?

mikealderson · ‎05-24-2016

I am building an app (using Fuji), and noticed that there are Composite fields in the Project and Demand applications. When I attempted to create a new field in my app there is no Composite Type to select (I double checked on global and if doesn't exist there either). Has anyone created their own composite field?

Composite fields look better on reports than 2 separate columns

Chuck Tomasi · ‎10-21-2016

If you REALLY want to use composite fields, turn off the reference qualifier on the Type field and you can choose it. I don't recommend this lightly and support may not help you if you run in to problems.

Set your application to Global in the application picker
Set your update set to Default in the update set picker
Go to sys_dictionary and create a new field
Right click on the Type field label and choose Configure Dictionary
In the Reference specification section, change the reference qualifier to Simple.
Save the record.
You can now choose Composite in the type field of the sys_dictionary form.

View solution in original post

Chuck Tomasi · ‎10-24-2016

How did it go John?

Chuck Tomasi · ‎10-24-2016

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.

Thank you

john_duchock · ‎10-24-2016

worked like a charm...however...

Sorting is not possible on the composite field, so special care should be used to avoid using fields that are popular list sorts
The URL link is provided to the second field by default, so again, special care should be afforded to avoid using second fields that might drive a user to a record they should not have access to (adding "assigned_to" as second field allows users to view the technician profile)

i also pushed the envelope a bit and created a composite field of both a URL type and an HTML type to see which (if either) would work and if it would impact which value was a link. The result was that

- URL First Value / HTML Second Value

HTML Value displayed the HTML code with a link that drove the user to the incident record
URL value displayed as an unclickable URL

- URL First Value / HTML Second Value

HTML Value displayed as unclickable HTML code
URL value displayed clickable link to URL

It would be nice if Composite Fields were joined together with Hierarchical lists to allow a user to expand a list item and see more (and clickable) information, however this does suit our need for today !

Thanks again for your help Chuck !

Chuck Tomasi · ‎10-24-2016

Thanks for sharing the information John.

Chuck Tomasi · ‎05-24-2016

Hi Mike,

My notes from Fuji training (Dec '14) indicates that composite field type is not available to customers. Rob's response may be why. Someone could have been looking forward. 🙂

If it is really important that you have one, you can call support or open a HI ticket and get assistance that way.