I would like to create a dashlet listing contacts who do not have a certain type of activity scheduled.
I've tried a comnbination of smart groups and include/exclude search, which works but does not update in real time.
Volunteers need to see the immediate result if they make an appoitment for a client, the client needs to disappear from the list. Otherwise they will be worried that they haven't done it correctly, and it won't inspire confidence in the system.
I've looked at Views but if I create a view with Contact as the main entity, I try to add a relationship to Activities but Activities does not come up as an option.
I'm about to write a hook that tags and untags contacts when the appointments are made, completed or cancelled. Do I really have to do this? It seems there must be another way!