AnsweredAssumed Answered

Calculation based on most recent record by individual basis.

Question asked by ezeitgeist on Aug 5, 2016
Latest reply on Aug 26, 2016 by ezeitgeist

I have a Meetings table, and a Contacts table. I have created a calculation that changes the button in a portal orange if the meeting is over 30 days old, so I know to reach out to the person. That said, I have multiple meetings with Contacts. Is there a way for the button color change to only look at the most recent meeting date with EACH Contact?

 

Instead of everything past 30 days old being orange, I want just to target the most recent meeting with each individual (because of course if I have 4 meetings and the last one is over 30 days the others will be over 30 days as well, but I don't want to see that).

Outcomes