Jan 26, 2023 12:46 PM
I have a 'customer' table (one row per customer - name, email etc), and I have a 'contact' table that records the date of every instance of a customer contacting us (customer ID, date of contact etc). How would I pull in 'date of contact' into the customer table, but rather than all contact dates being pulled through, only the most recent?
So - kind of like how you'd use 'distinct' in SQL, sorted by date
Thanks!
Solved! Go to Solution.
Jan 26, 2023 05:52 PM
Hi,
I suppose tables are linked. You should add rollup field, choose {date_field} in settings and type MAX(values)
like this:
Jan 26, 2023 04:00 PM
You can do a rollup with MAX(values).
Jan 26, 2023 05:52 PM
Hi,
I suppose tables are linked. You should add rollup field, choose {date_field} in settings and type MAX(values)
like this:
Jan 27, 2023 02:29 AM
perfect, thank you!