Skip to main content
Question

Rollup of Text Fields

  • May 13, 2025
  • 3 replies
  • 92 views

Forum|alt.badge.img+3

I’m trying to rollup a text field within an AT interface. I’ve created a Lookup field which is correctly showing duplicate results. However, I want to rollup the duplicates so the result only shows once.

Results of my look up are the following:

  • Transactions
  • Policy
  • Policy

The two “Policy” records are identical and I’d like to roll those up. I’ve tried the rollup up functions, but they seem to only work on values rather than text.
 

3 replies

Mike_AutomaticN
Forum|alt.badge.img+28

Hey ​@Jennifer_Zinnia!

Rather than creating a lookup, you’ll want to create a Rollup -and have the formula within the rollup to be:

ARRAYUNIQUE(values)


You can read more about rollups, and how to set them up step by step on this article.

Hope this helps!

Mike, Consultant @ Automatic Nation


Forum|alt.badge.img+3

Thanks ​@Mike_AutomaticN . I’ve tried that and throws an error, which led me to believe that was more for values rather than text.

 


Forum|alt.badge.img+3

I was able to resolve the error by deleting the field and re-adding it.