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 gett...
Thanks for your patience mate. I ended up adding the PK formula from the Vollie Check In table as a field in the Roster table and used that as the referenced field.
Stupidly when trying to match a Date field automations won’t let you compare it agai...
Airtable makes me want to :sob:
Why oh WHY does it work on ID and not Name? The user is inputting Name aren’t they? Or do I need to use ID because they’re linked records?
I realised both Vollie fields were actually linked records pointing at the ...
The Vollie field in the Roster table is a linked record - is that my problem? (So is the Vollie field in the submitted form once the record is created in the Vollie Check In table)
Thanks heaps Adam,
I reckon I’ve got a handle on most of that, but I gotta be doing something stupid when trying to find the respective record in the Roster table.
I’ve set the automation to trigger when the form is submitted, then I have a Find Reco...
Thank you for offering to help!!
Here is the Vollie Check In table:
This is the Roster table:
And here’s a snippet of the Vollie Check In Form that everyone is supposed to fill in:
The only way I currently know who hasn’t completed their check in ...