Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two tables: client and phonecalls
clients table stores all clients
the phonecalls table stores all outgoing calls
my question is, how to insert on table's client the latest attempt phone call
Ex:
below the last_phone_call for "erik" should be "13-07-2019 11:00"
for "evan "should be "22-06-2019 10:00"
client table
ID | NAME | last_phone_call |
1 | erik | |
2 | evan |
phonecalls table
id_client | phonecall_date |
1 | 01-04-2019 15:00 |
2 | 05-04-2019 9:00 |
2 | 22-06-2019 10:00 |
1 | 13-07-2019 11:00 |
see attached qvw
hope this helps
Try this :
=Aggr(Max(phonecall_date),NAME)