Here’s the scenario:
I have two tables I use for managing volunteer shifts:
Roster
Vollie Check In
A number of people forget to complete the Vollie Check In and I have to chase them up every day. If it was a paid job there’d be the incentive of getting paid only when you complete your check in, but as it’s voluntary I’m left herding cats every day.
What I want to do is either:
- Create a view that filters Vollies who haven’t completed their check in that then triggers a daily automation email reminder, or
- Skip the view altogether and create an automation that compares the respective Vollie field in each table for Today() and triggers the aforementioned automation.
I haven’t been able to find anything to compare records in respective tables in the community forum.
Thanks!
