Help

lookup - most recent entry

Topic Labels: Base design Data
Solved
Jump to Solution
767 3
cancel
Showing results for 
Search instead for 
Did you mean: 
andyh
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

Hi,

I suppose tables are linked. You should add rollup field, choose {date_field} in settings and type MAX(values)

like this:

Alexey_Gusev_0-1674784241844.png

 

 

See Solution in Thread

3 Replies 3

You can do a rollup with MAX(values). 

Alexey_Gusev
12 - Earth
12 - Earth

Hi,

I suppose tables are linked. You should add rollup field, choose {date_field} in settings and type MAX(values)

like this:

Alexey_Gusev_0-1674784241844.png

 

 

andyh
5 - Automation Enthusiast
5 - Automation Enthusiast

perfect, thank you!