We use the simple projects functionality to track and invoice time against jobs.
I've modified one of the sample Advanced PDF Invoice templates reasonably successfully, however am having trouble getting just the project name to appear on the PDF. The field that I've found is "entity" which appears in the XML structure as ${record.entity}, however in our system that looks like this: 9999 Customer Name: Project Name: SubProject Name (e.g. 8546 Microsoft Corporation: Report on Bill's House: Supplementary Report). The number at the start is the Job number (i.e. project number) not the customer number.
I'm trying to work out how to get just the project name - or at least remove the customer name from the text. Using the above example, I would like to see 8546 Report on Bill's House: Supplementary Report
I've seen something about joins in the field reference, but cant find any documentation on how to use them - not sure if I'm able to join the job table and get just a name? Alternatively is it possible to do some kind of substring function within the template?
Can anyone help?
Thanks
Andrew