I’ve been using Airtable for a million different things, and I love it. At work (web publishing) we use it as a database of our content and it’s incredibly helpful. But in parallel we use Trello as a project management system, and there is no possible cross-over (even with Zapier) so we often have to enter the same information in both apps, which is quite a waste of time. So I’ve been thinking that we could switch everything over to Airtable, but I have a few reservations. Maybe you guys can give me some pointers?
Here’s our set up: we have one base, with tables for our content, a table of clients, a table of writers, and a table of social media posts. They all cross-reference each other so it’s important that they remain in the same base. However, my main concern in moving Trello (where you can have personal boards) to Airtable is privacy.
Would it be possible to have team members create their own “personal” table in that base, which no other team could see? It would, again, be important to have these tables in the same base, so everyone can cross-reference the team data with their personal task list, for example.
In the same vein, if we invite collaborators (our freelancers), is it possible to hide certain tables from them (pretty much the table where we keep track of their rates, so they don’t start whining that others get paid more!)
And my last question would be about notifications; we rely heavily on Trello’s desktop and email notifications, so I want to make sure that Airtable’s work properly.
Thank you in advance for your kind help!