I need a saved search formula that can concatenate all transaction document numbers or ids within a grouped saved search

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you want to concatenate all transaction document numbers or ids within a grouped saved search. You can achieve this by using a formula in your saved search. Here's a general approach: 1. In your saved search, go to the Results tab. 2. Add a new line and select

Formula (Text)

as the type. 3. In the formula field, use the

CONCAT

function to concatenate your fields. If you want to concatenate the internal id and the document number, your formula might look something like this:

CONCAT({internalid}, {tranid})

. This will create a new column in your saved search results that contains the concatenated values of the internal id and the document number for each transaction. Please note that the

CONCAT

function only works with two arguments. If you need to concatenate more than two fields, you can nest

CONCAT

functions like this:

CONCAT(CONCAT({field1}, {field2}), {field3})

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******