Hi all,
I'm attempting to add a new field to the Case entity which will track the last activity date for a particular case, but with a little extension. I want to track the last activity done by a particular user. The end goal here is to send an auto-generated email if there is no activity for a case for 24 hours, letting the customer know that the case will close should there be no further activity for another 24 hours. I have found many guides like this one https://www.qgate.co.uk/knowledge/using-a-rollup-field-to-add-last-activity-date-to-a-case/ that get me 90% of the way there, but I am unable to filter by the owner of the activity (or something similar). Any suggestions?
Thanks in advance.