Skip to main content

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.
 

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

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

 

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

Reply


Terms & Conditions