Skip to main content
Solved

lookup - most recent entry

  • January 26, 2023
  • 3 replies
  • 25 views

Forum|alt.badge.img+4
  • Participating Frequently

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!

Best answer by Alexey_Gusev

Hi,

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

like this:

 

 

3 replies

pressGO_design
Forum|alt.badge.img+21

You can do a rollup with MAX(values). 


Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • Answer
  • January 27, 2023

Hi,

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

like this:

 

 


Forum|alt.badge.img+4
  • Author
  • Participating Frequently
  • January 27, 2023

perfect, thank you!