I'm evaluating Airtable and so far think it seems very well made. But I'm having trouble determining if I can do what I want to do. I feel like it is a fairly straightforward need but can't find the path. One note, I don't write any sort of code so it would need to be some sort of built in feature/process. I know I can do this by creating a alternate view, but I want to control access to the Volunteers base such that not all users who can see/edit the Members base can also see the Volunteers info.
So, I want to have one base called "All Club Members" that everyone can view/edit, with basic member info, and another called "Volunteers" with only a few users able to view/edit, where there would be deeper member info. In the All Members base I want a checkmark field such that if it is checked their record is automatically synced to the Volunteer base. Once synced to the Volunteers base, I'd want that record to have more columns than it had in the All Members base so I could add the additional information.
And if possible (buy I doubt this one) - if a checked member name in the All Members base is then unchecked, the record would be removed from the Volunteers base.
I have tried creating the check box, setting up an automation, run a test and that worked. But once I try to add an action (I tried "create a record") I get lost.
Thanks for any thoughts or advice on this.