Topics help categorize Community content and increase your ability to discover relevant content.
So does anyone have any current workarounds for getting data from a cross referenced object into a report, maybe through custom Text? (e.g., Project "Hiring Manager" name showing in each task line in a Task in Task Report?)
Hi Dan and Sophie,
We realized this issue a few months ago and use the following as a workaround.
1 - When we create the typeahead field we add <ta> to the end of the field name.
2 - We create a corresponding calculated field.
For example, Manager <ta> = the typeahead field
Manager <tac> = the calculated field - calculation = Manager<ta>:name
Using this method pulls the calculated field, Manager <tac>, into the object table where it is used and eliminates the need for users to search for the typeahead on multiple objects or as individual tables in the reporting module.
Let me know if you have any questions.
Have you been able to pull any other custom fields from your type ahead field other than name & ID. I am looking to pull custom form data from Company and use the type ahead field on an issue.
Can you give me a little more context here? I am able to create a typeahead field using Company and a calculated field that then captures the input the user selects and place it on an Issue form. Is the Company data that you want to pull something other than the Company name?
Thanks for your reply, yes the information I am trying to get is other fields on a custom form, for example we have an Account Code that we store against the Company. I would like to load this in an issue report or in a custom field on the issue.
All I can seem to populate is the name or ID. Just seeing if anyone has been able to pull custom form data through a typeahead field.
No, I can not use a typeahead field to capture inputs from a custom field. I would use a calculated field. Not sure if you've already tried that or not.
Sorry maybe I didn't explain it well enough. I am trying to use a typeahead field for company name to input the company against the issue. Then on a issue report display the company account code which is a custom form field on company.
I can't find a way to do this, if you could explain if this can be done with a calculated field please ?
Hi Michael -
No, I haven't been able to do that. It sounds very much like some of the new functionality that I'd expect to see with the implementation of conditional visibility of information from one field to another.
If you don't have very many companies in your instance, you may want to create a drop-down with the company account code as the associated values and then pull that into the report.
Wish I could help more,
Thanks for your reply, I have since established that I can get to the URL field and fixed cost and revenue so I am doing some thing with those for now.