Help

Doubled values with Lookup field

Topic Labels: Base design
Solved
Jump to Solution
511 2
cancel
Showing results for 
Search instead for 
Did you mean: 
SpelaU
6 - Interface Innovator
6 - Interface Innovator

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)" ?

SpelaU
6 - Interface Innovator
6 - Interface Innovator

@Sho Thank you so much!