Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 28, 2023 03:56 AM
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
Solved! Go to Solution.
Jul 28, 2023 05:34 AM
How about using the Rollup field instead of the Lookup field and making the formula "ARRAYUNIQUE(Values)" ?
Jul 28, 2023 05:34 AM
How about using the Rollup field instead of the Lookup field and making the formula "ARRAYUNIQUE(Values)" ?
Jul 31, 2023 01:23 AM
@Sho Thank you so much!