Comparing records from different tables in same base

[RRH_Middle_Mana]

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!

[TheTimeSavingCo]

All good man; glad you got it all sorted!

RRH_Middle_Managemen:

Stupidly when trying to match a Date field automations won’t let you compare it against another field - just against a static date.

Yeah, it’s a bit of a head scratcher sigh