Aly
02/22/2026, 6:56 PMCeligo AI
02/22/2026, 6:56 PMAI generated answer (using internal Slack threads):To source the actual record related to a saved search, you can use the
{recordname.fieldname} formula. The recordname in your formula is the ID of a join. You can create a search on the record that you're working with and then use the formula builder and the field dropdown. Find the field that you're after and then see what it translates to.
If the field you are looking for is not available in your formula, you may need to create another field to select your sales order, and then have a second field source data from the sales order select field.
For example, if you are trying to get the primary contact info from an invoice saved search, you would need to go to the customer record, since that's where the contact is. Select the "Customer Fields..." linked record and then select the "Primary Contact" field there. If you need more of the contact's details than just the name, you'll need to run a customer record saved search, or choose a different reporting method.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
02/22/2026, 6:56 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835144103
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833862305
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829040527
Celigo AI
02/22/2026, 6:56 PM