The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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 ...