RRH_Middle_Mana - profile

RRH_Middle_Mana · Oct 11, 2022

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...

RRH_Middle_Mana · Oct 17, 2022

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...

RRH_Middle_Mana · Oct 14, 2022

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 ...

RRH_Middle_Mana · Oct 13, 2022

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)

RRH_Middle_Mana · Oct 13, 2022

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...

RRH_Middle_Mana · Oct 12, 2022

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 ...

User Statistics

User Activity

Comparing records from different tables in same base

Re: Comparing records from different tables in same base

Re: Comparing records from different tables in same base

Re: Comparing records from different tables in same base

Re: Comparing records from different tables in same base

Re: Comparing records from different tables in same base