I need to display time booked to projects included on the Invoice PDF in a separate table on a subsequent page of the invoice. How would I do that?

AI generated answer (using internal Slack threads):

To display time booked to projects included on the Invoice PDF in a separate table on a subsequent page of the invoice, you would need to use SuiteScript to run a search that retrieves the time entries related to the projects on the invoice. Then, you would inject this data into the Advanced PDF/HTML template of the invoice. Here's a high-level overview of the steps you would need to take: 1. Create a User Event script that triggers on the beforeLoad event of the Invoice record. This script will be responsible for running the search and injecting the data into the template. 2. In the script, use the

record.id

to run a search that retrieves the time entries related to the projects on the invoice. You would need to use the

Search

module of SuiteScript for this. 3. Once you have the search results, format them into a JSON object or an array that can be easily iterated over in the Advanced PDF/HTML template. 4. Inject this data into the

record

object using the

record.setValue

method. You can add it to a custom field on the record that is hidden on the form but accessible in the template. 5. In the Advanced PDF/HTML template, add a new table on a new page that iterates over the injected data and displays the time entries. Please note that this is a high-level overview and the actual implementation may vary based on your specific requirements and the structure of your data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******