AnsweredAssumed Answered

how to sort a table based on records from another table

Question asked by mbust on Aug 3, 2018
Latest reply on Aug 29, 2018 by mbust



I have two tables, Contacts, and Notes. The notes are notes taken after calling each contact. Now I want to sort the contacts based on the ones that I have either called most recently or that I have not called recently (that is in ascending or descending order depending on the timestamp of the calls). Keep in mind that I am not talking about sorting the notes, but about sorting the contacts based on the notes. I could make a script that copies the timestamp of the note to the contact, and then sort that, but I was hoping to find something slightly more direct. Is this possible? If so, how? Thanks!