Is there any way to automatically trigger a Custom Workflow Activity every time any Entity's record is opened?
Sure, you could use the ExecuteWorkflow
request from some JavaScript that runs on Form Load. Here's an example of calling ExecuteWorkflow
from JavaScript.
http://www.mscrmconsultant.com/2013/03/execute-workflow-using-javascript-in.html