Comparing records from different tables in same base

1974 10
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Here’s the scenario:

I have two tables I use for managing volunteer shifts:

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.


10 Replies 10

All good man; glad you got it all sorted!

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