Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Doubled values with Lookup field

Topic Labels: Base design
Solved
Jump to Solution
820 2
cancel
Showing results for 
Search instead for 
Did you mean: 
SpelaU
7 - App Architect
7 - App Architect

In table 1, I will collect the personal data (+ product data) of customers who want to advertise the purchased product via the form.
In table 2, I would like to keep a list of all customers (with all personal data) + which complaint cases they have + the total sum of all complaints they have (per customer).
How to connect the tables to each other so that all personal data that comes from the form (in table 1) is transferred to the customer table?
I already tried with lookup fields, but if the same customer has two different complaint cases, the values are doubled.

https://airtable.com/appAHXw6BaUIsoBE5/shrjZYXs9PpqyquLy

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

How about using the Rollup field instead of the Lookup field and making the formula "ARRAYUNIQUE(Values)" ?

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

How about using the Rollup field instead of the Lookup field and making the formula "ARRAYUNIQUE(Values)" ?

@Sho Thank you so much!