Help

Re: Avoiding duplicate values in lookup fields

Solved
Jump to Solution
2547 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sri1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello'

I am trying to create a table 'Customer Interested Events' which maintains basic customer information (customer e-mail is PK) and additional fields  (selectable fields) 'Event Category' , 'Event Location'.

Based on the customer interested events another table 'Event Manager' would be populated which is linked with above table 'Customer Interested Events'. Purpose of this table is to assign a suitable manager against each Event Category. The PK in this table is a computed field "Event Category+Location" and has additional fields like 'customer name', 'location','event category' (lookup fields from the linked table), 'event manager'.

I am trying to maintain one unique record against each (event category, location) with all corresponding customer names, locations merged in the respective fields (if multiple customers booked for the same event category, location) so that one manager can be assigned.

While merging customers against an (event category,location), I could see PK  has repeating values as lookup fields have duplicate values, if multiple customers booked for same event,location.

Please suggest how we can avoid duplicate values in lookup fields 

Thanks

 

1 Solution

Accepted Solutions
Sri1
5 - Automation Enthusiast
5 - Automation Enthusiast

I found an alternate way to achieve this. Thanks for sharing feedback in short time.

Thanks

 

 

See Solution in Thread

3 Replies 3

You cannot remove duplicates from lookup fields. You can convert the lookup field to a rollup field and use the ARRAYUNIQUE(values) function to remove duplicates. Note that if you are pulling values from two or more tables away, correctly configuring the rollup and lookups involved can get a bit trickier. 

Sri1
5 - Automation Enthusiast
5 - Automation Enthusiast

I found an alternate way to achieve this. Thanks for sharing feedback in short time.

Thanks

 

 

Thomas_de_Beauc
6 - Interface Innovator
6 - Interface Innovator

Hi 👋I came up with a pretty satisfying solution using the Scripting automation. You can find it here