Skip to main content
Solved

Doubled values with Lookup field

  • July 28, 2023
  • 2 replies
  • 20 views

Forum|alt.badge.img+10

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

Best answer by Sho

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

2 replies

Forum|alt.badge.img+21
  • Inspiring
  • Answer
  • July 28, 2023

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


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • July 31, 2023

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


@Sho Thank you so much!