Is is possible to add to a report the Reference ID of a project entered in a typeahead custom field?

[LCarper]

I would like to display on a report not only the project name listed in a typeahead field but the reference number for that same project, is this possible?

[Richard_Le_ · Accepted solution]

Hi,

Yes this is possible with a bit of text mode. If you add a column to your report and paste the following text mode (replace "Typeahead Field Name" with the name of your typeahead field) you should find that the reference number of the project selected in the associated typeahead field will be displayed.

displayname=T/Ahead Ref Number
valueexpression={DE:Typeahead Field Name:referenceNumber}
valueformat=HTML

Best Regards,

Rich.