Skip to main content
Solved

How to add a sales rep to my contacts page using the lookup function pointing to my interactions tab?


I have a contacts tab with all of my customers and their contact information. I’d like to add a ‘sales rep’ column. The sales rep information is on my second tab, interactions. Every time my sales rep enters an interaction for one of my customers multiple times, their name shows up multiple times on the contacts tab for that customer. I just want the sales reps name to show up once. I’ve attached an image to help illustrate what I’m talking about. Any help would be appreciated.

Best answer by ScottWorld

Try changing the lookup field to a rollup field with the formula ARRAYUNIQUE(values) and see if that works.

View original
Did this topic help you find an answer to your question?

2 replies

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8764 replies
  • Answer
  • April 28, 2022

Try changing the lookup field to a rollup field with the formula ARRAYUNIQUE(values) and see if that works.


  • Author
  • New Participant
  • 1 reply
  • April 28, 2022
ScottWorld wrote:

Try changing the lookup field to a rollup field with the formula ARRAYUNIQUE(values) and see if that works.


That worked!! Thank you so much.


Reply