using a saved search ,how to get the link of the file in the communication subtab of a transaction

AI generated answer (using internal Slack threads):

To get the link of the file in the communication subtab of a transaction using a saved search, you can follow these steps: 1. Create a new saved search for the transaction type you are interested in (Sales Order, Purchase Order, etc.). 2. In the Criteria subtab, add a filter for "Main Line" and set it to "No". This will ensure that the search results include line items and not just the main transaction record. 3. In the Results subtab, add the fields you want to display in the search results. To get the file link, you need to add a field using a formula. The formula should be a text type and use the following syntax:

'<a href="https://system.na1.netsuite.com/'||{file.url}||'" download="'||{file.name}||'">Download</a>'

This formula creates a hyperlink using the file's URL and names the link "Download". Replace 'https://system.na1.netsuite.com/' with your account's URL. 4. Save and run the search. The search results should now include a "Download" link for each file associated with the transactions in the search results. Please note that this method only works if the file is attached directly to the transaction record. If the file is attached to a message or other communication related to the transaction, it may not appear in the search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******